how do you find many data?

  • Thread starter Thread starter andrew
  • Start date Start date
A

andrew

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!!!
 
thank u a lot.
but I need a different way than apply autofilter.
do you have any idea else?
thank u for ur interesting.
 
but I need a different way than apply autofilter
do you have any idea else?
Click to expand...

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