Forum Discussion
Need help with finding data from two differing columns
Good Morning,
I have a table with a Shop Order, A date, A name and list of hours. I am then using this info in different ways. I am currently trying to track the dates that a person has worked on a shop order. I had initially though of having a table with names on top and the days of the month on the left and then just have a Yes or a No if each person did work on that day. However, in reading thru allot of help I could potentially use XLOOKUP or MATCH, but I am having problems 1. getting it to work right and 2. understanding what these do. I read that I could use an ARRAY, but that is way over my head and I don't know how to format it right. I would be ok with just a list of names with the associated dates. What ever would be an easier path. I just want a quick way to look up if each person has a record for each day. Hope this is understandable. Thank you for any help you may be able to provide. Here is a sample table of the data.
Sales Order | Date | Name | Hours |
12345 | 10/4/2023 | Jack | 4.5 |
24680 | 10/4/2023 | Jack | 4.5 |
12345 | 10/4/2023 | Joe | 9 |
10023 | 10/5/2023 | John | 9 |
56412 | 10/6/2023 | Jill | 9 |
An alternative would be to insert a Pivot Table, as demonstrated in the attached file and change the NumberFormat of one of the Values cells to "Yes";; to achieve the desired output.
4 Replies
- Subodh_Tiwari_sktneerSilver Contributor
An alternative would be to insert a Pivot Table, as demonstrated in the attached file and change the NumberFormat of one of the Values cells to "Yes";; to achieve the desired output.
- Paul_FarquharCopper Contributor
Subodh_Tiwari_sktneer thank you all for the suggestions. I ended up with the pivot table. While the formulas worked great on my home computer when I tried using them at work, I had issues with it. I think that is because at work we use Excel 2016.
Thank you again,
Paul
- Subodh_Tiwari_sktneerSilver Contributor
You're welcome Paul_Farquhar! Glad it worked for you.