Solved

Finding how many in a Excel spreadsheet

Posted on 2014-07-24
7
116 Views
Last Modified: 2014-08-04
I have a spreadsheet with 90,000 rows and 10 columns. I need to find out how many of the cells contain a specific value. Let's say 538. How many cells have 538 their cell. I've tried to sort but the it's so unwieldy the program craps out. Sorting hangs and never recovers.

Any quick and simple method to extract this one bit of info?
0
Comment
Question by:xmouser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 300 total points
ID: 40217443
You can use COUNTIF

e.b.

=COUNTIF(A1:Z100,538)
0
 
LVL 13

Assisted Solution

by:duncanb7
duncanb7 earned 200 total points
ID: 40217495
NBVC is correct,  and  I modify this from him

=COUNTIF(A:Z,538)

That you don't need to consider the number of row  to be searched when
put the formula out of A:Z range , ie, put it at  Cell AA

Duncan
0
 

Author Comment

by:xmouser
ID: 40217597
=COUNT(F1:F99360, 538) gives me 99361 which is wrong, it give me 99361 no matter what value I'm looking for.

=COUNT(F1:F99360, 540) gives me 99362, etc.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 13

Expert Comment

by:duncanb7
ID: 40217603
it is COUNTIF not COUNT


Duncan
0
 
LVL 13

Expert Comment

by:duncanb7
ID: 40217611
Please take a look the Excel tutorial at this site if have time
http://www.techonthenet.com/excel/formulas/countif.php

Duncan
0
 

Author Comment

by:xmouser
ID: 40217926
Typo on my part.
0
 

Author Closing Comment

by:xmouser
ID: 40238852
Sorry for the delay I've been out for a week.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question