View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default 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).