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.
See the attached demo. It uses just 3 formulas.