On sheet1, I have an array formula is colum 3 to sort and remove duplicate a list in column A:
column A contains names from A2:A20
In C3 coped down:
nn is defined as:
The problem I have is that this works perfectly when it is text only, but my data in column A has numbers, a mix of numbers and letters. It stops working as soon as I have a mix of items that contain text + numbers
for example, some items in column A:
Does anyone know how to edit the formulas to make this work?
thanks in advance!
There are currently 1 users browsing this thread. (0 members and 1 guests)