| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel- find the last filled cells in column with empty cells
I have tried several times from other resources for help on this
problem to no avail. I have a sheet that data in column O is ever expanding with new data added to the bottom of the column. Example. 120 blank cell blank cell 175 blank cell blank cell blank cell 166 blank cell blank cell 450 blank cell blank cell blank cell blank cell 620 I am looking for a formula that will average the last three cells with data. In this case 166+450+620/3=412 Blank cell is random. Thank you in advance for your prompt attention to this matter. Steven R. Dekker |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel counting empty cells until first filled one | Excel Discussion (Misc queries) | |||
| Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
| Copy Data From Filled to Empty Cells | Excel Discussion (Misc queries) | |||
| How create a nonblank source for a verification list with a mix of filled & empty cells? | Excel Programming | |||
| What must I do to get gridlines printed for both filled and empty cells? | Excel Programming | |||
Threaded Mode
