Get instant live expert help on if find excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
=IF(ISNUMBER(FIND("BULK",AM41)),"Bulk",IF(ISNUMBER(FIND("DR",AM41)),"Drum",IF(ISNUMBER(FIND("TO",AM41)),"Tote",IF(ISNUMBER(FIND("BG",AM41)),"Bag",IF(ISNUMBER(FIND("SS",AM41)),"Supersack",IF(ISNUMBER(FIND("PL",AM41)),"Pail",IF(ISNUMBER(FIND("BX",AM41)),"Box""ERROR")))))))
Solved by B. W. in 13 mins
I need to solve excel sheet to find % completed using formula and highlight the row if completed
Solved by D. L. in 20 mins
I'm currently using this code: =IF(ISNUMBER(FIND("XS",Q2)),1,IF(ISNUMBER(FIND("S",Q2)),2,IF(ISNUMBER(FIND("M",Q2)),3,IF(ISNUMBER(FIND("L",Q2)),4,IF(ISNUMBER(FIND("XL",Q2)),5))))) All of them are working apart from the last option of XL makes 5. Can anyone help as to why this is the only one that isn't working?
Solved by B. H. in 12 mins
Questions are about "Find" and "Replace" features under "Edit" on tool bar. I can "Find" a $ amount (ie: $3.50) in cells ONLY if I change "Look In" from "Formulas" to "Values." BUT, I when I click on "Replace" and the next screen comes up, the "Look In" drop down menu disappears and if I try to "Replace All" my $3.50 with $3.00 (for example) it says "Microsoft Excel cannot find matching data to replace." So, how do I "Replace All" for large quantity of $ amounts? Also, I used to be able to "Find All," NOT Just "Find" or "Find Next." How do you now "Find All" in current Excel version? I used to be able to do both in my older versions of Excel.
Solved by E. D. in 20 mins
if I find a "word "and copy all same word of excel and its related row and column , please help me
Solved by O. J. in 27 mins