Please help, trying to count how many rows match one rows data.

Hello,

Im sorry in advance if what I'm about ask sounds stupid.

I have a spreadsheet with lots of data and I have been using Autofilter but would like to automate the process as the spreadsheet is getting quite large now. I have about 20000 rows and have columns A to L being used. What I would like is a calculation that tells me how many rows out of the 20000 match the data thats in H20005 I20005 J20005 K20005 L20005 and display the result in say A1.

example

H I J K L

9 3 2 7 5


Just to be told how many times that exact result appears in the last 20000 rows however the data will always change so has to referenced to cell not the value.

If anyone can help me I would appreciate it as Im still a noob at excel.

Thanks in advance

Please post a small (20 rows) sample Excel file: my reading is that cells in H to K have values of 0 to 9 (?)

Screen Shot 2016-03-22 at 10.19.30.png

Thanks for your reply as from the top row. from columns H - L there is 0.0005 0.0011 -0.0002 0.0007 0.0009

What I'm hoping for is a calculation that would tell me from Row 2 - 20000 how many times that sequence appears on a particular row in the same columns.

I really appreciate your help.

See attached (based on guess at your requirement0

Column M is a "Helper" column

H22 is the Match value

I22 =COUNTIF($M$1:$M$20,$H$22)


Need to revise helper BUT need file not image.

Thanks very much, Thats pretty much perfect.

Testing with your numbers indicates my solution with helper columns will work.

Try it on your data.

You beat me to it.

If you have a solution, could you mark thread as solved ("Thread Tools" at top of first post).