# excel match feature

#### AlanY

##### Well-known Member
ok, this is basically the post#7 trying to do but i was just too lazy to label the columns properly

Last edited:

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### simon31

##### Board Regular
could you please attach excel file with the new layout.?

#### simon31

##### Board Regular
thanks for that. How does the Y column work though ? sometimes it is reading 9 and 10 what are those values?

I was hoping for a filter column wherein if I chose the 8 numbers for a period of 3months
13 14 22 36 55 66 77 78

then the rest of the 12 numbers would have got blanked out , when I used the filter.

#### AlanY

##### Well-known Member
thanks for that. How does the Y column work though ? sometimes it is reading 9 and 10 what are those values?

I was hoping for a filter column wherein if I chose the 8 numbers for a period of 3months
13 14 22 36 55 66 77 78

then the rest of the 12 numbers would have got blanked out , when I used the filter.
I'm still not clear of the requirements, unfortunately.

I should have rephrased my question but there is no option to edit once posted

13 14 22 36 55 66 77 78

I have chosen the above 8 numbers and wish to do the following.

1) find out how many times there were 8 hits,7 and 6 hits, I use countif for that

2) When I check for 6 hits of the above 8 numbers, I get about 12 times as the answer with the countif formula

3) I wish to know now which of 6 hits out of the above 8 numbers came 12 times

There could be a mix of those 6 hits that came 12 times
At the moment I spend hours to find that out .
Is there a way I can quick filter that list or use a formula for that.?
to help understand, would you share the original excel file of 2) above.
may be then we can get to the bottom of it

#### simon31

##### Board Regular
Your table is good for x column hits.
What I am still missing is the filter column. I have attached snapshot how it should be after filter.

https://filebin.net/5xfs0z4e661l7jq3

If you could add a filter option on the Y column that could filter numbers I choose in row 1.
At the moment there are 8 numbers in row one, but I could input less than 8 numbers to see the filtered numbers say from one week to 1 year.
When numbers are filtered , I would also get to know on which dates those numbers hit.
I would then also get to know how many times those numbers came over a period of time, so that I then choose the next set of numbers carefully while playing keno.

#### simon31

##### Board Regular
Re: excel number filter and unfilter

Thanks for that .

But how do I unfilter to view the 20 numbers again.

Could you please add a unfilter option to the conditional formatting so I can switch back and forth between filtered numbers now in row1( which you have already donea) but also getting the 20 numbers back again.

unfiltered data

https://filebin.net/i9a81u08cnq1h1ey

Last edited:

#### simon31

##### Board Regular
Re: excel number filter and unfilter

ok I understand

The numbers in row one are 13 14 22 36 55 66 77 78.

Now I deleted the all numbers except 36 55 in row1, Because I wanted to view how many times the pair 36 and 55 appeared, unfortunately the unpaired numbers 36 and 55 appeared as well. I did not want to know how many times 36 appeared by itself or 55 appeared by itself.

All I want to view is only the number pairs 36 and 55 , so how do I filter and achieve that in Sheet2 ?

https://filebin.net/nt2txntct20f9ht5. snapshot of paired numbers and unpaired number.

Last edited:

1,101,940
Messages
5,483,813
Members
407,414
Latest member
MJN1965

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...