# 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.

Dharmesh

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
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.......