Forum Discussion

Bahama85's avatar
Bahama85
Copper Contributor
Sep 14, 2022

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 information from the green table. Very new to formulas and still haven't grasped which type to use for what type of info to pull. Thank you in advance! 

https://1drv.ms/x/s!Agmju254hK9cgjomY2ySsoghIfuS   

 

 

excel
Formulas and Functions

2 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Sep 14, 2022
    You have "Aguilar, Hector" 4 times in date 9/12/2022. What result do you expect for this person?
    • Bahama85's avatar
      Bahama85
      Copper Contributor
      Sep 14, 2022
      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

Resources