Counting the changes in a cell
Using a small Data Set of 5
10/17/08 | 10/17/08 | 10/17/08 | 10/17/08 | 10/17/08
Your formula results = 1, my formula results = 0
10/17/08 | 10/17/08 | 10/18/08 | 10/18/08 | 10/18/08
Your formula results = 2, my formula results = 1
10/17/08 | 10/17/08 | 10/18/08 | 10/18/08 | 10/17/08
Your formula results = 2, my formula results = 2
10/17/08 | 10/18/08 | 10/19/08 | 10/18/08 | 10/17/08
Your formula results = 3, my formula results = 4
--
** John C **
"Mike H" wrote:
Try,
=SUMPRODUCT((A1:A100<"")*(ISNUMBER(A1:A100)/(COUNTIF(A1:A100,A1:A100&""))))
Mike
"NM" wrote:
Hi,
I want to record/count the number of times a date changes in any cell in a
column?
I will appreciate all your help.Please let me know.
Thanks!
NM
|