Spreadsheet: 112973d1308930101-countif-column-range-equals-any-other-cell-in-same-range-patientstay
Sheet: Sheet1

ID# | Admit Date | Help Counter | Help Index | Days Since First
319 | 2011-03-16 00:00:00
305 | 2011-03-16 00:00:00 |  |  |  |  | I made some fake data in Columns A and B
312 | 2011-03-16 00:00:00 |  |  |  |  | Look at formula in C.  It counts from the TOP of all IDs
300 | 2011-03-17 00:00:00 |  |  |  |  | In D I created an Index for a match function  used in E
313 | 2011-03-17 00:00:00 |  |  |  |  | In E is the number of days since first ID in column A.
321 | 2011-03-17 00:00:00
319 | 2011-03-17 00:00:00
308 | 2011-03-17 00:00:00
308 | 2011-03-18 00:00:00
310 | 2011-03-18 00:00:00
300 | 2011-03-18 00:00:00
308 | 2011-03-19 00:00:00
306 | 2011-03-19 00:00:00
300 | 2011-03-19 00:00:00
317 | 2011-03-19 00:00:00
311 | 2011-03-19 00:00:00
304 | 2011-03-19 00:00:00
318 | 2011-03-19 00:00:00
312 | 2011-03-19 00:00:00
301 | 2011-03-19 00:00:00
324 | 2011-03-20 00:00:00
311 | 2011-03-20 00:00:00
311 | 2011-03-21 00:00:00
317 | 2011-03-21 00:00:00
301 | 2011-03-21 00:00:00
309 | 2011-03-21 00:00:00
303 | 2011-03-22 00:00:00
302 | 2011-03-22 00:00:00
317 | 2011-03-22 00:00:00
320 | 2011-03-23 00:00:00
316 | 2011-03-23 00:00:00
316 | 2011-03-23 00:00:00
304 | 2011-03-23 00:00:00
325 | 2011-03-24 00:00:00
309 | 2011-03-24 00:00:00
309 | 2011-03-25 00:00:00
318 | 2011-03-25 00:00:00
301 | 2011-03-25 00:00:00
322 | 2011-03-25 00:00:00
324 | 2011-03-26 00:00:00
320 | 2011-03-26 00:00:00
307 | 2011-03-26 00:00:00
320 | 2011-03-27 00:00:00
320 | 2011-03-27 00:00:00
325 | 2011-03-27 00:00:00
317 | 2011-03-27 00:00:00
305 | 2011-03-28 00:00:00
307 | 2011-03-28 00:00:00
305 | 2011-03-28 00:00:00
313 | 2011-03-28 00:00:00
320 | 2011-03-28 00:00:00
318 | 2011-03-29 00:00:00
325 | 2011-03-29 00:00:00
317 | 2011-03-29 00:00:00
316 | 2011-03-30 00:00:00
319 | 2011-03-30 00:00:00
313 | 2011-03-30 00:00:00
322 | 2011-03-30 00:00:00
302 | 2011-03-30 00:00:00
302 | 2011-03-31 00:00:00
307 | 2011-03-31 00:00:00
309 | 2011-03-31 00:00:00
320 | 2011-04-01 00:00:00
304 | 2011-04-01 00:00:00
316 | 2011-04-02 00:00:00
317 | 2011-04-02 00:00:00
317 | 2011-04-02 00:00:00
321 | 2011-04-02 00:00:00
324 | 2011-04-03 00:00:00
311 | 2011-04-03 00:00:00
306 | 2011-04-03 00:00:00
311 | 2011-04-03 00:00:00
305 | 2011-04-04 00:00:00
309 | 2011-04-04 00:00:00
300 | 2011-04-04 00:00:00
310 | 2011-04-04 00:00:00
312 | 2011-04-05 00:00:00
306 | 2011-04-05 00:00:00
302 | 2011-04-05 00:00:00
316 | 2011-04-06 00:00:00
315 | 2011-04-06 00:00:00
310 | 2011-04-06 00:00:00
324 | 2011-04-06 00:00:00
305 | 2011-04-07 00:00:00
316 | 2011-04-07 00:00:00
312 | 2011-04-07 00:00:00
324 | 2011-04-07 00:00:00
301 | 2011-04-07 00:00:00
307 | 2011-04-08 00:00:00
316 | 2011-04-09 00:00:00
314 | 2011-04-09 00:00:00
302 | 2011-04-09 00:00:00
301 | 2011-04-09 00:00:00
322 | 2011-04-10 00:00:00
314 | 2011-04-10 00:00:00
320 | 2011-04-10 00:00:00
310 | 2011-04-10 00:00:00
318 | 2011-04-10 00:00:00
319 | 2011-04-10 00:00:00
312 | 2011-04-10 00:00:00
325 | 2011-04-11 00:00:00
313 | 2011-04-11 00:00:00
322 | 2011-04-11 00:00:00
310 | 2011-04-11 00:00:00
324 | 2011-04-11 00:00:00
318 | 2011-04-12 00:00:00
323 | 2011-04-12 00:00:00
303 | 2011-04-12 00:00:00
325 | 2011-04-12 00:00:00
321 | 2011-04-12 00:00:00
318 | 2011-04-12 00:00:00
314 | 2011-04-13 00:00:00
305 | 2011-04-13 00:00:00
300 | 2011-04-13 00:00:00
320 | 2011-04-13 00:00:00
302 | 2011-04-13 00:00:00
309 | 2011-04-13 00:00:00
307 | 2011-04-13 00:00:00
309 | 2011-04-14 00:00:00
315 | 2011-04-14 00:00:00
321 | 2011-04-14 00:00:00
304 | 2011-04-15 00:00:00
300 | 2011-04-15 00:00:00
325 | 2011-04-16 00:00:00
318 | 2011-04-16 00:00:00
323 | 2011-04-16 00:00:00
307 | 2011-04-16 00:00:00
300 | 2011-04-17 00:00:00
312 | 2011-04-18 00:00:00
306 | 2011-04-18 00:00:00
320 | 2011-04-18 00:00:00
315 | 2011-04-19 00:00:00
322 | 2011-04-19 00:00:00
316 | 2011-04-19 00:00:00
300 | 2011-04-19 00:00:00
320 | 2011-04-19 00:00:00
308 | 2011-04-20 00:00:00
314 | 2011-04-20 00:00:00
318 | 2011-04-20 00:00:00
324 | 2011-04-20 00:00:00
302 | 2011-04-22 00:00:00
309 | 2011-04-22 00:00:00
315 | 2011-04-22 00:00:00
322 | 2011-04-22 00:00:00
317 | 2011-04-22 00:00:00
324 | 2011-04-23 00:00:00
308 | 2011-04-23 00:00:00
322 | 2011-04-23 00:00:00
312 | 2011-04-23 00:00:00
308 | 2011-04-23 00:00:00
322 | 2011-04-23 00:00:00
318 | 2011-04-23 00:00:00
321 | 2011-04-24 00:00:00
308 | 2011-04-24 00:00:00
306 | 2011-04-24 00:00:00
311 | 2011-04-24 00:00:00
325 | 2011-04-24 00:00:00
320 | 2011-04-24 00:00:00
307 | 2011-04-24 00:00:00
325 | 2011-04-25 00:00:00
305 | 2011-04-25 00:00:00
300 | 2011-04-25 00:00:00
324 | 2011-04-25 00:00:00
301 | 2011-04-25 00:00:00
317 | 2011-04-25 00:00:00
323 | 2011-04-25 00:00:00
308 | 2011-04-26 00:00:00
316 | 2011-04-27 00:00:00
314 | 2011-04-27 00:00:00
314 | 2011-04-28 00:00:00
301 | 2011-04-28 00:00:00
323 | 2011-04-28 00:00:00
314 | 2011-04-29 00:00:00
324 | 2011-04-29 00:00:00
318 | 2011-04-29 00:00:00
320 | 2011-04-30 00:00:00
305 | 2011-04-30 00:00:00
315 | 2011-04-30 00:00:00
314 | 2011-04-30 00:00:00
325 | 2011-04-30 00:00:00
309 | 2011-04-30 00:00:00
303 | 2011-05-01 00:00:00
302 | 2011-05-01 00:00:00
301 | 2011-05-02 00:00:00
325 | 2011-05-03 00:00:00
303 | 2011-05-03 00:00:00
306 | 2011-05-03 00:00:00
302 | 2011-05-03 00:00:00
316 | 2011-05-04 00:00:00
312 | 2011-05-05 00:00:00
313 | 2011-05-05 00:00:00
310 | 2011-05-05 00:00:00
324 | 2011-05-05 00:00:00
315 | 2011-05-06 00:00:00
302 | 2011-05-06 00:00:00
301 | 2011-05-06 00:00:00
316 | 2011-05-07 00:00:00
307 | 2011-05-07 00:00:00
321 | 2011-05-07 00:00:00
324 | 2011-05-07 00:00:00
319 | 2011-05-08 00:00:00
303 | 2011-05-09 00:00:00
306 | 2011-05-09 00:00:00
301 | 2011-05-09 00:00:00
317 | 2011-05-09 00:00:00
300 | 2011-05-09 00:00:00
301 | 2011-05-10 00:00:00
314 | 2011-05-10 00:00:00
300 | 2011-05-11 00:00:00
315 | 2011-05-11 00:00:00
302 | 2011-05-11 00:00:00
314 | 2011-05-11 00:00:00
324 | 2011-05-11 00:00:00
308 | 2011-05-11 00:00:00
317 | 2011-05-12 00:00:00
324 | 2011-05-12 00:00:00
317 | 2011-05-12 00:00:00
309 | 2011-05-13 00:00:00
303 | 2011-05-13 00:00:00
305 | 2011-05-13 00:00:00
308 | 2011-05-14 00:00:00
322 | 2011-05-14 00:00:00
309 | 2011-05-14 00:00:00
310 | 2011-05-14 00:00:00
320 | 2011-05-15 00:00:00
315 | 2011-05-15 00:00:00
310 | 2011-05-15 00:00:00
318 | 2011-05-15 00:00:00
325 | 2011-05-15 00:00:00
307 | 2011-05-15 00:00:00
322 | 2011-05-16 00:00:00
313 | 2011-05-16 00:00:00
325 | 2011-05-16 00:00:00
311 | 2011-05-16 00:00:00
324 | 2011-05-16 00:00:00
314 | 2011-05-16 00:00:00
314 | 2011-05-17 00:00:00
316 | 2011-05-17 00:00:00
301 | 2011-05-17 00:00:00
313 | 2011-05-17 00:00:00
313 | 2011-05-17 00:00:00
310 | 2011-05-17 00:00:00
311 | 2011-05-17 00:00:00
303 | 2011-05-17 00:00:00
306 | 2011-05-18 00:00:00
303 | 2011-05-18 00:00:00
302 | 2011-05-18 00:00:00
303 | 2011-05-18 00:00:00
306 | 2011-05-18 00:00:00
322 | 2011-05-19 00:00:00
304 | 2011-05-19 00:00:00
320 | 2011-05-19 00:00:00
307 | 2011-05-19 00:00:00
312 | 2011-05-19 00:00:00
324 | 2011-05-20 00:00:00
307 | 2011-05-21 00:00:00
325 | 2011-05-21 00:00:00
320 | 2011-05-22 00:00:00
302 | 2011-05-22 00:00:00
325 | 2011-05-22 00:00:00
309 | 2011-05-22 00:00:00
318 | 2011-05-22 00:00:00
303 | 2011-05-22 00:00:00
316 | 2011-05-22 00:00:00
304 | 2011-05-23 00:00:00
318 | 2011-05-23 00:00:00
320 | 2011-05-23 00:00:00
305 | 2011-05-23 00:00:00
302 | 2011-05-23 00:00:00
308 | 2011-05-23 00:00:00
308 | 2011-05-24 00:00:00
308 | 2011-05-24 00:00:00
310 | 2011-05-24 00:00:00
311 | 2011-05-24 00:00:00
312 | 2011-05-24 00:00:00
324 | 2011-05-24 00:00:00
318 | 2011-05-24 00:00:00
304 | 2011-05-25 00:00:00
311 | 2011-05-25 00:00:00
324 | 2011-05-25 00:00:00
317 | 2011-05-25 00:00:00
317 | 2011-05-25 00:00:00
322 | 2011-05-26 00:00:00
309 | 2011-05-26 00:00:00
311 | 2011-05-26 00:00:00
301 | 2011-05-27 00:00:00
315 | 2011-05-27 00:00:00
313 | 2011-05-27 00:00:00
312 | 2011-05-27 00:00:00
316 | 2011-05-27 00:00:00
315 | 2011-05-27 00:00:00
304 | 2011-05-28 00:00:00
319 | 2011-05-28 00:00:00
316 | 2011-05-28 00:00:00
324 | 2011-05-29 00:00:00
308 | 2011-05-29 00:00:00
306 | 2011-05-29 00:00:00
305 | 2011-05-29 00:00:00
322 | 2011-05-29 00:00:00
324 | 2011-05-29 00:00:00
311 | 2011-05-31 00:00:00
311 | 2011-05-31 00:00:00
315 | 2011-05-31 00:00:00
317 | 2011-05-31 00:00:00
315 | 2011-06-01 00:00:00
311 | 2011-06-02 00:00:00
312 | 2011-06-02 00:00:00
304 | 2011-06-02 00:00:00
313 | 2011-06-02 00:00:00
319 | 2011-06-03 00:00:00
304 | 2011-06-03 00:00:00
319 | 2011-06-03 00:00:00
309 | 2011-06-04 00:00:00
308 | 2011-06-04 00:00:00
320 | 2011-06-04 00:00:00
310 | 2011-06-05 00:00:00
302 | 2011-06-05 00:00:00
319 | 2011-06-05 00:00:00
307 | 2011-06-05 00:00:00
317 | 2011-06-05 00:00:00
308 | 2011-06-06 00:00:00
305 | 2011-06-06 00:00:00
310 | 2011-06-06 00:00:00
317 | 2011-06-06 00:00:00
304 | 2011-06-07 00:00:00
319 | 2011-06-07 00:00:00
325 | 2011-06-07 00:00:00
304 | 2011-06-07 00:00:00
302 | 2011-06-08 00:00:00
301 | 2011-06-08 00:00:00
320 | 2011-06-08 00:00:00
311 | 2011-06-09 00:00:00
306 | 2011-06-10 00:00:00
309 | 2011-06-10 00:00:00
309 | 2011-06-10 00:00:00
321 | 2011-06-10 00:00:00
322 | 2011-06-10 00:00:00
317 | 2011-06-11 00:00:00
313 | 2011-06-11 00:00:00
306 | 2011-06-12 00:00:00
316 | 2011-06-13 00:00:00
313 | 2011-06-13 00:00:00
317 | 2011-06-13 00:00:00
312 | 2011-06-13 00:00:00
323 | 2011-06-13 00:00:00
318 | 2011-06-14 00:00:00
305 | 2011-06-14 00:00:00
315 | 2011-06-14 00:00:00
305 | 2011-06-14 00:00:00