Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've been searching for a while, but I am out of my league trying to
figure this one out on my own. I would like to compare three columns. A B C 1 .25 3 2 .50 3 3 .75 1 4 1.00 1 2 4 The first two are static, but the third will change daily. I would like to create a 4th column that compares cloumn C to column A and outputs the corresponding column B value in column D. So, in this example column D would read: D ..75 ..75 ..25 ..25 ..50 1.00 Thank you for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing to columns | Excel Discussion (Misc queries) | |||
comparing columns | Excel Discussion (Misc queries) | |||
Comparing Columns to each other | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
comparing columns | Excel Worksheet Functions |