troubleshooting Question

question about excel formulas & functions

Avatar of Patrick
PatrickFlag for United States of America asked on
Microsoft AccessMicrosoft Excel
2 Comments1 Solution256 ViewsLast Modified:
Hello experts.
I have a column in an excel file which contains 1 to 20 numbers, each separated by a blank (I’ll call this the datacolumn) .
I would like to create some new columns which would have a 1 if a certain number exists in the datacolumn.
For example a new column called yes3 which would have a value of 1 if the number 3 is in the datacolumn, 0 if it is not.
or a new column called yes17 which would have a value of 1 if the number 17 is in the datacolumn, 0 if it is not.
Is this possible in excel using a formula (if or iif ?) in each of the new columns? If not excel then maybe access?
Thank you.
Pat
Example-
Datacolumn              yes3  yes17
1 6 7 8 12 17 20          0       1
2                                  0       0
1 2 3 4 5 6                   1       0
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros