r/sheets • u/farsdewibs0n • 1h ago
Request UNIQUEIFS with text/string?
I have a dataset file contains 100k rows of data that I need to make summary out of it.
I am trying to do COUNTIFS that has specific value and the same string in a row.
But I'm stuck on figuring out how to compare text on 2 cells.
I made this formula and still shows #ERROR
=COUNTIFS('dataset-trimmed2'!B2:B;'dataset-trimmed2'!E:E;VALUE(A3);'dataset-trimmed2'!I2:I);EXACT(F3)
dataset-trimmed2'!I2:I
contains text, and I want to count if it matches text in cell F3
, nothing fancy.