| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting a reference when a value is less than 0
I have a set of worksheets (9) with dates in row 4
under each date (in row 7) I have a set of values that vary in numbers. I have a separte worksheet that would have the results of when the first date that the numbers in row 7 are less than 0. Is there a way that if the number in worksheet B is greater than 0, it would go to worksheet C and on until the first negative number is reached and then enter the corresponding date in a cell (say C7 in the results worksheet). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Column letter reference as number reference | Excel Programming | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Hybrid Mode
