Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing columns
How can I do a compare of columns and have the lowest number display in a new
column? example; column a column b column c column d = lowest of a,b or c 0.498 0.53 0.5055 .498 0.22 0.3018 .22 1.77 0.031 etc. 0.033 0.734 1.72 0.026 0.022 0.075 0.926 0.115 0.075 0.0698 0.075 0.1091 18.003 0.079 0.11 0.1163 0.125 0.066 19.99 0.084 0.419 0.419 0.299 0.055 0.085 0.0408 0.103 0.114 0.12 0.31 0.198 0.2509 0.266 0.198 0.2509 0.263 0.198 0.2509 0.263 0.198 0.2509 4.25 4.782 4.25 0.8 0.409 0.409 0.845 0.538 0.51 2.47 1.55 1.49 0.41 0.266 0.25 2.54 1.608 1.48 1.5 0.79 0.78 1.39 1.185 1.115 2.35 1.846 1.54 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing columns
=MIN(A1,B1,C1)
copy down "pads64" wrote: How can I do a compare of columns and have the lowest number display in a new column? example; column a column b column c column d = lowest of a,b or c 0.498 0.53 0.5055 .498 0.22 0.3018 .22 1.77 0.031 etc. 0.033 0.734 1.72 0.026 0.022 0.075 0.926 0.115 0.075 0.0698 0.075 0.1091 18.003 0.079 0.11 0.1163 0.125 0.066 19.99 0.084 0.419 0.419 0.299 0.055 0.085 0.0408 0.103 0.114 0.12 0.31 0.198 0.2509 0.266 0.198 0.2509 0.263 0.198 0.2509 0.263 0.198 0.2509 4.25 4.782 4.25 0.8 0.409 0.409 0.845 0.538 0.51 2.47 1.55 1.49 0.41 0.266 0.25 2.54 1.608 1.48 1.5 0.79 0.78 1.39 1.185 1.115 2.35 1.846 1.54 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Columns to each other | Excel Discussion (Misc queries) | |||
comparing two columns | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
Comparing 2 columns if they are the same | Excel Worksheet Functions | |||
Comparing Columns | Excel Worksheet Functions |