View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andri Andri is offline
external usenet poster
 
Posts: 66
Default Select the UNIQUE vendors name

Dear All,

Please help how to replace the below function with the VBA solution:
=OFFSET($G$1,MATCH(0,MMULT(--TRANSPOSE(TRANSPOSE($G$1:$G$14)=I$1:I1),ROW(INDIRE CT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)

the above formula work fast, when then data is not many.

But when we would like to SHORTLISTED / UNIQUE data, it will be a long wait
for Excel to finish the task.

Data:
Vendor Name
A
B
A
B
C
E
E
E
A

the Result of Unique Vendor will be
A
B
C
E

TIA