Formula or else ???
Solved/Closed
GALAPAGO
-
Jan 14, 2010 at 03:59 PM
tompols Posts 1325 Status Contributor - Jan 14, 2010 at 04:44 PM
tompols Posts 1325 Status Contributor - Jan 14, 2010 at 04:44 PM
Related:
- Formula or else ???
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Formula spreadsheet definition - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
hello
try this in B22 : =IF(ISERROR(SEARCH("A";B5&C5&D5&F5&H5&etc...));"";"A")
i did not type the whole list of cells but it should work....
EDIT : sorry, missed the AC25...that's quite a lot of cells, could you give more explanations on your speadsheet and what you want to do, there must be another way to do it...otherwise some vba code....let me know..
try this in B22 : =IF(ISERROR(SEARCH("A";B5&C5&D5&F5&H5&etc...));"";"A")
i did not type the whole list of cells but it should work....
EDIT : sorry, missed the AC25...that's quite a lot of cells, could you give more explanations on your speadsheet and what you want to do, there must be another way to do it...otherwise some vba code....let me know..