| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lat populated cell
I have a spreadsheet that has a set number of rows 59 in this case. What
happens is each day an new row is populated with data i.e. today row 30 is populated tomorrow 31 is populated. At the bottom is a totals column. What I want is to have that total at the bottom to only show the info from the last populated row i.e. today will will show the totals from row 30 and tomorrow from row 31. Is there a formula that I can populated the bottom row with to check this out? TIA -- Cyberwolf Finder of Paths, Hunter of Prey Ghost of the Night, Shadow of Day The Wolf |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lat populated cell
Could expand following for column A ..its crude and only works if unpopulated
rows are empty =IF(ISBLANK(A3),IF(ISBLANK(A2),IF(ISBLANK(A1),0,A1 ),A2),A3) "Cyberwolf" wrote: I have a spreadsheet that has a set number of rows 59 in this case. What happens is each day an new row is populated with data i.e. today row 30 is populated tomorrow 31 is populated. At the bottom is a totals column. What I want is to have that total at the bottom to only show the info from the last populated row i.e. today will will show the totals from row 30 and tomorrow from row 31. Is there a formula that I can populated the bottom row with to check this out? TIA -- Cyberwolf Finder of Paths, Hunter of Prey Ghost of the Night, Shadow of Day The Wolf |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lat populated cell
XL is limited to 7 nested if statements so that probably will not work. you
can get around it using named ranges (formulas) but it is kinda cumbersome and would be a huge pain in this case... check out this link for more info... http://www.cpearson.com/excel/nested.htm -- HTH... Jim Thomlinson "Nicholas B" wrote: Could expand following for column A ..its crude and only works if unpopulated rows are empty =IF(ISBLANK(A3),IF(ISBLANK(A2),IF(ISBLANK(A1),0,A1 ),A2),A3) "Cyberwolf" wrote: I have a spreadsheet that has a set number of rows 59 in this case. What happens is each day an new row is populated with data i.e. today row 30 is populated tomorrow 31 is populated. At the bottom is a totals column. What I want is to have that total at the bottom to only show the info from the last populated row i.e. today will will show the totals from row 30 and tomorrow from row 31. Is there a formula that I can populated the bottom row with to check this out? TIA -- Cyberwolf Finder of Paths, Hunter of Prey Ghost of the Night, Shadow of Day The Wolf |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lat populated cell
Not 100% sure what you mean by Sum of the last populated row but what I can
tell you is that you are probably looking for the offest function... This will return the value of the last populated cell in Range A1:A30 (placed in Cell A31) =OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 1) If you want the sum of the last entry in Cell A1:B50 then try this... (placed in Cell A31) =SUM(OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 2)) -- HTH... Jim Thomlinson "Cyberwolf" wrote: I have a spreadsheet that has a set number of rows 59 in this case. What happens is each day an new row is populated with data i.e. today row 30 is populated tomorrow 31 is populated. At the bottom is a totals column. What I want is to have that total at the bottom to only show the info from the last populated row i.e. today will will show the totals from row 30 and tomorrow from row 31. Is there a formula that I can populated the bottom row with to check this out? TIA -- Cyberwolf Finder of Paths, Hunter of Prey Ghost of the Night, Shadow of Day The Wolf |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lat populated cell
Nice
"Jim Thomlinson" wrote: Not 100% sure what you mean by Sum of the last populated row but what I can tell you is that you are probably looking for the offest function... This will return the value of the last populated cell in Range A1:A30 (placed in Cell A31) =OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 1) If you want the sum of the last entry in Cell A1:B50 then try this... (placed in Cell A31) =SUM(OFFSET(A1,COUNTA(A1:A30)-1,0, 1, 2)) -- HTH... Jim Thomlinson "Cyberwolf" wrote: I have a spreadsheet that has a set number of rows 59 in this case. What happens is each day an new row is populated with data i.e. today row 30 is populated tomorrow 31 is populated. At the bottom is a totals column. What I want is to have that total at the bottom to only show the info from the last populated row i.e. today will will show the totals from row 30 and tomorrow from row 31. Is there a formula that I can populated the bottom row with to check this out? TIA -- Cyberwolf Finder of Paths, Hunter of Prey Ghost of the Night, Shadow of Day The Wolf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i restrict input in a cell until previous cell populated? | Excel Discussion (Misc queries) | |||
| First populated cell in row array/ Last populated cell in row arra | Excel Worksheet Functions | |||
| formula for a cell which is blank returns populated cell | Excel Discussion (Misc queries) | |||
| Find last populated cell in a row. | Excel Programming | |||
| Check to see if a cell is populated | Excel Worksheet Functions | |||
Hybrid Mode
