View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scoobydoo2006
 
Posts: n/a
Default Comparing multiple cells


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=551446