Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up Help Needed
Let's say I have a data table where the top row contains this month's dates
and the row beneath contains a bank balance. I update the bank balance row each day with the prior day's balance. Also, there is a column to the far right called 'Daily Total.' See below: Daily Total Dates| 7/1 7/2 7/3 etc. Value| $1 $4 $5 etc. ? How can I have the "Daily Total" column return the most recent date's bank balance? Note, it is possible that the balance could be zero. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up Help Needed
=INDEX(A2:Z2,MATCH(MAX(A1:Z1),A1:Z1,0))
-- Regards, Peo Sjoblom "Bob" wrote in message ... Let's say I have a data table where the top row contains this month's dates and the row beneath contains a bank balance. I update the bank balance row each day with the prior day's balance. Also, there is a column to the far right called 'Daily Total.' See below: Daily Total Dates| 7/1 7/2 7/3 etc. Value| $1 $4 $5 etc. ? How can I have the "Daily Total" column return the most recent date's bank balance? Note, it is possible that the balance could be zero. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up Help Needed
Hi,
Provide you don't have a daily balance in excess of 100000000000000000000000 This should work =LOOKUP(10^23,A2:AE2) It will find the right most number in row A2:AE2 Mike "Bob" wrote: Let's say I have a data table where the top row contains this month's dates and the row beneath contains a bank balance. I update the bank balance row each day with the prior day's balance. Also, there is a column to the far right called 'Daily Total.' See below: Daily Total Dates| 7/1 7/2 7/3 etc. Value| $1 $4 $5 etc. ? How can I have the "Daily Total" column return the most recent date's bank balance? Note, it is possible that the balance could be zero. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up Help Needed
In other words, you want to return the *last* numeric value of the row?
Try something like this: =IF(COUNT(A2:AE2),LOOKUP(1E10,A2:AE2),"") -- Biff Microsoft Excel MVP "Bob" wrote in message ... Let's say I have a data table where the top row contains this month's dates and the row beneath contains a bank balance. I update the bank balance row each day with the prior day's balance. Also, there is a column to the far right called 'Daily Total.' See below: Daily Total Dates| 7/1 7/2 7/3 etc. Value| $1 $4 $5 etc. ? How can I have the "Daily Total" column return the most recent date's bank balance? Note, it is possible that the balance could be zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed please | Excel Worksheet Functions | |||
help needed | Excel Discussion (Misc queries) | |||
Help needed! | Excel Discussion (Misc queries) | |||
help needed | Excel Discussion (Misc queries) | |||
If Then help needed | New Users to Excel |