Hello,
My worksheet has a column of phone numbers, and another column with the date that this number dialed.
I'd like to know please for every phone number - if this phone number has dialed again within a period of 3 days.
if its true - return 1, if not - return 0.
My data cannot be pre-sorted by first to last date or stuff like that, and i cant use VBA nor pivot tables.
Please help me figure this out..
Thanks a lot!
My worksheet has a column of phone numbers, and another column with the date that this number dialed.
I'd like to know please for every phone number - if this phone number has dialed again within a period of 3 days.
if its true - return 1, if not - return 0.
My data cannot be pre-sorted by first to last date or stuff like that, and i cant use VBA nor pivot tables.
Please help me figure this out..
Thanks a lot!