Excel Help? WHat is the formulae to find same numbers appearings more than once in a column?
If we can also find which row does it lie in and how many times does it appear?
2006-07-06 01:16:49 · 4 answers · asked by CHETAN 1 in Computers & Internet ➔ Software
You need to use the COUNTIF formula...
"Count how often a single value occurs by using a function
Use the COUNTIF function to perform this task."
2006-07-06 01:21:46 · answer #1 · answered by the_dt 4 · 0⤊ 0⤋
You can highlight the column, press CTRL + F, type in the number and "find all"
2006-07-06 01:21:32 · answer #2 · answered by customcat2000 4 · 0⤊ 0⤋
enable auto filter and then select the number in appropriate column
2006-07-06 01:20:08 · answer #3 · answered by Anonymous · 0⤊ 0⤋
try the =counta function or the =countif()
2006-07-06 01:20:55 · answer #4 · answered by Blake T 4 · 0⤊ 0⤋