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 |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com