| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
String Formula
I want to check a cell for content and if there is none go to the next cell
in the colum and check.......etc. I have over 50 cells to check. ie.... in cell P2 I want to check I2 for content. if I2 is blank then check I3 and so on. If P2 has content then place it in I2. I want to continue that same query in P3 on down, without duplicating an answer. If P2 & P10 have content then that content needs to appear in I2 & I3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Improved String Formula | Excel Worksheet Functions | |||
| IF formula string | Excel Worksheet Functions | |||
| Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
| Formula to Replace or eliminate any sheetname(s) in formula string | Excel Discussion (Misc queries) | |||
| formula with text string | Excel Discussion (Misc queries) | |||
Threaded Mode
