To all the brilliant minds on this board,
If i have a column of numbers in column A such as 13,13,11,5,2 and I want to subtract 2 from the highest number in said column and then show the results in column C. What kind of formula could I put into column B that would check to make sure i do not subtract from both of the 13 numbers. In other words I am trying to find out which number in column A is the highest and subtract 2 from that. That much is easy, the problem comes in when two numbers are the same and I only want it to effect the first number in the column.
I am open to any formula suggestions as opposed to a macro. Any thoughts would be appreciated.
Thanks in advance.