Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to pull out the last day data in an array?
Dear All,
There is the issue I faced, I describe below, A B C D E F G 6/29/07 7/3/07 7/10/07 7/15/07 7/20/07 7/24/07 The lastest day's data Security 1 $70 $20 $35 $35 Security 2 $35 $80 $80 Security 3 $50 $75 $75 / / Security 50 $38 $38 Do any one know, which array formula I need to allow me can pull the latest day's data within Column A to Column F without manually type in? It can allow column G always get the latest data from the range I select. Thanks Vincent |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to pull out the last day data in an array?
See reply to your earlier posting (be patient!)
" wrote: Dear All, There is the issue I faced, I describe below, A B C D E F G 6/29/07 7/3/07 7/10/07 7/15/07 7/20/07 7/24/07 The lastest day's data Security 1 $70 $20 $35 $35 Security 2 $35 $80 $80 Security 3 $50 $75 $75 / / Security 50 $38 $38 Do any one know, which array formula I need to allow me can pull the latest day's data within Column A to Column F without manually type in? It can allow column G always get the latest data from the range I select. Thanks Vincent |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to pull out the last day data in an array?
Try this:
=IF(COUNT(A2:F2),LOOKUP(1E10,A2:F2),"") Copy down as needed -- Biff Microsoft Excel MVP wrote in message ups.com... Dear All, There is the issue I faced, I describe below, A B C D E F G 6/29/07 7/3/07 7/10/07 7/15/07 7/20/07 7/24/07 The lastest day's data Security 1 $70 $20 $35 $35 Security 2 $35 $80 $80 Security 3 $50 $75 $75 / / Security 50 $38 $38 Do any one know, which array formula I need to allow me can pull the latest day's data within Column A to Column F without manually type in? It can allow column G always get the latest data from the range I select. Thanks Vincent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from a file | Excel Discussion (Misc queries) | |||
Pull matching data | Excel Discussion (Misc queries) | |||
pull data for a company with data in diff cells multiple wrkshts | Excel Worksheet Functions | |||
Cannot pull any data from certain websites | Excel Discussion (Misc queries) | |||
Not all data in AutoFilter pull down | Excel Worksheet Functions |