Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 account numbers:
1000000
1500000
2000000
I have 5 ranges with names
Range name A with accounts 10000000 to 1399999
B, 1400000, 1599999
C, 1600000, 2500000
QV must return the right range name.
Thank you.
Try using IntervalMatch .
Try using IntervalMatch .
Hi,
see the attached example. The keyword is INTERVALMATCH.
Good luck!
Rainer
Very helpful, thank you.