| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing multiple cell values
Hello All! I'm trying to do a compare of dollar values in a given row with non sequential cells (3). The data format is currency and I am looking for the least in price between the three. Some cells do contain $0.00. The minimum price 0 of course, has a code("S","UL",or"US") that needs to be replicated in a given cell in that row(column AD). The compare columns/row are H,M, & R. I do need to repeat the comparison all the way down the worksheet. Worksheet data begins in row 6. Thank you for any help you can offer -- scoobydoo2006 ------------------------------------------------------------------------ scoobydoo2006's Profile: http://www.excelforum.com/member.php...o&userid=35372 View this thread: http://www.excelforum.com/showthread...hreadid=551508 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| total value relating to cell values in multiple columns! | Excel Discussion (Misc queries) | |||
| Can I apply a "score" based on multiple cell values? | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
| Comparing cell values then labeling them based on comparision | Excel Discussion (Misc queries) | |||
Linear Mode
