This is not conditional formatting. I have an unusual request and little hard to explain but I will try to make it simple and explain.
Let say I have data sets of total 100 numbers ranging from 1 to 100.
I want a formula that gives me two value after ignoring/removing bottom & top 10% of the data set. So the answer will be something like 11 & 90. Does that make sense or need more clarification?
My actual data has data sample of like 500 hundred numbers ranging from 30 to 80. I want to remove outliers (bottom 10% and top 10% from this 500 data sample and give me two numbers after removing the top and bottom 10% number. After removing the top and bottom numbers I want the starting point number and ending point of that data set.
Bookmarks