I think I already asked you ro read the proposed solutions carefuly before stating " doesn't work". ( see the placing of parenthesis in my last post which you did not follow)

• Your solution in I8 does NOT meet the requirements (D8 is empty)
• In G17 you try to find numbers that are AT THE SAME TIME larger than 0.9 and smaller than 0.1, which is clearly impossible.
• I suppose you meant >0.9 and <=1. There are thus only TWO who meet the conditions
• See attached with solutions with blue background

Attached Files

Copy of DUMMY2.xlsx (19.9 KB, 13 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post