Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Everyone
I've been reading these post for just over a year and I'm not bad with simple formulas. but when I see something like this,=IF(ROWS(C$2:C2)<=COUNTIF(A$2:A$6,"*xyz*"),IN DEX(A$2:A$6,SMALL(IF(ISNUMBER(SEARCH("xyz",A$2:A$6 )),ROW(A$2:A$6)),ROWS(C$2:C2))-MIN(ROW(A$2:A$6))+1),"") my head start spinning. Is there a book that specialize in that type of formulas.My problem is to follow the logic and proper syntax. Thank you for any suggestion and Happy New Year to all. Regards John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NESTED OR FORMULAS | Excel Discussion (Misc queries) | |||
Need help with IF nested formulas | Excel Discussion (Misc queries) | |||
how to do nested IF formulas | Excel Discussion (Misc queries) | |||
if nested formulas | Excel Discussion (Misc queries) | |||
nested formulas | Excel Discussion (Misc queries) |