Hello,
I'm working with 2 spreadsheets and trying to pull the latest entry for a specific data group. I can successfully pull the last row of data from the 1st spreadsheet into the 2nd spreadsheet using the LOOKUP formula; but having an issue with pulling the first 2 lines of data that are from the latest hour. Please see example below:
I'm unable to pull data from rows 5 & 6. I have tried Vlookup, Index & Match, Offset and a couple of more scenarios; but don't get the data to transfer over
On line 7, I use the LOOKUP formula that looks for the last data entry for the day.; but not having luck figuring out how to bring the data over from lines 5 &6 (or reference the other 2 workgroups in the scenario
Please let me know if you have any questions.
Thank you,
RMJ
I'm working with 2 spreadsheets and trying to pull the latest entry for a specific data group. I can successfully pull the last row of data from the 1st spreadsheet into the 2nd spreadsheet using the LOOKUP formula; but having an issue with pulling the first 2 lines of data that are from the latest hour. Please see example below:
I'm unable to pull data from rows 5 & 6. I have tried Vlookup, Index & Match, Offset and a couple of more scenarios; but don't get the data to transfer over
On line 7, I use the LOOKUP formula that looks for the last data entry for the day.; but not having luck figuring out how to bring the data over from lines 5 &6 (or reference the other 2 workgroups in the scenario
Please let me know if you have any questions.
Thank you,
RMJ
Date | Name | Time AZ | EST Time | Pen: | Int | # of Accounts | Calls Connected | Agents logged in | Aban OB Count/Rate | Offered Calls | Aban IB Count/Rate |
03/30/21 | Corres | 9:54 | 12:54:00 PM | 94% | 172% | 500 | 40(5.01%) | 14 | 4(10%) | 7 | 0(0.00%) |
03/30/21 | Corres X2 | 9:54 | 12:54:00 PM | 99% | 146% | 466 | 25(7.74%) | 14 | 2(8.0%) | N/A | N/A |
03/30/21 | Corres x7 | 9:54 | 12:54:00 PM | 97% | 190% | 342 | 32(4.22%) | 14 | 4 (4.12%) | N/A | N/A |
03/30/21 | Corres | 12:00 | 3:00:00 PM | 95% | 211% | 500 | 46(4.68%) | 18 | 5(10.86%) | 14 | 2(16.31%) |
03/30/21 | Corres X2 | 12:00 | 3:00:00 PM | 99% | 148% | 466 | 25(7.65%) | 18 | 2 (8%) | N/A | N/A |
03/30/21 | Corres x7 | 12:00 | 3:00:00 PM | 98% | 222% | 342 | 39(4.39%) | 18 | 4 (10.25%) | N/A | N/A |