Look for all matches in a sorted list. If no exact match is found all the nearest matches.
Been looking at lot of examples none I can adapt. Cheers Peter
e.g.
Col A/Col B
Tom 10
Bob 20
Mob 30
Yan 40
Den 40
Elf 50
Len 50
If my target is 40 I should have Ian 40 and den 40 should be listed.
If no exact match all nearest should be listed even if higher or lower. If target 45.
Yan 40
Den 40
Elf 50
Len 50
Good luck!
Been looking at lot of examples none I can adapt. Cheers Peter
e.g.
Col A/Col B
Tom 10
Bob 20
Mob 30
Yan 40
Den 40
Elf 50
Len 50
If my target is 40 I should have Ian 40 and den 40 should be listed.
If no exact match all nearest should be listed even if higher or lower. If target 45.
Yan 40
Den 40
Elf 50
Len 50
Good luck!
Last edited: