Hey, thank you for your reply. I think I understand the biggest part of your formula, but there's still some errors in it I can't correct. The final error is a #name! error.
When I evaluate the formula, on the second step it changes the match into #name?, third step it checks the array against the given number, which is correct, then it gives some weird divide by zero error. On second thought, let me just post my new file with the error.
Thanks for taking a look at this NBVC.
Bookmarks