I am identifying the duplicates in the sheet. What wrong with this query?

tprakash2211

=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1), 1)

Danielle Arteaga

My best guess, without seeing your sheet, is that the problem is coming from the last "1" in your formula. That "1" should be defining a range, and it doesn't look like it would be possible. If you remove it, so your formula is just this:

=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1))

do you get the intended result?