Hi,


=MODE(A1:A20)
will find the most frequent date

How can I reference lowest or bottom
number as that cell reference will regularly change?
Or, am I making this far to difficult?

Not too difficult but not clear exaclty what you want.

Mike

"bpc" wrote:

I have a list of events (Column A) and dates of events (Column B). I would
like to determine the most frequent and least frequent dates from the list.
No VBA please.

My current partial solution includes a pivot table in an adjacent worksheet
(sorted in descending order) which performs a count of the dates. I then
reference the "top cell" of the pivot table to determine the maximum date as
this cell location does not change. How can I reference lowest or bottom
number as that cell reference will regularly change?
Or, am I making this far to difficult?
Thanks in advance,
BPC