VBA code to search in a column and mark in another.

[Anka]

Hi all !

How do we solve the following problem with VBA:

Find in column F, the third smallest value.
Put an "X" in column A, in a row at the same name.
Find in column F, the second smallest value.
Put an "X" in column B, in a row at the same name.
If the column C have an "X" (or maybe more) Not take into account the values ​​in this row.

And if possible explain me (other VBA) how should I do if I want to find 2 values​​.
EX. Find the column G, the second and fourth smallest value.

Attach a photo and an example in excel.

Thanks in advance and Merry Christmas!

[Anka]

I found here a macro that puts an "X" when it finds a predetermined value. But to do the calculations ... not yet!

[rcm]

try this code without macro

[rcm]

this is the file

[Anka]

Thanks rcm for your quick answer.
Apparently is what I want. I will see how it works in the original sheet (to implements the new columns). And I'll give you an answer.
Thank you.

Merry Christmas.

[rcm]

Happy Holydays in Portugal from Guatemala!!!

[Anka]

Hi rcm,

I just finished to implement your formula in the original sheet (very easy, nothing hard to do).
Great work. I did not know could be done without VBA.
Many thanks mate. Many thanks.