Forum Discussion
Solved
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 ...
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.
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.
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
You're welcome Paul_Farquhar! Glad it worked for you.