count unique records and summarize large amount of data

C

CYDSRQ

New Member
Joined
Nov 26, 2013
Messages
35
Hi and thank you for reading this post. I am using Excel 2013 and Windows 7 Professional, and have limited experience with formulas and none with VBA.

I have 51k records that list units of service and am trying to summarize the data, specifically :
unique CYDID
Sum of "Count" field per unique CYDID

Headings A1 to L1
Data A2 to L8

Thanks for any help!


[TABLE="width: 659"]
<colgroup><col width="64" style="width: 48pt;"> <col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="64" style="width: 48pt;" span="2"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="64" style="width: 48pt;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]CYDID[/TD]
[TD="width: 99, bgcolor: transparent"]Fname[/TD]
[TD="width: 64, bgcolor: transparent"]Lname[/TD]
[TD="width: 64, bgcolor: transparent"]GradYr[/TD]
[TD="width: 102, bgcolor: transparent"]DOB[/TD]
[TD="width: 64, bgcolor: transparent"]Gender[/TD]
[TD="width: 64, bgcolor: transparent"]Race[/TD]
[TD="width: 75, bgcolor: transparent"]schDate[/TD]
[TD="width: 154, bgcolor: transparent"]eveTitle[/TD]
[TD="width: 64, bgcolor: transparent"]eveID[/TD]
[TD="width: 64, bgcolor: transparent"]theCount[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12190[/TD]
[TD="bgcolor: transparent"]Mathew[/TD]
[TD="bgcolor: transparent"]Perry[/TD]
[TD="bgcolor: transparent, align: right"]2013[/TD]
[TD="bgcolor: transparent, align: right"]11/3/1995[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]White[/TD]
[TD="bgcolor: transparent, align: right"]2/3/2007[/TD]
[TD="bgcolor: transparent"]Teen Scene[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12190[/TD]
[TD="bgcolor: transparent"]Mathew[/TD]
[TD="bgcolor: transparent"]Perry[/TD]
[TD="bgcolor: transparent, align: right"]2013[/TD]
[TD="bgcolor: transparent, align: right"]11/3/1995[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]White[/TD]
[TD="bgcolor: transparent, align: right"]4/18/2008[/TD]
[TD="bgcolor: transparent"]McBean Scene[/TD]
[TD="bgcolor: transparent, align: right"]200087[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10537[/TD]
[TD="bgcolor: transparent"]Tim[/TD]
[TD="bgcolor: transparent"]Perry[/TD]
[TD="bgcolor: transparent, align: right"]2012[/TD]
[TD="bgcolor: transparent, align: right"]1/29/1994[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]White[/TD]
[TD="bgcolor: transparent, align: right"]4/8/2006[/TD]
[TD="bgcolor: transparent"]Teen Scene[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10537[/TD]
[TD="bgcolor: transparent"]Tim[/TD]
[TD="bgcolor: transparent"]Perry[/TD]
[TD="bgcolor: transparent, align: right"]2012[/TD]
[TD="bgcolor: transparent, align: right"]1/29/1994[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]White[/TD]
[TD="bgcolor: transparent, align: right"]4/18/2008[/TD]
[TD="bgcolor: transparent"]McBean Scene[/TD]
[TD="bgcolor: transparent, align: right"]200087[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]14945[/TD]
[TD="bgcolor: transparent"]Mark[/TD]
[TD="bgcolor: transparent"]Rose[/TD]
[TD="bgcolor: transparent, align: right"]2012[/TD]
[TD="bgcolor: transparent, align: right"]1/18/1994[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]White[/TD]
[TD="bgcolor: transparent, align: right"]6/14/2008[/TD]
[TD="bgcolor: transparent"]Teen Scene[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15970[/TD]
[TD="bgcolor: transparent"]Joseph[/TD]
[TD="bgcolor: transparent"]Thomas[/TD]
[TD="bgcolor: transparent, align: right"]2015[/TD]
[TD="bgcolor: transparent, align: right"]7/13/1997[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]Other[/TD]
[TD="bgcolor: transparent, align: right"]11/22/2008[/TD]
[TD="bgcolor: transparent"]Teen Scene[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15970[/TD]
[TD="bgcolor: transparent"]Joseph[/TD]
[TD="bgcolor: transparent"]Thomas[/TD]
[TD="bgcolor: transparent, align: right"]2015[/TD]
[TD="bgcolor: transparent, align: right"]7/13/1997[/TD]
[TD="bgcolor: transparent"]Male[/TD]
[TD="bgcolor: transparent"]Other[/TD]
[TD="bgcolor: transparent, align: right"]7/1/2011[/TD]
[TD="bgcolor: transparent"]Club Scene - North Port[/TD]
[TD="bgcolor: transparent, align: right"]200124[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
You must log in or register to reply here.

Similar threads

darrenmccoy
  • Question Question
Help to Index unique records in Multiple columns
2
Replies
11
Views
2K
Peter_SSs
Peter_SSs
S
  • Question Question
Multiple Condition IF/OR Statement with TEXT
Replies
1
Views
1K
AlanY
A
H
  • Question Question
Distinct Count based on given criteria
Replies
3
Views
832
SpillerBD
S
H
  • Question Question
Macros - Auto Copy paste row when cell value changes
Replies
7
Views
6K
Fluff
Fluff
C
  • Question Question
copy entire row based on cell vale
Replies
1
Views
732
MARK858
MARK858

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

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