Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a list - 10K entries of customer ids. Some id's

Customer Question
Hi I have a long...
Hi I have a long list - 10K entries of customer ids. Some id's appear once, others appear 2, 3, 4 etc times.
I need to know how many appear once, twice, etc.
Submitted: 2 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 43 minutes by:
3/3/2016
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 8,138
Experience: Computer Software Specialist for more than 10 years
Verified

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Can you send me the Excel file with those 10K records so that I can do this for you? If that is not possible, can we do a Secure Remote Assistance so that I can directly work on your Excel file while you watch?

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Can't you just explain how to do it? I do not to pay extra for a remote connection and the data has customer ids - so I do not feel ok sending it. Thanks
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for writing back and I understand your concerns. It will be very difficult for me to build the formula without sample data. I can create sample data for you but I cannot guarantee that my sample data is similar in type and structure with what you have.

Can you at least copy some of your data, in a NEW Excel file, and attach here when you reply using the paper clip icon?

Just provide about 20 to 30 of the 10K IDs and other related info so that I can build a sample formula for you.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Ah - good suggestion - a very small sampling. The customer ids are basically emails - so I attached a small sample - like I said I have 10000 record - I am trying to figure out how many customers bought once, how many bought 17, etc. Thank you!
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for the sample. Please give me a moment.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for patiently waiting.

Here is the final file:

http://filesxpress.com/d-8a5e902c

We need a helper column to collect ALL unique and distinct emails.

Using the helper column, we can then come up with the COUNT of these unique emails.

Just expand the formulas to cover ALL 10K range.

I hope that helped.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!

If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.

Thank you!

Best regards,
Jess

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Thank you! it is late here so I should sleep - I will test this tomorrow am and send you some stars! Thanks!
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

You're welcome. Please take your time.

Thank you for using our service.

Best regards,

Jess

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 8,138
8,138 Satisfied Customers
Experience: Computer Software Specialist for more than 10 years

Jess M. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

8,138 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I have 6 columns with digits that can go from 1 to 10 2 4 5
Hello, So, I have 6 columns with digits that can go from 1 to 10 2 4 5 7 9 8 1 3 5 7 8 9 2 4 5 6 7 8 And in another columns I have how many times a number from the first row appear in the las 2 rows N… read more
murpmi00
murpmi00
BS of Science
4 satisfied customers
I have a number of cells with a series of numbers added.
i have a number of cells with a series of numbers added. e.g., =9+2+3 How do I get excel to count the numbers between the plus signs so I'll know how many items are in the equation? sometimes there is… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have a spreadsheet of over 10K lines that I need to sort
I have a spreadsheet of over 10K lines that I need to sort out duplicate name matches from the ones that are just single. Is there a quick way of doing that? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
This morning I saved over a document by accident. Is there
Hi, this morning I saved over a document by accident. Is there any way I can recover the previous version? I'm using a Mac. The word version is 15.14 I think. … read more
Cory
Cory
Vocational, Technical or Trade Scho
1,555 satisfied customers
I am working on/analyzing an Excel file with nearly 1000 data
I am working on/analyzing an Excel file with nearly 1000 data entries. I'm using AutoFilter to see if some of the items happen multiple times. Is there a quick and simple way to find out: 1. How many … read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
I have a table in access that i need to basically summarize.
i have a table in access that i need to basically summarize. It is a baseball schedule with 14 different teams listed, with 4 possible locations, with several possible times, with 15 games, and over 3… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
This is what I need to build a formula to do: If the room
This is what I need to build a formula to do: If the room number in column A appears twice (more than once) in the same column Take the total room nights in column B and divide it by 2 and Put the res… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
8,138 satisfied customers
I have edited a large word document and I assigned captions
I have edited a large word document and I assigned captions to all of the figures, but for some reason the Table of Figures won't generate properly. I only have 4 of my 20 figures showing in the table… read more
hongkongpom
hongkongpom
Computer Desktop Support
Associate Degree
291 satisfied customers
I have data arranged into several rows and columns. I want
I have data arranged into several rows and columns. I want to find only unique values in the whole set. I would prefer to be abke to do that in one step/function. Alternatively I could put them into 1… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I want to look at a group of 2,3 or 4 digit numbers and count
I want to look at a group of 2,3 or 4 digit numbers and count how many times each digit shows up.… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Hi , I have an Excel file of approximate 60 columns and 1500
Hi , I have an Excel file of approximate 60 columns and 1500 rows. I use it to record money that people give on a weekly base. In all there are 500 people and each takes 3 rows of information. The mon… read more
Adam B.
Adam B.
Senior Microsoft Systems Consultant
Bachelor\u0027s Degree
78 satisfied customers
Lookup/Index/Match equation help. I need to lookup information
Lookup/Index/Match equation help. I need to lookup information from a table on one worksheet and transfer it to another worksheet within the same workbook. Here's the catch. I need it to be able to tr… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I need some guidance for Microsoft Access 2010, to create some
I need some guidance for Microsoft Access 2010, to create some simple programming statements to use in either reports, forms or queries. I have a 2000+ record DB created and now need to do some more c… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Hi, I am a teacher and one task I always have to do is
Hi, I am a teacher and one task I always have to do is calculate the number of lessons I have for each of my classes between specific dates. For example, I need to know the number of lessons (and date… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I have a very large spreadsheet (50,000+lines) and I need to
I have a very large spreadsheet (50,000+lines) and I need to pull the minimum value for a series of cells as follows. The layout of the spreadsheet lists a finished good on line 1 followed by the comp… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Hi,Is there a means in Excel 2007 to collate text data,
Hi, Is there a means in Excel 2007 to collate the raw text data (which will be updated over over time such as names, places and ages. Some of which will be repeating information) onto a different spre… read more
Jason Jones
Jason Jones
AAS Information Technology
6,329 satisfied customers
I have a spreadsheet with about 20,000 entries, half of which
I have a spreadsheet with about 20,000 entries, half of which have duplicate emails. I need to find all of the duplicate emails and change the email column of the entry to "[email protected]" Is there… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Basically Im trainer who provides multiple courses on the
Basically I'm trainer who provides multiple courses on the same topic (1 day version course, 2 day version course etc:-) and now I'm ending up spending a huge amount of time updating multiple versions… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x