Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining an IF formula with FIND
I have a big ugly spreadsheet dumped from an external nondelimited file.
18 columns by 72000 lines (two files)... so... In one cell every so often there is a piece of data that I need to head the next two, three, four, five lines below it. It will ALWAYS be preceded by text "ING1AR", but "ING1AR" will not necessarily be the first six characters in the cell. I know I can filter for that, but that won't let me see the data that falls in the lines below it. I was hoping to create a column that basically said, IF that cell contains "ING1AR", tell me everything that comes after that. I know if I do "MID(cell,FIND...." I can pull out what comes after the text, but not how to combine that with an IF statement... Does that make sense? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF, ANd and SUM functions in a formula | Excel Worksheet Functions | |||
a formula combining 2 cells into a % | Excel Discussion (Misc queries) | |||
Combining formula | Excel Discussion (Misc queries) | |||
Combining IF AND & FIND Functions | Excel Worksheet Functions | |||
combining a Vlookup and Mid formula | Excel Worksheet Functions |