Hello,
I extracted from my file what is needed to reproduce the bug and attached the sample to this post.
Here is what happens:
For each category (column B) I want to identify the largest value (Column J) and pick the correct location (column D). Which will be needed in other worksheets...
Everything works fine until 2 different Locations got the same value. All goes wrong
. I highlighted in blue the cells to look at and in red the value changing provocating the issue (hope it helps)
. The bugging formula is in column "O":
I try to play around but cannot fix it,Please Login or Register to view this content.
Thank you
pit
Bookmarks