View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pads64 pads64 is offline
external usenet poster
 
Posts: 1
Default 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