| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Of Last Three Entries In Rotating Columns
Thank-you, that formula also worked great.
"daddylonglegs" wrote: For the last entry only try =LOOKUP(9.999999999999E+307,INDEX(E5:J16,0,MAX(IF( E5:J16<"",COLUMN(E5:J16)-COLUMN(E5)+1)))) "Peo Sjoblom" wrote: =LOOKUP(2,1/(A1:A20000<""),A1:A20000) for the last row in A1:A20000 adapt to fit =LOOKUP(2,1/(2:2<""),2:2) last column in row 2 -- Regards, Peo Sjoblom "Loadmaster" wrote in message ... That formula worked great, however I have one more question WRT the same spreadsheet. How do I retrieve the last entry from the last row and column? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding entries across columns | Excel Worksheet Functions | |||
| Rotating Rows To Columns | Excel Discussion (Misc queries) | |||
| Counting entries in 2+ columns | Excel Discussion (Misc queries) | |||
| common entries between 2 columns | Excel Worksheet Functions | |||
| Remove dup entries in 2 columns 70,000+ | Excel Discussion (Misc queries) | |||
Threaded Mode
