Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by xmouser
at 2024-07-24 09:59:35
ModifyPoint:500 Replies:7 POST_ID:829093USER_ID:11921
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Office Suite
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?
Any quick and simple method to extract this one bit of info?
Author: xmouser replied at 2024-08-04 06:12:18
Sorry for the delay I've been out for a week.
Author: xmouser replied at 2024-07-24 12:48:44
Typo on my part.
Expert: duncanb7 replied at 2024-07-24 11:05:08
Please take a look the Excel tutorial at this site if have time
http://www.techonthenet.com/excel/formulas/countif.php
Duncan
http://www.techonthenet.com/excel/formulas/countif.php
Duncan
Expert: duncanb7 replied at 2024-07-24 11:03:25
it is COUNTIF not COUNT
Duncan
Duncan
Author: xmouser replied at 2024-07-24 11:02:09
=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.
=COUNT(F1:F99360, 540) gives me 99362, etc.
Assisted Solution
Expert: duncanb7 replied at 2024-07-24 10:30:48
200 points EXCELLENT
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
=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
Accepted Solution
Expert: NBVC replied at 2024-07-24 10:06:09
300 points EXCELLENT
You can use COUNTIF
e.b.
=COUNTIF(A1:Z100,538)
e.b.
=COUNTIF(A1:Z100,538)
