Forum Discussion
Formula Help!
Me again 🙂 Need help creating a formula to extract from Column J or at least J2:J4500 based off of the criteria from the Employee Name in AA10, Date in N6 and the 1st Floor Mezz in AB8 and the i...
You have "Aguilar, Hector" 4 times in date 9/12/2022. What result do you expect for this person?
- So the Account Name (column K) is each pick zone that each employee picked out of on that date. Aguilar, Hector tasked into 4 separate areas but he does not have a task for 1st Floor Mezz so his hours would reflect a "0".
However, if you look at Avila, Efrain - he has 4.95 hours into 1st Floor Mezz. Cell AC11 needs to show 4.95
