In Progress

Find Unique Values and Frequency in Table

We have an excel spreadsheet with 167 columns and almost 200,000 rows.

We are trying to find a method to find the unique identifiers and the frequency in each column and save the values to a new table.

Color State

Red Wi

Blue IL

Yellow IL

Red WI

Green IL

Green TX

We want

Color-I Color-C State-I State-C

Red 2 WI 2

Blue 1 IL 3

Yellow 1 TX 1

Green 2

This can be done in Excel, Access, SQL....

I have attached a spreadsheet with an example of what I am looking for. The data tab is the source. The Analysis tab is the desired result.

Skills: Excel, Microsoft Access, SQL

See more: find frequency excel, unique values access sql, frequency unique values excel, find values excel, access find unique values, unique frequency excel, access sql frequency table, excel frequency table, table, frequency, find unique, excel access table, excel unique, excel data table, frequency data, save data table, access rows, sql spreadsheet, excel red yellow, table excel, spreadsheet save, rows excel, excel save sql, excel sql access, yellow access

About the Employer:
( 3 reviews ) Brookfield, United States

Project ID: #1278514

Awarded to:

vserv

Easy to do. Please see your messages. Thanks

$30 USD in 1 day
(55 Reviews)
5.6

26 freelancers are bidding on average $69 for this job

imudita

I have done it. Please see PM for detail.

$30 USD in 0 days
(26 Reviews)
4.6
rbenfield

I've looked at your data and can accomplish this no problem. Many thanks, Rich

$100 USD in 1 day
(8 Reviews)
4.6
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly More

$100 USD in 0 days
(19 Reviews)
4.6
pyazlm

I have done similar macros in VBA and sent a demo on PMB.

$50 USD in 5 days
(30 Reviews)
4.4
SmartGuru

Hi, I downloaded the excel file that you attached and understood your requirements completely. I would thus be glad to take up this project and deliver you the final Excel file within 2 working days. Please check More

$30 USD in 2 days
(10 Reviews)
4.2
shacoim

***Plz Check PM***Important***

$50 USD in 0 days
(12 Reviews)
4.0
xhanso

Hi scamquist, I understand exactly what you require and can have this done very fast but more importantly, 'working perfectly'. I hope to hear from you.

$75 USD in 1 day
(1 Review)
4.0
manishadk

please view PMB for details.

$80 USD in 1 day
(8 Reviews)
3.6
muthumuni

Hi, Kindly see PM, you can find your final product there, Hope you will contact me for any help for it. Thank you in advance your satisfaction is my success muthumuni

$30 USD in 0 days
(7 Reviews)
3.6
guevanjr

Please consider my bid. Thanks, SG

$50 USD in 1 day
(8 Reviews)
3.5
SVLakshmi

Sir, I will complete this job 3 days and give the 100% quality. Please check your PM

$75 USD in 3 days
(2 Reviews)
2.9
junworried

Hi, I am ready to start working. Please send me the spreadsheet. Thanks

$200 USD in 10 days
(2 Reviews)
2.6
suheng

Thanks & Regards,

$120 USD in 1 day
(1 Review)
2.6
IoliteTech

Hi, I've returned to freelancer after a while now. This can be done in a couple of hours. Please check PMB for scheme discussion.

$80 USD in 1 day
(2 Reviews)
2.2
rmrf

Hello sir, I'm very experienced with Excel and VBA. I can do this.

$30 USD in 1 day
(2 Reviews)
2.1
nineko

This can be easily done with a VBA macro in Excel. Once the macro is written you can get the results in mere minutes for all the Excel files you want. If you award this project to me I'll guarantee you'll have the VBA More

$50 USD in 1 day
(1 Review)
1.4
monsieurcorp

Ready to start work.

$100 USD in 1 day
(1 Review)
1.0
zizo0003

Good experience in excel.

$50 USD in 1 day
(0 Reviews)
0.0
rmjudkins

Please refer to PMB for your customized Excel solution.

$50 USD in 1 day
(0 Reviews)
0.0
japeka100

Expert here. I can do this for you. Won't let you down.

$75 USD in 1 day
(0 Reviews)
0.0