Forum Discussion

KAM_Mumin's avatar
KAM_Mumin
Brass Contributor
Oct 27, 2022
Solved

MS Excel VBA code need for Re-Execute task.

Hi Everyone! I have an attached file below and there I have more then 12 thousands customar names and want to short it by rearrage good name for all names to get some some from another sheet,,, I ha...
  • NikolinoDE's avatar
    Nov 02, 2022

    KAM_Mumin 

    with VBA code...see the file.

    It takes a bit until all the individual values appear, but it works :).

    Choose which range you want to include and in which spade or range you want the unique values to appear. Please note that the range in which the individual values should appear must not be smaller than the clear values.

     

    or with Formula

    =SORT(UNIQUE(B2:C12860))

     

    or with filter

    Filter for unique values or remove duplicate values

     

     

    Hope I could help you with these information / links.

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources