Forum Discussion
Solved
Select data within Multiple Rows within date ranges
I need to find an hourly rate for an employee the range falls within the date that the overtime was worked. Here is a sample of the data set Can somebody help me with a formulae to lookup wit...
Based on initial screenshot that could be like
=LOOKUP(2, 1/ ( $G2:$G9 = A2 )/ (C2>=$H$2:$H$9)/ (C2<=$I$2:$I$9), $J$2:$J$9)For entire range, using dynamic one
=LOOKUP(2, 1/ ( $G$2:INDEX($G:$G, COUNTA($G:$G)) = $A2 ) / ( $C2 >= $H$2:INDEX($H:$H, COUNTA($H:$H)) )/ ( $C2 <= $I$2:INDEX($I:$I, COUNTA($I:$I)) ), $J$2:INDEX($J:$J, COUNTA($J:$J)))
Both criteria? The only criterion that I see described is the date. So let me suggest:
- that you post not an image but the actual excel file from which the image was taken, so that we (I or somebody else) don't have to go to the trouble of re-creating what already exists. Just make sure there are no real names of real people in the file.
- that you be a little more specific on what the selection criteria are.
mathetes Thank you. File is now attached.