How to total unique values in one column between dates in another column?

wmichael

Board Regular
Joined
Aug 26, 2014
Messages
103
Office Version
  1. 365
  2. 2019
  3. 2007
Platform
  1. Windows
  2. Mobile
Hello. Asking your help to total unique values in column CV between dates of 7/1/2019 and 7/31/2019 in column DF. Thank you in advance for your help with this.


2019-22 Media Clips v06.xlsx
CUCVCWCXCYCZDADBDCDDDEDF
1171 HeadlinesDistributed by 167 OutletsAcross 1 Direct Media AreasDma RankAcross 135 Citiesand 34 Statesand 1 CountriesProduced a combined total of 105,537,593 Circulation, Impressions, and Event AttendeesWith a total of $6,124,953 in Media ValueConsisting of 57 Print Articles, 285 Web Headlines, and Attendees to 0 Events that breaks down to:Published DatePosted Date
2Englewood Community News Briefs for July 2, 2019Sun NewspapersN/AN/AENGLEWOODFLUSA21,268$485 - Web07-01-20197/3/2019
3Promoting safe boating SMITH MOUNTAIN EAGLEN/A68MONETAVAUSA4,400$166 - Print06-26-20197/10/2019
4Root Beer Floats", but you don't, so wear your life jacket BEDFORD BULLETINN/A68BEDFORDVAUSA4,563$276 - Print06-26-20197/10/2019
5New life jacket loaner stands open in Norwalk - The Register CitizenRegister CitizenN/AN/ATORRINGTONCTUSA17,253$364 - Web07-12-20197/18/2019
6New life jacket loaner stands open in NorwalkConnecticut PostN/AN/ABRIDGEPORTCTUSA394,799$13,453 - Web07-12-20197/18/2019
7New life jacket loaner stands open in NorwalkMiddletown PressN/AN/AMIDDLETOWNCTUSA11,272$95 - Web07-12-20197/18/2019
8'ABCs' are important in drowning preventionFort Myers Beach ObserverN/AN/AFORT MYERSFLUSA3,738$1,205 - Web07-19-20197/24/2019
9Water safety: 'ABCs' are important in drowning preventionIsland ReporterN/AN/ASANIBELFLUSA507$9,563 - Web07-19-20197/24/2019
10Water safety: 'ABCs' are important in drowning preventionCape Coral Daily BreezeN/AN/ACAPE CORALFLUSA2,878$32 - Web07-18-20197/24/2019
11Wake the World returns to Crazy Horse Marina ROANOKE TIMESN/A68ROANOKEVAUSA35,946$1,159 - Print07-31-20198/1/2019
12Ten tips to make boating with children safe, fun FLORIDA WEEKLYN/AN/AFORT MYERSFLUSA18,242$400 - Print07-30-20198/7/2019
13Sea Tow Foundation Receives US Coast Guard GrantsMarina Dock AgeN/AN/ANILESILUSA8,500$447 - Web08-05-20198/9/2019
14 Sea Tow Foundation to present safety awards at Boating Industry's Elevate - Boating IndustryBoating Industry OnlineN/AN/AMAPLE GROVEMNUSA9,758$75 - Web08-15-20198/15/2019
15 Sea Tow Foundation launches new awards - Trade Only TodaySoundings: Trade OnlyN/AN/AESSEXCTUSA12,219$97 - Web08-15-20198/19/2019
16 Sea Tow Foundation Extends Deadline for Boating Industry Safety AwardsFishing Wire (The)N/AN/AGLEN ALLENVAUSA2,946$29 - Web09-24-20199/30/2019
17Coast Guard Awards Grants to Sea Tow Foundation Programs LAKELAND BOATINGN/AN/AEVANSTONILUSA42,096$642 - Print10-01-201910/21/2019
18 Sea Tow Foundation Announces National Boating Industry Safety Award WinnersPublicN/AN/ANEW YORKNYUSA18,219$63 - Web12-04-201912/4/2019
19Sea Ray and Freedom Boat Club win National Safety AwardsCount on 2 FirstN/AN/ANAPLESFLUSA69,903$1,052 - Web12-02-201912/4/2019
20Downriver communities wrap up yearVoice (The)N/AN/ANEW BALTIMOREMIUSA2,510$152 - Web12-19-201912/23/2019
21Hartford Boat Show returns to Mohegan Sun - New Haven RegisterNew Haven RegisterN/AN/ANEW HAVENCTUSA111,844$3,581 - Web01-08-20201/9/2020
22With Flying Colors - Soundings OnlineSoundingsN/AN/AESSEXCTUSA21,182$348 - Web01-15-20201/16/2020
23Enhance Your Customers' Boating Experience with Peace of Mind on the Water SOUNDINGS (TRADE ONLY)N/AN/AESSEXCTUSA27,272$2,718 - Print04-01-20203/31/2020
24 Sea Tow Foundation Launches New WebsiteOutdoor Wire (The)N/AN/AGLEN ALLENVAUSA520$22 - Web04-03-20204/6/2020
25Mom Honors Her Late Son With Hernando Beach Life Jacket Loaner StationSpectrum Bay News 9N/AN/ATAMPAFLUSA230,161$2,621 - Web05-17-20205/18/2020
2610 tips for boating with kids by Safe Kids, Heather O'BrienSWFL Parent & ChildN/AN/AFORT MYERSFLUSA8,500$934 - Web07-02-20197/3/2019
27Lake Shelbyville to hold Life Jacket DriveShelbyville Daily Union (The)N/AN/ASHELBYVILLEILUSA4,579$88 - Web06-27-20197/3/2019
28Where to find loaner life jackets in SW FL by Safe KidsSWFL Parent & ChildN/AN/AFORT MYERSFLUSA8,500$404 - Web07-02-20197/3/2019
29EYE ON THE BALLSHELTER ISLAND REPORTERN/A1SHELTER ISLANDNYUSA2,927$190 - Print06-20-20197/5/2019
30Englewood Briefs for July 10, 2019Sun NewspapersN/AN/AENGLEWOODFLUSA21,268$931 - Web07-09-20197/10/2019
31Community Briefs for July 14, 2019Sun NewspapersN/AN/AENGLEWOODFLUSA21,268$834 - Web07-12-20197/18/2019
32Englewood Community Briefs for July 12, 2019Sun NewspapersN/AN/AENGLEWOODFLUSA21,268$914 - Web07-11-20197/18/2019
33Water safety: 'ABCs' are important in drowning preventionPine Island EagleN/AN/ABOKEELIAFLUSA1,413$31 - Web07-18-20197/24/2019
34Escape the heat by taking a swim a " but don't forget the life jacketWilliamsburg Yorktown DailyN/AN/AWILLIAMSBURGVAUSA4,897$87 - Web07-22-20197/24/2019
35Water safety: 'ABCs' are important in drowning preventionFort Myers Beach ObserverN/AN/AFORT MYERSFLUSA3,738$1,190 - Web07-19-20197/24/2019
36Escape the heat by taking a swim a " but don't forget the life jacketWilliamsburg Yorktown DailyN/AN/AWILLIAMSBURGVAUSA4,897$87 - Web07-22-20197/30/2019
37Life Jacket, Sober Skipper Programs to Receive USCG Grant FundingBoating WorldN/AN/AATLANTAGAUSA760$15 - Web08-01-20198/5/2019
38Life jacket pre tips for boating season FLORIDA WEEKLYN/AN/AFORT MYERSFLUSA18,242$126 - Print07-30-20198/7/2019
39Englewood Community Briefs for Aug, 7, 2019Sun NewspapersN/AN/AENGLEWOODFLUSA21,268$484 - Web08-06-20198/9/2019
raw
Cell Formulas
RangeFormula
CU1CU1=CONCATENATE(SUM(IF(FREQUENCY(IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""),IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""))>0,1))," Headlines")
CV1CV1=CONCATENATE("Distributed by ",SUM(IF(FREQUENCY(IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""),IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""))>0,1))," Outlets")
CW1CW1=CONCATENATE("Across ",SUM(IF(FREQUENCY(IF(LEN(CW2:CW492)>0,MATCH(CW2:CW492,CW2:CW492,0),""),IF(LEN(CW2:CW492)>0,MATCH(CW2:CW492,CW2:CW492,0),""))>0,1))," Direct Media Areas")
CY1CY1=CONCATENATE("Across ",SUM(IF(FREQUENCY(IF(LEN(CY2:CY492)>0,MATCH(CY2:CY492,CY2:CY492,0),""),IF(LEN(CY2:CY492)>0,MATCH(CY2:CY492,CY2:CY492,0),""))>0,1))," Cities")
CZ1CZ1=CONCATENATE("and ",SUM(IF(FREQUENCY(IF(LEN(CZ2:CZ492)>0,MATCH(CZ2:CZ492,CZ2:CZ492,0),""),IF(LEN(CZ2:CZ492)>0,MATCH(CZ2:CZ492,CZ2:CZ492,0),""))>0,1))," States")
DA1DA1=CONCATENATE("and ",SUM(IF(FREQUENCY(IF(LEN(DA2:DA492)>0,MATCH(DA2:DA492,DA2:DA492,0),""),IF(LEN(DA2:DA492)>0,MATCH(DA2:DA492,DA2:DA492,0),""))>0,1))," Countries")
DB1DB1=CONCATENATE("Produced a combined total of ",TEXT(SUM(DB2:DB492),"#,##0")," Circulation, Impressions, and Event Attendees")
DC1DC1=CONCATENATE("With a total of $",TEXT(SUM(DC2:DC492),"#,##0")," in Media Value")
DD1DD1=CONCATENATE("Consisting of ",COUNTIF(DD2:DD492,"*Print*")," Print Articles, ",COUNTIF(DD2:DD492,"*Web*")," Web Headlines, and Attendees to ",COUNTIF(DD2:DD492,"*Event*")," Events that breaks down to:")
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,749
Office Version
  1. 365
Platform
  1. Windows
Try:

Book4
CSCTCUCVDEDF
133 HeadlinesDistributed by 30 OutletsPublished DatePosted Date
2Excel 365Englewood Community News Briefs for July 2, 2019Sun Newspapers7/1/20197/3/2019
314Promoting safe boatingSMITH MOUNTAIN EAGLE6/26/20197/10/2019
4Excel 2019 or 2007Root Beer Floats", but you don't, so wear your life jacketBEDFORD BULLETIN6/26/20197/10/2019
514New life jacket loaner stands open in Norwalk - The Register CitizenRegister Citizen7/12/20197/18/2019
6New life jacket loaner stands open in NorwalkConnecticut Post7/12/20197/18/2019
7New life jacket loaner stands open in NorwalkMiddletown Press7/12/20197/18/2019
8'ABCs' are important in drowning preventionFort Myers Beach Observer7/19/20197/24/2019
9Water safety: 'ABCs' are important in drowning preventionIsland Reporter7/19/20197/24/2019
10Water safety: 'ABCs' are important in drowning preventionCape Coral Daily Breeze7/18/20197/24/2019
11Wake the World returns to Crazy Horse MarinaROANOKE TIMES7/31/20198/1/2019
12Ten tips to make boating with children safe, funFLORIDA WEEKLY7/30/20198/7/2019
13Sea Tow Foundation Receives US Coast Guard GrantsMarina Dock Age8/5/20198/9/2019
14Sea Tow Foundation to present safety awards at Boating Industry's Elevate - Boating IndustryBoating Industry Online8/15/20198/15/2019
15Sea Tow Foundation launches new awards - Trade Only TodaySoundings: Trade Only8/15/20198/19/2019
16Sea Tow Foundation Extends Deadline for Boating Industry Safety AwardsFishing Wire (The)9/24/20199/30/2019
17Coast Guard Awards Grants to Sea Tow Foundation ProgramsLAKELAND BOATING10/1/201910/21/2019
18Sea Tow Foundation Announces National Boating Industry Safety Award WinnersPublic12/4/201912/4/2019
19Sea Ray and Freedom Boat Club win National Safety AwardsCount on 2 First12/2/201912/4/2019
20Downriver communities wrap up yearVoice (The)12/19/201912/23/2019
21Hartford Boat Show returns to Mohegan Sun - New Haven RegisterNew Haven Register1/8/20201/9/2020
22With Flying Colors - Soundings OnlineSoundings1/15/20201/16/2020
23Enhance Your Customers' Boating Experience with Peace of Mind on the WaterSOUNDINGS (TRADE ONLY)4/1/20203/31/2020
24Sea Tow Foundation Launches New WebsiteOutdoor Wire (The)4/3/20204/6/2020
25Mom Honors Her Late Son With Hernando Beach Life Jacket Loaner StationSpectrum Bay News 95/17/20205/18/2020
2610 tips for boating with kids by Safe Kids, Heather O'BrienSWFL Parent & Child7/2/20197/3/2019
27Lake Shelbyville to hold Life Jacket DriveShelbyville Daily Union (The)6/27/20197/3/2019
28Where to find loaner life jackets in SW FL by Safe KidsSWFL Parent & Child7/2/20197/3/2019
29EYE ON THE BALLSHELTER ISLAND REPORTER6/20/20197/5/2019
30Englewood Briefs for July 10, 2019Sun Newspapers7/9/20197/10/2019
31Community Briefs for July 14, 2019Sun Newspapers7/12/20197/18/2019
32Englewood Community Briefs for July 12, 2019Sun Newspapers7/11/20197/18/2019
33Water safety: 'ABCs' are important in drowning preventionPine Island Eagle7/18/20197/24/2019
34Escape the heat by taking a swim a " but don't forget the life jacketWilliamsburg Yorktown Daily7/22/20197/24/2019
35Water safety: 'ABCs' are important in drowning preventionFort Myers Beach Observer7/19/20197/24/2019
36Escape the heat by taking a swim a " but don't forget the life jacketWilliamsburg Yorktown Daily7/22/20197/30/2019
37Life Jacket, Sober Skipper Programs to Receive USCG Grant FundingBoating World8/1/20198/5/2019
38Life jacket pre tips for boating seasonFLORIDA WEEKLY7/30/20198/7/2019
39Englewood Community Briefs for Aug, 7, 2019Sun Newspapers8/6/20198/9/2019
Sheet1
Cell Formulas
RangeFormula
CU1CU1=CONCATENATE(SUM(IF(FREQUENCY(IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""),IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""))>0,1))," Headlines")
CV1CV1=CONCATENATE("Distributed by ",SUM(IF(FREQUENCY(IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""),IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""))>0,1))," Outlets")
CS3CS3=COUNTA(UNIQUE(FILTER($CV$2:$CV$39,($DF$2:$DF$39>=DATE(2019,7,1))*($DF$2:$DF$39<=DATE(2019,7,31)),"")))
CS5CS5=SUM(IF(FREQUENCY(IF($DF$2:$DF$39>=DATE(2019,7,1),IF($DF$2:$DF$39<=DATE(2019,7,31),MATCH($CV$2:$CV$39,$CV$2:$CV$39,0))),ROW($CV$2:$CV$39)-ROW($CV$2)+1),1))
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,127,328
Messages
5,624,036
Members
416,007
Latest member
csf

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
Top