Hi,
I'm new to macros and can't find a good starting point for my problem.
I want to loop through a row in a table looking for the 3 closest numbers (column D) to a value in a given cell (N5) and set the corresponding row to "yes" in column B.
So if the 3 closest values is found in D3, D6 and D7 I want B3, B6 and B7 to say "Yes" and then filter my list accordingley.
Help appreciated.
Regard Jokei
I'm new to macros and can't find a good starting point for my problem.
I want to loop through a row in a table looking for the 3 closest numbers (column D) to a value in a given cell (N5) and set the corresponding row to "yes" in column B.
So if the 3 closest values is found in D3, D6 and D7 I want B3, B6 and B7 to say "Yes" and then filter my list accordingley.
Help appreciated.
Regard Jokei