max value in a range

Hello, I need some help from the experts on this forum. As seen in the next example i need to known the line with the highest value for the keycode, in this example i have marked the row with an *. The keycode can exist once ore more than once and the complete list is around 60 000 rows...

I have no other solution than the one posted in the title for the data I'm working with. Basically, I need a formula that returns a 1 for the true if statment of the Highest number according to each combination of color and vehicle type. <TBODY> 9 Red Car 3 Blue Truck 2 Blue...

Hi I am confused as to which function would be best suited for the following situation. I have tried using vlookup, indirect, index, match and max with no success. I havent used excel since college in 2005. I have a feeling this is a fairly simple funtion but I have exhausted my brain digging...

I am trying to match two cells and put a unique number next to it. I have managed to recognize the two requirements and not fill the other cells unnecessarily but my equation will only output 1 and I cannot get it to add one to the previous cell that has a number, to end up with 2,3...

Hi all- I'm simply trying to find the max value in a range and select that cell. For values >0, the following works well. However, for values < 0, the entire range is selected. Any thoughts on how to remedy this? Sub GoToMax() Dim WorkRange As Range...

Hello guys, I've been trying to figure this out the whole evening yesterday and today, however I'm lost. This is the 3rd time i am trying to write a macros and most of the knowledge I have is through googling snippets of what I want it to do. What I have: Spreadsheet with column Area...

Hi Can anyone help me with a formula to tranform a set of rankings into tertiles (1-3). <TABLE style="WIDTH: 542pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=721 border=0 x:str><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706"...

Hi, This is my first time posting, so my sincere apologies if my "syntax" for the post is incorrect. Anyway, I would like to find the max value(s) in a range, and then vlookup(or something else) to return a list of the cell addresses where these max values are found. For example: Sub...

How do you get a maximum or minimum number based on two criteria (MAX or MIN if within date specified)? DATE (Column A) ---- NUMBERS (Column B) ---- MAX OR MIN OF SPECIFIC DATE (Column C) 12/1/2010 -------- 30.00 ------ Maximum for 12/1/10 is: ? 12/1/2010 -------- 30.10 ------ Minimum for...

Hi, Having a difficult time finding the difference between the maximum number and the smallest non-zero value that ignores text and any error messages. What I need to do is subtract the Maximum value in the column from the smallest non zero value. In the case below, it should take 7 minus 5...

In column D: from D1 to D12 there are 12 values (numerical only). In column E: from E1 to E12 there are 12 values (numerical only) & each rows of column E corresponds to the same row# of column D i.e. E1 corresponds to D1, E2 to D2 & so on till E12 corresponds to D12. In column D (from D1 to...