Wednesday 31 July 2019

worksheet function - How to get the second lowest value excluding zero and ignoring the duplicates in excel

I need to get the second lowest UNIQUE value excluding the zero and excluding any duplicate values.


This is a sample of my data:


0 
1
1
3
2
4
5

The value that I need is 2

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...