Good morning Gary''s Student - gsnu200781
I just tried your example and the Excel function you provided and I found out
it is working OK!
Thank for your example:
http://groups.google.com/group/micro...nctions/browse

_thread/thread/b8a1a3dfa8ca813f/1c786a33cccf991e?
lnk=st&q=dog#1c786a33cccf991e


However, I have one question which need your further help. Because the size
of your database is too big for me, so I made it to 20 sample size (A1 to A20,
B1 to B20 etc.)

From your example, instead of JUST searching the data which has value of 7 in
col A, I want to list out all the information which has value of 7 between 【1
Jun 08】and 【30 Jun 08】. My new question has add an EXTRA crietria e.g. the
time frame e.g. between 【1 Jun 08】and 【30 Jun 08】? In the example of 20
sample data, the result will be actomactic appear "27-Jun-08" in cell F1 and
"gnu" in cell G1. I need an Excel formula to have this result! I know this
question is extremely challenging! Many thanks for your help!

Wilchong




Gary''s Student wrote:
Get can get the same result as AutoFilter by using formulas. See:

http://groups.google.com/group/micro...786a33cccf991e
Many thanks for your advice! I know AutoFilter is one option.

[quoted text clipped - 13 lines]
Many thanks,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1