View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Using DGET to extract multiple records

About 400 rows need to be searched.


"T. Valko" wrote:

How many rows of data need to be searched? How about some details.

Biff

"Bob" wrote in message
...
Yes, but I'm looking for an automatic way (i.e., using a built-in function
or
UDF).


"Duke Carey" wrote:

Have you looked at Data-Filter-Advanced Filter?

"Bob" wrote:

Is there a way to use DGET or a UDF to extract multiple records that
match
the same criteria? Using a macro would be my 3rd choice.
Thanks in advance for any help on this.
Bob