Hi,
Try below Formula with *Ctrl + Shift + Enter*.
=IFERROR(INDEX(Sheet2!$C$3:$C$15,SMALL(IF($B$32=Sheet2!$A$3:$A$15,ROW(Sheet2!$A$3:$A$15)-2,""),ROW()-33)),"")
Regards,
MARIES.
+971502420957
On Sat, Mar 3, 2012 at 7:05 PM, dguillett1 wrote:
> I’m not sure what you want. If?? you want to g
I’m not sure what you want. If?? you want to get all data from sheet2 for the
data >>> just use
data>filter>autofilter>filter on the date>copy. Develop a macro to do it for
you.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ashish Bhalara
Sent: Friday, March 02
