Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to code it in excel?
Copy of message from Excel General Question - 9/26/2006 1:22 AM PST
Does anyone know on how to code on following condition in this group? [row 1] a blank row [row 2] 10, which should be equal to the last value in row 3 [row 3] 10 [row 4] a blank row [row 1] a blank row [row 2] 23, which should be equal to the last value in row 4 [row 3] 23, which should be equal to the last value in row 4 [row 4] 23 [row 5] a blank row [row 6] 41, which should be equal to the last value in row 9 [row 7] 41, which should be equal to the last value in row 9 [row 8] 41, which should be equal to the last value in row 9 [row 9] 41 [row 10] a blank row If the next row [10] is a blank one, then current row [9] is defined to be the last value. Does anyone know how to code above condition in excel? Could anyone give me any suggestion please? Thank you in advance Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
VB Code and Excel | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions |