Finding all matches across 4 columns

[Nathan Asius]

I have a simple but large worksheet of over 30,000 rows containing sentences and quotations etc... of various things said or written throughout history.
I have four columns that count total words, total letters, vowels, and consonants (not counting for punctuation or spaces).
I need a formula to look at the results across each of four columns, and find exact matches.
So for instance, if
B2 = 9
C2= 36
D2 =24
E2 =12
then I would like the formula to look through the same columns down all 30,000+ rows, and find if there are the same four matches, whether there's only 2, or up to any number of matches.
But I would like to do this for every possible match of any and all combinations across those 4 columns through all rows.

I don't even know which function to begin this task with.

For this sheet, I am using Excel for Mac 2019.

 

[awoohaw]

I freeformed this, so may need to debug any typos:
I'm unsure where your formula belongs though, you may get circular references with this.

=Let(data,$B$2:$E$30000,clm01,ChooseCols(data,1),clm02,ChooseCols(data,2),clm03,ChooseCols(data,3),clm04,ChooseCols(data,4),
ROWS(Filter(data,(clm01=$B2)*(clm02=$C2)*(clm03=$D2)*(clm=$D2),"")))

 

[Nathan Asius]

I attempted your formula awoohaw, but the FILTER function does not work in Excel for Mac 2019. I would suspect that LET also doesn't work either.

I freeformed this, so may need to debug any typos:
I'm unsure where your formula belongs though, you may get circular references with this.

=Let(data,$B$2:$E$30000,clm01,ChooseCols(data,1),clm02,ChooseCols(data,2),clm03,ChooseCols(data,3),clm04,ChooseCols(data,4),
ROWS(Filter(data,(clm01=$B2)*(clm02=$C2)*(clm03=$D2)*(clm=$D2),"")))

tt

 

[Nathan Asius]

I attempted your formula awoohaw, but the FILTER function does not work in Excel for Mac 2019. I would suspect that LET also doesn't work either.

tt

....and neither CHOOSECOLS

 

[awoohaw]

I attempted your formula awoohaw, but the FILTER function does not work in Excel for Mac 2019. I would suspect that LET also doesn't work either.

tt

your profile says you use 365, i missed the last sentence of your post.

But, please tell me what cell (and worksheet if it is a different sheet) do you want the formula in?
And also, when you say different combinations of those four columns, what do you mean? Some examples would be very helpful.

this is something, but i'm not sure it is what your really seek:

Book1
	A	B	C	D	E	F	G
1
2	text 2	9	36	24	12		2
3	text 3	7	16	4	23		3
4	text 4	5	11	34	28		1
5	text 5	4	19	35	7		1
6	text 6	7	16	4	23		3
7	text 7	11	36	10	18		1
8	text 8	18	17	26	29		1
9	text 9	24	15	4	18		1
10	text 10	32	5	12	19		1
11	text 11	9	36	24	12		2
12	text 12	14	28	30	31		1
13	text 13	35	35	4	34		1
14	text 14	18	16	27	4		1
15	text 15	16	22	6	15		1
16	text 16	23	10	4	6		1
Sheet1

Cell Formulas
Range	Formula
G2:G16	G2	=SUMPRODUCT((B2=$B$2:$B$17)*(C2=$C$2:$C$17)*(D2=$D$2:$D$17)*(E2=$E$2:$E$17))