Hi all,
I currently have a macro that is working but the below code is slowing it down a bit. Basically I have order numbers and locations (geographically speaking).
I am using the formula below to try and identify instances where the same order number (stored in named range called "OrderNum") is found across multiple locations (locations are coded by number and stored in a named range called "Location"). The macro is then entering the formula down ~21k rows in column AB starting with row 4. This range is dynamic and can change. Any assistance either through code or formula would be greatly appreciated. Thank you.
Please Login or Register to view this content.
Bookmarks