Hello Gurus and other excel users like myself,

I have a series of Macros to run on a supplied file and it is not working as it usually does.
Please see attached file:
File for macro - Sheet Prepared.xlsm
I ran the macro A_PrepareSheet to get it to the current state.
From there I run A_RunDistroSort (or if I want to do it step by step to troubleshoot I do these in sequence: B_MakeUniqueNumbers C_ApplyDistros D_FilterDistrosandCopytoNewTabs)
The B_MakeUniqueNumbers Macro inserts the Dec2Hex formula and assigns random numbers to each quantity in H5-M5. The point is to separate each unique string of numbers and assign a Distro number.
When I run the formula, Dec2Hex assigns the same numbers to Spreadsheets 311 and 383 (in column Q), but the numbers in H5-M5 are different.
Therefore Spreadsheets 311 and 383 both end up in Distro 108, but that shouldn't happen because they get different items at different quantities. Help?

Thank you for looking!
Have a great day,
Klotzy