Forum Discussion

Copper Contributor

Feb 02, 2023

Categorizing the below range for entire column into header wise.

Categorizing the below range for entire column into header wise. Range starting with 10000 goes to ABC, likewise. Example. 10009 10010 10011 10020 33921 33930 3399...

Formulas and Functions

Macros and VBA

Patrick2788

Silver Contributor

Feb 02, 2023

sanjanakuril

I've created a function to do this:

=Organize(TicketMatrix,header)

Lambda 2.2.xlsx19 KB

sanjanakuril

Copper Contributor

Feb 03, 2023

Thanks, Patrick, for the solution, can you please explain me the first sheet, where you have defined. =MUNIT(20) and how to bring that to 2nd sheet?