Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value
Hi Column A has the month's dates which includes weekends. Column B has a lookup formula with the lookup being the date, which brings in values from another spreadsheet. There are only seldom values brough in over weekends. Column C has a daily budget How do I find the date against which the last data was brought in by the lookup? Hope I was clear enough. Thanks for your help. guys. -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=504327 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value
Not really clear Rob.
If B has a lookup on a date, exactly what date are you trying to determine? -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Brisbane Rob" wrote in message news:Brisbane.Rob.224ojz_1138087804.0682@excelforu m-nospam.com... Hi Column A has the month's dates which includes weekends. Column B has a lookup formula with the lookup being the date, which brings in values from another spreadsheet. There are only seldom values brough in over weekends. Column C has a daily budget How do I find the date against which the last data was brought in by the lookup? Hope I was clear enough. Thanks for your help. guys. -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=504327 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value
Hi Bob The date is used to get the data from a corresponding date in another spreadsheet. i.e. 1/20/06 will get a value from spreadsheet B which also has dates for the month. Thanks -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=504327 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value
Do you mean something like
=INDEX('Sheet B'!$A$1:$A$1000,MATCH(MAX('Sheet A'!B1:B200),'Sheet B'!$B$1:$B$1000,0)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Brisbane Rob" wrote in message news:Brisbane.Rob.2250tn_1138103703.8544@excelforu m-nospam.com... Hi Bob The date is used to get the data from a corresponding date in another spreadsheet. i.e. 1/20/06 will get a value from spreadsheet B which also has dates for the month. Thanks -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=504327 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value
No, Bob, I didn't explain myself well. If you have two colomns of data, column A containing date values, and column B containing a lookup formula, what formula can you use to find the last cell in column B that contains a value, bearing in mind that there will be gaps in column B (corresponding to the weekends) Hope that's clearer. -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=504327 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value
Thanks Bob, that seems to have done the trick. Now all I have to work out is how to read the date in the column to its left! Much appreciated -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=504327 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |