Hi Folks!
Not sure if this is even possible to do (I'm a rookie) - please ignore the #Name i know the formula as is works its just because i have saved it on another PC on a old version of excel to send this and i had to change the names for privacy reasons.
so basically i have 2 tables the "call data" and the table2 - i do have a pivot for table 2 and this is where im running into bother, basically the formula im using pulls the the data on table 2 from call data however both have 2 sets of dates because they are different data sets and i cant merge them, is it possible to also match the date from table 2 to call data date then the forumla to pull what i need? if that makes any sense ! tried a few things but cant seem to get it working - i have uploaded some screenshots with the formula in place - ill owe someone a very large Whisky if they can solve :D
Not sure if this is even possible to do (I'm a rookie) - please ignore the #Name i know the formula as is works its just because i have saved it on another PC on a old version of excel to send this and i had to change the names for privacy reasons.
so basically i have 2 tables the "call data" and the table2 - i do have a pivot for table 2 and this is where im running into bother, basically the formula im using pulls the the data on table 2 from call data however both have 2 sets of dates because they are different data sets and i cant merge them, is it possible to also match the date from table 2 to call data date then the forumla to pull what i need? if that makes any sense ! tried a few things but cant seem to get it working - i have uploaded some screenshots with the formula in place - ill owe someone a very large Whisky if they can solve :D
