I am identifying the duplicates in the sheet. What wrong with this query?
Options
tprakash2211
✭✭
=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1), 1)
Answers
-
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?
