Friday, 16 August 2013

excel large function issues when having duplicate values

excel large function issues when having duplicate values

ok so this must sound like a dumb question but i have a column with
numbers and some numbers may contain duplicate numbers. Lets say column A
has 20,20,10. When i do the large function for example =large(columnA,2)
it will give me 20 instead of 10. How do I fix that

No comments:

Post a Comment