N
Nate
I am trying to track the number of calls per day entered onto our tracking
form.
Office Patient Name Phone Number Call Date Call Outcome
Springfield Nate R. (610) 555-3535 7/30/08 NWA
Springfield Kate E. (610) 555-3232 8/31/08 NI
Springfield Dawn C. (610) 555-3434 8/31/08 CB
I was using a formula =IF(D3 = D2, 0, 1). But that was dependent on all the
calls being entered in chronological order, and I wanted to see if there was
a better way of doing it? Thanks in advance.
form.
Office Patient Name Phone Number Call Date Call Outcome
Springfield Nate R. (610) 555-3535 7/30/08 NWA
Springfield Kate E. (610) 555-3232 8/31/08 NI
Springfield Dawn C. (610) 555-3434 8/31/08 CB
I was using a formula =IF(D3 = D2, 0, 1). But that was dependent on all the
calls being entered in chronological order, and I wanted to see if there was
a better way of doing it? Thanks in advance.