Hi, I have an excel formula that I have put together but the issue I am having is that the formula runs too slow. The purpose of this document is for the user to create an ongoing list of company names which will have duplicates. The on a separate sheet, it needs to extract only the unique company names from the original list. This would be a working list so this needs to update as company names are being inputted within the 1st sheet.
I have a formula that works correctly, but the problem that is that it slows down the document to the point the document can't be used. The document is calculating the formula each time which is causing the slowness.
Does anyone have a solution for this?
Here is the formula I am using:
I hope this makes sense. Any help would be appreciated.
Solved by G. S. in 14 mins