Macro to find lowest level from Hierarchy

Closed
dharmesh - Jun 3, 2009 at 04:50 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 3, 2009 at 05:18 AM
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
Related:

1 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Jun 3, 2009 at 05:18 AM
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.......








0