excell 2003 help jt still asking..

J

john

maybe i explained it wrong..
i tried you suggestion but i get the same result. let me explain.

to be exact..the field>> rows D2 - D400 are the 400 items
and colums D - H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in.. i tried to drag the field of D2:H2 with
this format and i tried your suggestion.. however what happens is this, with
both suggestions..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt
 
J

JE McGimpsey

john said:
maybe i explained it wrong..

Please don't start a new topic - keep your replies in the old one or
nobody will be able to see what's already been suggested.

BTW - while it doesn't make any difference in this case, you should note
that you're posting to a Macintosh XL group rather than a Windows XL
group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top