William Benton
New Member
- Joined
- Apr 26, 2015
- Messages
- 7
I have a formula that returns what is in a certain cell in column B.
I want the formula to see if there is a "/" in the cell (column B) and if so check for "/" and return what is to the right of "/" and if not return what is in the cell.
This one catches the first "I" - the formula is:
=IF(COUNTIF(SCHEDULE!$F$5:$F$29,"I")>=ROWS($1:1),INDEX(SCHEDULE!B9:B29,SMALL(IF(SCHEDULE!$F$5:$F$29="I",ROW($1:$25)),ROWS($1:1))),"")
If this could be reduced I am all ears.
I don't see if I can attach a sample anywhere.
Bill
I want the formula to see if there is a "/" in the cell (column B) and if so check for "/" and return what is to the right of "/" and if not return what is in the cell.
This one catches the first "I" - the formula is:
=IF(COUNTIF(SCHEDULE!$F$5:$F$29,"I")>=ROWS($1:1),INDEX(SCHEDULE!B9:B29,SMALL(IF(SCHEDULE!$F$5:$F$29="I",ROW($1:$25)),ROWS($1:1))),"")
If this could be reduced I am all ears.
I don't see if I can attach a sample anywhere.
Bill