Hi friends,
Please see attachments.
In that attachment I have Child, Women, Men names
If I select Child in A10, then all Child names will appear from B10 to down. Same as Women, Men, can you please post that How can I get these,
Thank you.
Hi friends,
Please see attachments.
In that attachment I have Child, Women, Men names
If I select Child in A10, then all Child names will appear from B10 to down. Same as Women, Men, can you please post that How can I get these,
Thank you.
Hello
Maybe using HLOOKUP, for example in B10 copied down to B13:
Formula:Please Login or Register to view this content.
You could suppress the zero values with a custom format: ;;
Hope this helps.
DBY
Thank you DBY
Glad to have helped. Thank you for the Rep mark.
@rajeshn_in
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks