Previous Topic Next Topic

Macro to find lowest level from Hierarchy

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

Réponse 1 / 1
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
3 Jun 2009 à 05:18
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.......