Formula or else ???
Solved/Closed
GALAPAGO
-
Jan 14, 2010 at 03:59 PM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 14, 2010 at 04:44 PM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 14, 2010 at 04:44 PM
Related:
- Formula or else ???
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
3 responses
tompols
Posts
1273
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
Jan 14, 2010 at 04:18 PM
Jan 14, 2010 at 04:18 PM
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..
PERFECT !!!! YAHOOOOOOOOOOOOOOO!!!!!!!!
If you were closer I would kiss you all over................
THANKS -THANKS - THANKS--------------------------TOMPOLS
If you were closer I would kiss you all over................
THANKS -THANKS - THANKS--------------------------TOMPOLS
tompols
Posts
1273
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
Jan 14, 2010 at 04:44 PM
Jan 14, 2010 at 04:44 PM
:)