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 |
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 |