Wad Mabbit
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
HI,
I have phone numbers in column H, they are NOT unique
I have start times in column C
In column J I wouod like the next start time of the matching number
So say, In H10 and H12 I have the same number+61411222333
In C10 and C12 are start times
In J10 I want the start time of C12
C12 in this instance being the next row from 10 that has a matching number
What I want to have is a lookup of the next appointment time for a matching number. There isn't a contiguous date field I can use so I need some magic!
Can you help?
I then hope to find a safe, reliable SMS service to set up an appointment reminder formula.
I have phone numbers in column H, they are NOT unique
I have start times in column C
In column J I wouod like the next start time of the matching number
So say, In H10 and H12 I have the same number+61411222333
In C10 and C12 are start times
In J10 I want the start time of C12
C12 in this instance being the next row from 10 that has a matching number
What I want to have is a lookup of the next appointment time for a matching number. There isn't a contiguous date field I can use so I need some magic!
Can you help?
I then hope to find a safe, reliable SMS service to set up an appointment reminder formula.