Macro to find lowest level from Hierarchy [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

please see the excel file i have below i need to search the lowest level from the heirarachy level list which i have as output of my standard report.

CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE PORTION
CHICKEN ROTISSERIE STANDARD
CHICKEN ROTISSERIE
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE WHOLE
CHICKEN ROTISSERIE STANDARD
CHICKEN ROTISSERIE
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE PORTION
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE OTHER
CHICKEN ROTISSERIE STANDARD
CHICKEN ROTISSERIE STANDARD

so output should find lines
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE PORTION
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE WHOLE
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE PORTION
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE OTHER
as it all are the lowest levels.

can you please provide the macro which find it autometically i have long list of report.

thanks in advance.
Dharmesh

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
I am not expert in Macros but in worksheet functions, can you exactly define what you exactly want ????

Are below words in Different Column or in Single Column ????????

CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE PORTION
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE WHOLE
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE PORTION
CHICKEN ROTISSERIE STANDARD CHICKEN ROTISSERIE OTHER

Because if they are in 6 column then you can make formula to get the values which are in all 6 column etc.......








Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!