Hi,
I am trying to extract data in Excel using multiple criteria. i have this being done in Access Database but I wanted to check if Access is working the way it should. Attached is my data set. What i am trying to extract is WHERE (((SalesRep.[YTD PTQ %])>=1) AND ((SalesRep.[C YTD Sales])>=(3000000))) OR (((SalesRep.[YTD Growth %])>0.05) AND ((SalesRep.[C YTD Sales])>=(3000000)))
How do i do this in Excel?
Thanks for your help
Bookmarks