• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need help with color code to map the age and input the first name and last name in Excel

sammas

New Member
need to populate the names into columns M to R based on the color codes from Column E.
 

Attachments

  • test file.xlsx
    18.8 KB · Views: 0
Need help on this - need to populate the names into columns M to R based on the color codes from Column E.
 

Attachments

  • test file.xlsx
    18.8 KB · Views: 3

sammas

You've tried to code those with Conditional Formatting.
There seems to be some challenges.
Instead of that ... You could populate names with ages.
This is one sample - how to do it.
 

Attachments

  • test file.xlsx
    24.2 KB · Views: 1
Try, in cell M5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=5,"")
N5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=6,"")
O5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=7,"")
P5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=8,"")
Q5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=9,"")
R5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=10,"")
etc.
 
Back
Top