redahussien
New Member
- Joined
- Feb 15, 2016
- Messages
- 3
hi all,
can you help in finding the most repeated dates in a range a1:d4
<tbody>
</tbody>
i want to list all the repeated values from the most to the least :
can you help in finding the most repeated dates in a range a1:d4
A | B | C | D | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
i want to list all the repeated values from the most to the least :
dates repeated
2/2/2009 7
2/12/2009 3
2/2/2009 3
4/21/2009 2
8/8/2009 2
2/1/2009 1
2/2/2010 1
note that the columns dates and repeated are formula generated , i want to extract them and count the repetition. cos i have a large list of dates.
2/2/2009 7
2/12/2009 3
2/2/2009 3
4/21/2009 2
8/8/2009 2
2/1/2009 1
2/2/2010 1
note that the columns dates and repeated are formula generated , i want to extract them and count the repetition. cos i have a large list of dates.