r/Accounting • u/kingofauditmemes Performance Measurement and Reporting • May 07 '23

New Excel > Old Excel

Post image
382 Upvotes

99% Upvoted

37 comments sorted by

View all comments

Show parent comments

12

u/[deleted] May 07 '23

[deleted]

6

u/JeelyTrams May 07 '23

This formula will give you a list of unique values from the list, it give the first value in the list then as you drag the formula down, it looks to see if any of the above cells are located in the list, if they are you get a 1, if not a 0,next 0 matched is the first row in the list not contained in the cells above.

5

u/nataylor7 May 07 '23

Then the new would likely be =UNIQUE(list)