Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine lowest number in several columns and replace lowest numb
with value from a specific cell
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine lowest number in several columns and replace lowest numb
On the face of it, 2 steps
Presuming the range is cols A to D, with the lowest number zero just place in say, E1: =MIN(A:D) to retrieve the lowest number Then select cols A to D, click Edit Replace to replace that lowest number with the desired value (Click Replace All) P/s: You should always post your *complete* query in the message area, not embed half of it in the subject line, half in the message area. The subject line is meant to contain just a brief, key summary descript of your query. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jerry" wrote: determine lowest number in several columns and replace lowest numb with value from a specific cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lowest number above 0 | Excel Discussion (Misc queries) | |||
Lowest number | Excel Worksheet Functions | |||
lowest number above 0 | Excel Discussion (Misc queries) | |||
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |