Formulas finding text
Closed
Juniore
-
Aug 26, 2010 at 01:06 PM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - Aug 30, 2010 at 05:04 PM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - Aug 30, 2010 at 05:04 PM
Related:
- Formulas finding text
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
- Ms excel marksheet formulas pdf - Guide
- Excel formulas number to words - Guide
- Ps3 not finding update on usb - Guide
4 responses
Strange Junior, I can still find your second post. But since you can't here is my answer:
Hi Juniore,
Try this formula in column D and drag it down as far as needed:
Best regards,
Trowa
Hi Juniore,
Try this formula in column D and drag it down as far as needed:
=IF(ISERROR(SEARCH("American Express",C1)),IF(ISERROR(SEARCH("Mastercard",C1)),IF(ISERROR(SEARCH("Discover",C1)),"",B1),B1),B1)
Best regards,
Trowa
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Aug 27, 2010 at 08:16 AM
Aug 27, 2010 at 08:16 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.
Please don't double post to prevent confusion. I saw your second post first, so there you will find my answer.
Ambucias
Posts
47310
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
February 15, 2023
11,162
Aug 30, 2010 at 05:04 PM
Aug 30, 2010 at 05:04 PM
You would have less problems reading posts if you did not use credit card names for they are filtered and take a very long time to appear
Ambucias
moderator
Ambucias
moderator
Thank you for your response. I cannot find your first answer so my question is still unanswered. The moderator told me that my first questions had been removed, so i posted it again in a different forum, but now i cannot find your answer. I have been trying to find this solution for over 4 years and i guess i will never get it cuz you have the answer but I cannot find it. Thank you