How do i structure a IF(AND with 2 lookups????

sleepdoc

New Member
Joined
Jul 28, 2005
Messages
41
Happy thanks giving Everyone!

Here ismy question.

I have a array. I need filter it twice (but not by using the autofilter)

The syntax of the construct I imagine will work is unknown to me, but hereis what I would like to accmplish

I want to say

If a date I pick from a drop down list matches a date in the array

the populate a new array with all the rows where the dates match.

Let me see if i can clarify further

I have an array where each row (not coulmn)is the details of a particular sale of an item

This massive list of sales rows has a column called the "sale date"

I want to go through every row (every sale) and make a new array of only the sales that occured on a particular date. So for example

(Row) (sale date) (sale amount) (id#)

1 11/23/05 $5000 1
2 11/30/05 $3000 2
3 11/23/05 $2500 3
4 11/30/05 $1000 4


OK. So now what I wish to do is populate a new array whch goes as follows.

The user first picks the Sale date. if he were to pick the4 sale date of 11/23/05, then he would ge a new array with 2 sales. ID# 1 and id#3 with all the details of that sale.

I hope someone can steer us in the right direction. It seemed so simple when I started, however, I have been unable to find the solution. The autofilter will clearly fileter for the date, but it is not in a new, seperate array where i need it. I'm trying to filter out from a master table of all sales, just the sales made on certain days and then just the sales on thoise days by certain sales people so that I can then print out for them the sales they have completed no a day by day basis.

Thanks for the long read.!!!!

Glenn
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You could filter the data, then copy the visible rows to another location. Do the whole thing by macro.
 
Upvote 0

Forum statistics

Threads
1,217,500
Messages
6,137,008
Members
450,038
Latest member
JackOfBlades

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top