Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I've got a sheet with several columns and about 1500 rows. I'm using autofilter to do basic analysis on the data.
If I autofilter search for a certain text input, say "south", is there a command that will let me count the number of entries of "south"?
yes
and what is it o'wise one?
highlight the cells and on the bottom right of the screen there's a wee little box that you can right click on (should say NUM I think), right click on this and choose which one you want it to report (in your case it'd be Count Nums).
Er look in the help under functions.
It's something like COUNT maybe, I forget.
You could put a column of "1" all the way down and just sum this. The sum corrects depending on the autofilter.
Ah lovely, that'll do.
I'm a bit allergic to excel help function.
I did the "1" count already, but thought there must be a better way
countif
=COUNTIF(A1:A2,south)
Change A1:A2 to the range.