| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last entry in a row
HI,
I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . , there are empty cells within each row (approx 18 columns wide). What I am trying to get is a formula that reads the last entry in the row even if there are empty cells on either side of it Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last entry in a row
Are there any 0s in the range? Will the numbers always be positive numbers?
-- Biff Microsoft Excel MVP "TUF" wrote in message ... HI, I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . , there are empty cells within each row (approx 18 columns wide). What I am trying to get is a formula that reads the last entry in the row even if there are empty cells on either side of it Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last entry in a row
There are no 0s but there are blank cells
Cheers "T. Valko" wrote: Are there any 0s in the range? Will the numbers always be positive numbers? -- Biff Microsoft Excel MVP "TUF" wrote in message ... HI, I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . , there are empty cells within each row (approx 18 columns wide). What I am trying to get is a formula that reads the last entry in the row even if there are empty cells on either side of it Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last entry in a row
Sorry I forgot to mention that there may be negative numbers infrequently.
Cheers "TUF" wrote: There are no 0s but there are blank cells Cheers "T. Valko" wrote: Are there any 0s in the range? Will the numbers always be positive numbers? -- Biff Microsoft Excel MVP "TUF" wrote in message ... HI, I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . , there are empty cells within each row (approx 18 columns wide). What I am trying to get is a formula that reads the last entry in the row even if there are empty cells on either side of it Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last entry in a row
Try this:
=IF(COUNT(A1:R1),LOOKUP(1E100,A1:R1),"") It'll return the rightmost number in the range. If no numbers are present it'll return a blank. -- Biff Microsoft Excel MVP "TUF" wrote in message ... Sorry I forgot to mention that there may be negative numbers infrequently. Cheers "TUF" wrote: There are no 0s but there are blank cells Cheers "T. Valko" wrote: Are there any 0s in the range? Will the numbers always be positive numbers? -- Biff Microsoft Excel MVP "TUF" wrote in message ... HI, I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . , there are empty cells within each row (approx 18 columns wide). What I am trying to get is a formula that reads the last entry in the row even if there are empty cells on either side of it Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last entry in a row
Thanks,
That's seems to have done the trick. Out of curiosity is there a left most version? Thanks again "T. Valko" wrote: Try this: =IF(COUNT(A1:R1),LOOKUP(1E100,A1:R1),"") It'll return the rightmost number in the range. If no numbers are present it'll return a blank. -- Biff Microsoft Excel MVP "TUF" wrote in message ... Sorry I forgot to mention that there may be negative numbers infrequently. Cheers "TUF" wrote: There are no 0s but there are blank cells Cheers "T. Valko" wrote: Are there any 0s in the range? Will the numbers always be positive numbers? -- Biff Microsoft Excel MVP "TUF" wrote in message ... HI, I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . , there are empty cells within each row (approx 18 columns wide). What I am trying to get is a formula that reads the last entry in the row even if there are empty cells on either side of it Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible sumproduct to find/sum the last entry in each row | Excel Worksheet Functions | |||
| Formula doesn't find last entry | Excel Discussion (Misc queries) | |||
| FIND THE LAST CELL ENTRY IN A ROW | Excel Worksheet Functions | |||
| FIND - Double entry | Excel Worksheet Functions | |||
| How do i use vlookup to find more than 1 entry | Excel Worksheet Functions | |||
Hybrid Mode
