| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help IfBlank use data from next cell
I am using the data in one of my colums as the input for a subtitle on
another spreadsheet. So I have =IF(ISBLANK(qryGraphExportStep4!K2),qryGraphExport Step4!K3,qryGraphExportStep4!K2), which works fine unless K3 happens to contain no data. My problem is if K3 is blank I want it to move down to K4 and pull that data and if K4 is blank down to K5 and pull that data, etc until K12. Any assistance would be appreciated, I am not very experienced with excel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
| converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| if function and ifblank() function | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
Threaded Mode
