Finding unique value in excel with array formula
=if(and(entire 1st raw=entire 2nd row),"duplicate","unique")))
above formula will return a massage as typed above whether the value is unique of duplicate comparing with others value in other row.
note-this is array formula so use shift+control+enter.
=if(and(entire 1st raw=entire 2nd row),"duplicate","unique")))
above formula will return a massage as typed above whether the value is unique of duplicate comparing with others value in other row.
note-this is array formula so use shift+control+enter.
No comments:
Post a Comment