Counting duplicates in a list according to dates

W

weilun

Board Regular
Joined
Dec 23, 2011
Messages
76
Dear all,

Please help me. I cant find a solution to this. I have a list with names and they are categorized with dates. I need to count the number of duplicates that appears:


-- removed inline image ---
TOM 12/14/2011 TOM 2 12/14/2011
TOM 12/14/2011
SERENE 12/13/2011 SERENE 1 12/13/2011
GILL 12/13/2011 GILL 2 12/13/2011
GILL 12/13/2011

I know the normal way of counting duplicates but how to do it with dates? the whole spreadsheet would contain different dates and sometimes the number of names changes daily. Please help!
 
Last edited:

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Count of name date
name 13-Dec-11 14-Dec-11 Grand Total
GILL 3 3
SERENE 2 2
TOM 3 3
Grand Total 5 3 8

use pivot table option.
1. put the name in row area
2. put the date in column area
3. put the name in data area (use count)
 
Upvote 0
XL GURU said:
Count of name date
name 13-Dec-11 14-Dec-11 Grand Total
GILL 3 3
SERENE 2 2
TOM 3 3
Grand Total 5 3 8

use pivot table option.
1. put the name in row area
2. put the date in column area
3. put the name in data area (use count)
Click to expand...

Is there any way besides using pivot table? cos i need to use the raw data for something else.
 
Upvote 0
weilun said:
Dear all,

Please help me. I cant find a solution to this. I have a list with names and they are categorized with dates. I need to count the number of duplicates that appears:


-- removed inline image ---
TOM 12/14/2011 TOM 2 12/14/2011
TOM 12/14/2011
SERENE 12/13/2011 SERENE 1 12/13/2011
GILL 12/13/2011 GILL 2 12/13/2011
GILL 12/13/2011

I know the normal way of counting duplicates but how to do it with dates? the whole spreadsheet would contain different dates and sometimes the number of names changes daily. Please help!
Click to expand...

What are desired results for the above sample?
 
Upvote 0
Aladin Akyurek said:
What are desired results for the above sample?
Click to expand...

Maybe i give an example of the raw data and desired results.
<table border="0" cellpadding="0" cellspacing="0" width="442"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:48pt" height="20" width="64">Names</td> <td class="xl63" style="border-left:none;width:56pt" width="75"> </td> <td class="xl63" style="border-left:none;width:48pt" width="64"> </td> <td class="xl63" style="border-left:none;width:75pt" width="100">desired results</td> <td class="xl63" style="border-left:none;width:56pt" width="75">dates</td> <td class="xl63" style="border-left:none;width:48pt" width="64">Count</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none" align="right">4</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none">serene</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none" align="right">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none" align="right">3</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none">gill</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none" align="right">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">serene</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none">serene</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none" align="right">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">serene</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/12/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">serene</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">serene</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Tom</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Gill</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Gill</td> <td class="xl64" style="border-top:none;border-left:none" align="right">12/13/2011</td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> <td class="xl63" style="border-top:none;border-left:none"> </td> </tr> </tbody></table>
 
Upvote 0
Hi,

Do note that the new names are always added and old names may be removed. the dates changes too.

i'm not too sure if this is tough. I crack my brains over few days but can't think of anything to go round it.

I appreciate and thank you if you could help me...
 
Upvote 0
weilun said:
Maybe i give an example of the raw data and desired results.
<TABLE border=0 cellSpacing=0 cellPadding=0 width=442><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3657" width=100><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64></COLGROUP><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="WIDTH: 48pt; HEIGHT: 15pt" class=xl63 height=20 width=64>Names</TD><TD style="BORDER-LEFT: medium none; WIDTH: 56pt" class=xl63 width=75></TD><TD style="BORDER-LEFT: medium none; WIDTH: 48pt" class=xl63 width=64></TD><TD style="BORDER-LEFT: medium none; WIDTH: 75pt" class=xl63 width=100>desired results</TD><TD style="BORDER-LEFT: medium none; WIDTH: 56pt" class=xl63 width=75>dates</TD><TD style="BORDER-LEFT: medium none; WIDTH: 48pt" class=xl63 width=64>Count</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63 align=right>4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63>serene</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63 align=right>2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63 align=right>3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63>gill</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63 align=right>2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>serene</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63>serene</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63 align=right>2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>serene</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/12/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>serene</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>serene</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Tom</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Gill</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl63 height=20>Gill</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64 align=right>12/13/2011</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl63></TD></TR></TBODY></TABLE>
Click to expand...

weilun said:
Hi,

Do note that the new names are always added and old names may be removed. the dates changes too.

i'm not too sure if this is tough. I crack my brains over few days but can't think of anything to go round it.

I appreciate and thank you if you could help me...
Click to expand...

Does the size of the data area change frequenclty?
 
Upvote 0
Try this:-
Results start "D2"
Code: 
[COLOR="Navy"]Sub[/COLOR] MG26Dec46
[COLOR="Navy"]Dim[/COLOR] Rng         [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn          [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Twn         [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Q
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
    [COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
        .CompareMode = vbTextCompare
        [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
            Twn = Dn & Dn.Offset(, 1)
                [COLOR="Navy"]If[/COLOR] Not .Exists(Twn) [COLOR="Navy"]Then[/COLOR]
                    .Add Twn, Array(Dn, Dn.Offset(, 1), 1)
                [COLOR="Navy"]Else[/COLOR]
                    Q = .Item(Twn)
                    Q(2) = Q(2) + 1
                    .Item(Twn) = Q
                [COLOR="Navy"]End[/COLOR] If
        [COLOR="Navy"]Next[/COLOR]
Range("D2").Resize(.Count, 3) = Application.Transpose(Application.Transpose(.Items))
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Aladin Akyurek said:
Does the size of the data area change frequenclty?
Click to expand...

Not too sure what do u mean by data area. Do you mean that the amount of data can vary? if this is what u meant, then yes. sometimes it can be a 100 names and sometimes 200 names with different days.

I personally think it is quite a challenge and realli can't think of anything to deal with it. this extremely important to me. I thank you for trying to help me... I'm not sure if an array will help me? I'm not too sure how to do an array too..
 
Upvote 0
MickG said:
Try this:-
Results start "D2"
Code: 
[COLOR=Navy]Sub[/COLOR] MG26Dec46
[COLOR=Navy]Dim[/COLOR] Rng         [COLOR=Navy]As[/COLOR] Range
[COLOR=Navy]Dim[/COLOR] Dn          [COLOR=Navy]As[/COLOR] Range
[COLOR=Navy]Dim[/COLOR] Twn         [COLOR=Navy]As[/COLOR] [COLOR=Navy]String[/COLOR]
[COLOR=Navy]Dim[/COLOR] Q
[COLOR=Navy]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
    [COLOR=Navy]With[/COLOR] CreateObject("scripting.dictionary")
        .CompareMode = vbTextCompare
        [COLOR=Navy]For[/COLOR] [COLOR=Navy]Each[/COLOR] Dn [COLOR=Navy]In[/COLOR] Rng
            Twn = Dn & Dn.Offset(, 1)
                [COLOR=Navy]If[/COLOR] Not .Exists(Twn) [COLOR=Navy]Then[/COLOR]
                    .Add Twn, Array(Dn, Dn.Offset(, 1), 1)
                [COLOR=Navy]Else[/COLOR]
                    Q = .Item(Twn)
                    Q(2) = Q(2) + 1
                    .Item(Twn) = Q
                [COLOR=Navy]End[/COLOR] If
        [COLOR=Navy]Next[/COLOR]
Range("D2").Resize(.Count, 3) = Application.Transpose(Application.Transpose(.Items))
[COLOR=Navy]End[/COLOR] With
[COLOR=Navy]End[/COLOR] [COLOR=Navy]Sub[/COLOR]
Regards Mick
Click to expand...

Hi,

Thanks for your help but i got a debug at the last line Range("D2").Resize(.Count, 3) = Application.Transpose(Application.Transpose(.Items))

Any ideas why this happens?

Thanks for your help...
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
How to Highlight Month-end dates
Replies
3
Views
357
kevin9999
K
S
  • Question
IF cells in column A contains a dates that are 7 days before todays date then output the date and the value in the coulumn next to it in a list
Replies
1
Views
372
etaf
etaf
W
  • Solved
Counting repeats from one date to the next
Replies
3
Views
132
Joe4
Joe4
H
  • Solved
Count nonblank lines (between blank lines)
2
Replies
15
Views
682
Alex Blakenburg
A
H
  • Question
Making a top 10 list with possible duplicate values
Replies
1
Views
360
AhoyNC
A

Forum statistics

Threads
1,214,590
Messages
6,120,423
Members
448,961
Latest member
nzskater

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top