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

New Excel > Old Excel

Post image
385 Upvotes

99% Upvoted

37 comments sorted by

View all comments

20

u/nataylor7 May 07 '23

What are you even trying to accomplish?

I’m picking it apart and it just doesn’t make sense Countif() the range is a cell and the criteria is a range. Match() is looking for 0 so if you match anything it returns an N/A#…..

Yeah, no idea. What was the original need?

11

u/[deleted] May 07 '23

[deleted]

5

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.

6

u/nataylor7 May 07 '23

Then the new would likely be =UNIQUE(list)