Formula for Last Time Contacted

I have a sheet with a log of calls. I have created a test workbook (attached; expected rows for "last contact" highlighted on CallLog sheet) to assist in a resolution. On the CallLog sheet, there are four columns: Time; Date; Number; Direction. So each time a call is made/received, it is logged with the phone number and a time stamp. There is a second sheet, Contact (Name; Number; Last Contact), which needs, for each phone number listed, the last time it was contacted (regardless if inbound or outbound).

The formula I found somewhere online and have probably butchered, works great for the first line item in the Log, but the second (and all the rest) contact does not. It seems to just bring in the second line regardless if the number matches or not.
This is the formula I currently have for the Last Contact:

=TEXT(INDEX(CallLog!$B:$B,SUMPRODUCT(MAX(CallLog!$C:$C=$B2)*ROW(CallLog!$C:$C))),"MM/DD/YYYY")&" "&TEXT(INDEX(CallLog!$A:$A,SUMPRODUCT(MAX(CallLog!$C:$C=$B2)*ROW(CallLog!$C:$C))),"hh:mm am/pm")

Any help/suggestions would be greatly appreciated!!

Ron, thank you very much! Yes, that did help tremendously. I am not sure about the conversion to a table though. I did it, and it worked great, but I insert new records on a daily basis (to the top of the sheet), and it wouldn't let me do that once it was changed to a table. Seems like a minor thing, but it's kind of a big deal. I'll play around with it some more and see if it is just me causing the issue or not.

Is there a limitation on size or number of rows or something with the INDEX function? I seem to be experiencing the issue again when I attempted to put it in my "real" spreadsheet. There are 13065 records in this sheet and the first contact works without a problem, but the second is doing the same thing as before. I have gone through and removed records until the function works again (at 3266 records remaining of the 13065), but that doesn't give me valid results as some of the customers may have had their last contact in those "missing" 10K records.

And the insert cells on the table as I mentioned before is still not working for me. When I do it, instead of the normal "insert copied cells" option followed by "shift cells down", I receive an error stating "This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet."

I have tried to insert these records directly below my header row as well as several rows down. Same thing in either case.

I was able to successfully add them to the bottom of the records and perform a sort, however, trying to easily get to the bottom of my data is a real pain. Normally I type CTRL-end, and it takes me to the bottom right cell of my data. However, with the table, it takes me to the very bottom of the sheet (row 1048576). So I had to page down for several minutes to get to the spot where I could paste my data. I would much prefer to be able to insert the copied cells at the top. Suggestions? Am I being dense on this one? Missing something completely obvious?
Thanks!

1. I actually went with the table option that Ron provided:
C2: =MAX(INDEX((tblCallLog[Number]=Contact!B2)*(tblCallLog[Date]+tblCallLog[Time]),0))

I was going to do the first since that was the direction I was going originally but he said it was better not to calculate on the entire column.

2. I selected a cell from my first row of actual data (not the header) and the insert "Table Rows above" is grayed out, only "Table Columns to the left" is available. I then tried selecting the entire row, same options. I then selected, rather than the entire row (Row 2), only the cells containing data (A2:H2) and tried it again, same results. No option to insert rows above.

For example (on the index problem). I changed things to use the other formula (without the table).

This works, returning the correct results (took some messing around with the values to find the last one [3361] it would return correct results, 3362 does not return):
=TEXT(MAX(INDEX((Copy5!$C$2:$C$3361=Counts!B2)*(Copy5!$F$2:$F$3361+Copy5!$G$2:$G$3361),0)),"MM/DD/YYYY hh:mm am/pm")

This does not work, returning a #VALUE error (anything above row 3362 does this):
=TEXT(MAX(INDEX((Copy5!$C$2:$C$3362=Counts!B2)*(Copy5!$F$2:$F$3362+Copy5!$G$2:$G$3362),0)),"MM/DD/YYYY hh:mm am/pm")

Yes, I have changed the table. However, the index issue does not get resolved by that change, only the row inserts (but still not the insert copied cells, only inserting blank rows). Any ideas on the index issue? If you want/need, I'll try to create a new sheet with thousands and thousands of test records so you can see what I am experiencing....?

Alright, it'll take me a few minutes to generate enough records [can't be less than 3362 ], but I'll post it shortly.

Alrighty, I have created a new file with 3500 records. I made it resemble my "real" data file as much as possible (additional columns). There are now three sheets. One with a table, one without a table, and the last contact sheet. The last contact sheet now has three "last contact" columns. One for the table (using the table formula), and two for the sheet without the table (using the "not table" formula). The first of these references cells 2:3363 and works. The second references cells 2:3364 and does not work. Both the table "last contact" and the second "no table last contact" columns return a #VALUE error.

Pardon this, but o...........m.............g. What a dumb, dumb, dumb, dumb thing. I seriously can't even believe that was in there!

I found that same semi-colon in the "real" data, fixed it, and yes, that made it all better. Thank you so much for all the help!!!!!!!!!!

I like simple! Thanks, I'll give it a go!