| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find most recent value in data range that includes SUM formulas
I have a series of cells that sum the columns above them (O12:X12) on
multiple worksheets. I would like to write a formula to report the cell that has a value and is the furthest to the right. I used: =LOOKUP(10^10,'Worksheet reference'!O12:X12) This worked on a previous worksheet when the data range contained values, but since O12 through X12 include SUM formulas, it's not working. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the most recent date | Excel Discussion (Misc queries) | |||
| what is the most recent version of Office (includes Excel)? | Excel Discussion (Misc queries) | |||
| How to find all formulas that used a certain named range | Excel Discussion (Misc queries) | |||
| =max(range includes #N/As) | Excel Worksheet Functions | |||
| How do I sum a range which includes the "#N/A" VLOOKUP return valu | Excel Worksheet Functions | |||
Threaded Mode
