Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you find many data?
Hi guys,
in a excel file I have this kind of data: AKDTA AKTIM AKAVZ LVCOD 1090121 163209 16 MI10 1090121 182748 09 MI10 1090122 34439 21 MI10 1090122 54700 02 MI10 1090122 70124 01 MI10 1090122 75327 01 MI10 I'm looking for call the 3rd column value, being from the first: but "AKDTA" is never the same word: I wanna get all values of "AKAVZ" on the same line of "AKDTA" selected; so for 1090121, I wanna get: 16(for example in D1) and 09(in D2). Help me please!!! -- BBB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you find many data?
Easiest way is to apply n use autofilter
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "andrew" wrote: in a excel file I have this kind of data: AKDTA AKTIM AKAVZ LVCOD 1090121 163209 16 MI10 1090121 182748 09 MI10 1090122 34439 21 MI10 1090122 54700 02 MI10 1090122 70124 01 MI10 1090122 75327 01 MI10 I'm looking for call the 3rd column value, being from the first: but "AKDTA" is never the same word: I wanna get all values of "AKAVZ" on the same line of "AKDTA" selected; so for 1090121, I wanna get: 16(for example in D1) and 09(in D2). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you find many data?
thank u a lot.
but I need a different way than apply autofilter. do you have any idea else? thank u for ur interesting. -- BBB "Max" wrote: Easiest way is to apply n use autofilter -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "andrew" wrote: in a excel file I have this kind of data: AKDTA AKTIM AKAVZ LVCOD 1090121 163209 16 MI10 1090121 182748 09 MI10 1090122 34439 21 MI10 1090122 54700 02 MI10 1090122 70124 01 MI10 1090122 75327 01 MI10 I'm looking for call the 3rd column value, being from the first: but "AKDTA" is never the same word: I wanna get all values of "AKAVZ" on the same line of "AKDTA" selected; so for 1090121, I wanna get: 16(for example in D1) and 09(in D2). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you find many data?
but I need a different way than apply autofilter
do you have any idea else? well, if you want to extract it dynamically in another sheet ... Assume the table you posted is in sheet: x, cols A to D In another sheet, Assume the Input for x's col A ("AKDTA") will be made in A2, eg: 1090121 In B2: =IF($A$2="","",IF(x!A2=$A$2,ROW(),"")) Leave B1 empty In C2: =IF(ROWS($1:1)COUNT(B:B),"",INDEX(x!C:C,SMALL(B:B ,ROWS($1:1)))) Copy B2:C2 down to cover the max expected extent of data in x, eg down to C200? Minimize col B. Col C will return all the desired multiple line results from x's col C ("AKAVZ") all neatly packed at the top, dependent on the input in A2. Just amend the range in this part: INDEX(x!C:C ... to reflect the col in x that you want to extract eg if you want to extract x's col E instead, use: INDEX(x!E:E .. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | 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) | |||
FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions |