comparison between 4 companies

[sajevan]

dear friends,

6 firms quoted for 1 item 6 different prices and i want to compar
these prices. can anyone help me.

(e-mail address removed)

 

[Frank Kabel]

Hi
and what do you want to compare?
1. The highest price:
=MAX(A1:A6)

2. lowest price:
=MIN(A1:A6)

3. Ranking:
=RANK($A$1:$A$6,A1)
also see: http://www.cpearson.com/excel/rank.htm

4. average:
=AVERAGE(A1:A6)