Find if the last entry has duplicate

Hi All,
to me this is really complex. the formula is not returning error but seems not to be giving me what i need .

COUNT(SELECT(WO Record[WO Number],IN([WO Number],{LOOKUP(MAX(WO Record[_ROWNUMBER]),“WO Record”,"_ROWNUMBER",“WO Number”}))))>1)

i would like to see if the latest entry in “WO Number” column has duplicate. i am using this in a workflow.
can somebody please assist if this formula is giving me what i need.
the test result comes a bunch of duplicate but still not running my workflow properly.
much thanks

0 2 373
2 REPLIES 2
Top Labels in this Space