Formula: Find largest value of each item

[blaksnm]

Hey guys
My table is like this (but more rows than this ex):

<TABLE style="WIDTH: 137pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=182><COLGROUP><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 2048" width=40><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 4096" width=80><COL style="WIDTH: 47pt" width=62><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 30pt; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19 width=40></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=80>Col A</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=62>Col B</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 60pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl66 width=80>Items</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 47pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl66 width=62>Value</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 2</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>105</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 3</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>96</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 4</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item C</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>105</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 5</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>75</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 6</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>76,8</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 7</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>45</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 8</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item D</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>78</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 9</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>36</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 10</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item E</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>120</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 11</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=80>Item C</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=62 align=right>119</TD></TR></TBODY></TABLE>

I now want to make a formula that respons "Max" i column C for each maximum value of the item "n" - like this:

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 2048" width=40><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2867" width=56><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2918" width=57><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1996" width=39><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 30pt; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19 width=40></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=56>Col A</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=57>Col B</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl65 width=39>Col C</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl68 width=56>Items</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 43pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl68 width=57>Value</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 29pt; BORDER-TOP: #cccccc 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl68 width=39>Max</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 2</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>105,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39>Max </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 3</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>96,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39>Max </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 4</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item C</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>105,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 5</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>75,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 6</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>76,8 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 7</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>45,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 8</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item D</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>78,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39>Max </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 9</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item A</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>36,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 10</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item E</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>120,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39>Max </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=19>Row 11</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #f3f3f3; WIDTH: 42pt; BORDER-TOP: #cccccc; BORDER-RIGHT: #d4d0c8" class=xl66 width=56>Item C</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 43pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl67 width=57>119,0 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69 width=39>Max </TD></TR></TBODY></TABLE>

I'm sure this can be done, but how?

Will anyone please guide me on this one?

 

[B4L4KS]

hi

your question is slightly confusing but try using an IF()

such as

=IF(item cell>number that you want,MAX,"")

item cell is the cell you want to look up
number you want is the highest number
MAX is what you want to appear
Note: create a cell with the word MAX in it, as its simpler

any help

Kristian

 

[blaksnm]

Didnt get it
Write in Norwegian?

 

[B4L4KS]

hi

ok

=IF(

cell that you are looking up items Col B Row 2 =105
is greater > that 105 or any value
True = MAX
False = "" blank

=if(ColBRow2>105,MAX,"")

create a cell that has the word max in it a reference it, as it works better

this is the simplest version i can write,

or am i on the wrong lines

kristian

 

[blaksnm]

Sorry kristian
I thinK you are on the wrong line her
My problem is not to find the max value of all values in the column B, but to find and mark the max value of represented type of item - identifying the max value of all items A, of all item B and so on.

 

[VoG]

Try this

Excel Workbook
	A	B	C
1	Items	Value
2	Item A	105	Max
3	Item B	96	Max
4	Item C	105
5	Item A	75
6	Item B	76.8
7	Item A	45
8	Item D	78	Max
9	Item A	36
10	Item E	120	Max
11	Item C	119	Max
Sheet1

 

[blaksnm]

Thanks, but ... didnt work

 

[VoG]

In what way didn't work?

Did you enter the formula using CTRL + Shift + Enter?

 

[blaksnm]

Yes a lot for your interest - I really appreciate it
I did the Ctrl+Shift+Enter
But my Excel is in Norwegianand the Ctrl+Shift+Enter did nothing
In addition: "IF" formula is named "HVIS" in my language and "MAX" is named "STØRST" - so it seems that this formula-thing will be unsolved.
Maybe a macro will do a better jobb after all?
- or if I mailed my example to you as a workbook perhaps the auto-translation in Excel would do the job with the formula?

 

[VoG]

Click in C2.

Type in the formula in Norwegian and with ; instead of ,

Hold down CTRL and Shift and press Enter.

The formula in the formula bar should be surrounded by {}

Copy down as far as needed.