As can be found here, assume your dates are in the range, of say, A2:A1000
, you could use the following formula:
=INDEX(A2:A1000,MODE(MATCH(A2:A1000,A2:A1000,0)))
1
solved Find which cell value has the most number of rows? [closed]
As can be found here, assume your dates are in the range, of say, A2:A1000
, you could use the following formula:
=INDEX(A2:A1000,MODE(MATCH(A2:A1000,A2:A1000,0)))
1
solved Find which cell value has the most number of rows? [closed]