search the Max Valeu in the Column J

Hi everybody
i need you help and my question is:
i will to implement a vba code which
search the Max Value in the Column J und write the related Value in the Column B in Cell K25

You'll need to give bit more detail.

Is there chance of duplicate Max value in J? If so how should tie be handled?

no we will have only one Max in J

Something like below. Assuming Row 1 contains headers.

Please Login or Register  to view this content.

hi,
i geht an Error by executing this code

Range("K25").Value = Cells(iRow, 2).Value doesnīt work

Upload sample workbook. Works without issue on my end.

the Values in E are a Parable coordinate, because date i want to search the isge Point in E and Then i subtract 10, that means i will have 2 Points in this graph.
i will get the Related Value for these 2 point from column B.

how can i attached the File?

the Values in E according to B are a Parable coordinate, because that i want to search the Peak Point in E and Then i subtract 10, that means i will have 2 Points in this graph.
i will get the Related Values for these 2 point in column B.
Max = -2,37
Max -10 = -12,37
i will search Value in E ,if i donīt find it then the next closest one due the symmetry of the Graph, i want to find 2 Values closest to -12,37.
after that to find the related values for this two Value in B and edit this Values in F

Umm, you had column "J" in original post... and since starting value for iMax was set at 0 in code. Negative values would have given error.

And logic is quite a departure from original request of finding MAX in J and corresponding value in B.

What's your expected values in F? Can you give some sample manually?

And define closest to -12.37. Is it absolute variance from -12.37 you are looking for? Or does result need to be value smaller than -12.37 (or greater than)?

Umm, you had column "J" in original post... and since starting value for iMax was set at 0 in code. Negative values would have given error.

And logic is quite a departure from original request of finding MAX in J and corresponding value in B.

What's your expected values in F? Can you give some sample manually?

And define closest to -12.37. Is it absolute variance from -12.37 you are looking for? Or does result need to be value smaller than -12.37 (or greater than)?

Hi CK76,
thank you for your help,
at the beginning i want have only one example,which i can used to help me for the implemnation the codei .
i want to use the column F to edit the edit the Values,which i search it in the E and B .
the Values should be greater than -12.37 and their related Value in B .

Hi CK76,
thank you for your help,
at the beginning i want have only one example,which i can used to help me for the implemnation the codei .
i want to use the column F to edit the edit the Values,which i search it in the E and B .
the Values should be greater than -12.37 and their related Value in B .

For finding Max my original code with minor modification will work.

Please Login or Register  to view this content.

Alternately you can just use something like....

Please Login or Register  to view this content.

Then find the match in Column B.

As for the rest. Not sure what you mean by following.

i want to use the column F to edit the edit the Values,which i search it in the E and B