Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a list in B2 thru B11 which includes in this order.... 15 10 48 16 27
8 2 21 10 60 What I woujld like to do is highlight the range and have the 3 lowest numbers deleted, but I dont want them sorted first, the remaining 7 must stay in the original cells. Here's where it gets tricky, because 10 is one of the lowest 3 and there are 2 10's, I want to keep one of the 10's (it doesn't matter which one). So after all is done I would be left with 15 48 16 27 21 10 60 TIA, Dennis ================ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How do I drop the lowest 2 numbers and then average? | Excel Worksheet Functions | |||
Filling drop down box | Excel Worksheet Functions | |||
Filling drop down box | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |