Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Selecting nearest under in a list
I have a list of numbers and i need to either highlight (using conditional
formatting)or display in another cell the nearest number under 10000 i.e 9854 9752 11254 10987 9974 <--------- 10025 Help!!!!! |
#2
|
|||
|
|||
if your values are in column A then on the column B type this
=IF(A1=MAX(IF(A1:A6<10000,A1:A6)),A1,"") and array enter it (Ctrl+shift+enter) instead of enter This will place the value that is closest to 10K on column B "Purfleet" wrote in message ... I have a list of numbers and i need to either highlight (using conditional formatting)or display in another cell the nearest number under 10000 i.e 9854 9752 11254 10987 9974 <--------- 10025 Help!!!!! |
#3
|
|||
|
|||
Try...
=MAX(IF(A1:A6<10000,A1:A6)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "Purfleet" wrote: I have a list of numbers and i need to either highlight (using conditional formatting)or display in another cell the nearest number under 10000 i.e 9854 9752 11254 10987 9974 <--------- 10025 Help!!!!! |
#4
|
|||
|
|||
One way
=MAX(IF(A1:A6<=10000,A1:A6)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Purfleet" wrote in message ... I have a list of numbers and i need to either highlight (using conditional formatting)or display in another cell the nearest number under 10000 i.e 9854 9752 11254 10987 9974 <--------- 10025 Help!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |