Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the data of top cell ???
Hi I m having data in following format -
Cell_ID 4-Aug-07 5-Aug-07 6-Aug-07 7-Aug-07 8-Aug-07 9-Aug-07 10-Aug-07 11-Aug-07 12-Aug-07 MAX ABGRI1A 30 30 30 30 30 30 30 30 30 30 ABGRI1B 30 30 30 30 30 30 30 30 30 30 ABGRI1C 29 29 29 29 29 29 29 29 29 29 ABNR01A 14 14 14 14 14 14 14 14 14 14 ABNR01B 14 14 14 14 14 14 14 14 14 14 ABNR01C 14 14 14 14 14 14 14 14 14 14 ACHUN1A 13 13 13 13 13 12 12 12 12 13 ACHUN1B 9 9 9 13 13 9 12 12 12 13 ACHUN1C 13 13 13 13 13 12 12 12 12 13 ADAGL1A 14 14 14 14 14 14 14 14 14 14 ADAGL1B 14 14 14 14 14 14 14 14 14 14 ADAGL1C 13 13 13 13 13 13 13 13 13 13 ADUDP1A 29 29 29 29 29 29 29 29 29 29 ADUDP1B 29 29 29 29 29 29 29 29 29 29 In next column I need when was the max occured first from today. Like for cell ACHUN1A it was 8-Aug-07. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the data of top cell ???
Thats Great Bob... Thanks a lot....
Regards - Irfan Khan "Bob Phillips" wrote: =INDEX($A$1:$J$1,MAX(IF($B8:$J8=$K8,COLUMN($B8:$J8 )))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Irfan Khan" <Irfan wrote in message ... Hi I m having data in following format - Cell_ID 4-Aug-07 5-Aug-07 6-Aug-07 7-Aug-07 8-Aug-07 9-Aug-07 10-Aug-07 11-Aug-07 12-Aug-07 MAX ABGRI1A 30 30 30 30 30 30 30 30 30 30 ABGRI1B 30 30 30 30 30 30 30 30 30 30 ABGRI1C 29 29 29 29 29 29 29 29 29 29 ABNR01A 14 14 14 14 14 14 14 14 14 14 ABNR01B 14 14 14 14 14 14 14 14 14 14 ABNR01C 14 14 14 14 14 14 14 14 14 14 ACHUN1A 13 13 13 13 13 12 12 12 12 13 ACHUN1B 9 9 9 13 13 9 12 12 12 13 ACHUN1C 13 13 13 13 13 12 12 12 12 13 ADAGL1A 14 14 14 14 14 14 14 14 14 14 ADAGL1B 14 14 14 14 14 14 14 14 14 14 ADAGL1C 13 13 13 13 13 13 13 13 13 13 ADUDP1A 29 29 29 29 29 29 29 29 29 29 ADUDP1B 29 29 29 29 29 29 29 29 29 29 In next column I need when was the max occured first from today. Like for cell ACHUN1A it was 8-Aug-07. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving data to a cell, not pulling data to the cell | Excel Worksheet Functions | |||
Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) | Excel Discussion (Misc queries) | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |