Text Filtering Spread Sheets with formulas

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

I want to filter a spreadsheet by looking for specific
(like) text in cells. This info I need totalised by
number, for insertion into a seperate spreadsheet. For
example, if in the one column there were cells containing
three different text labels, say SC, MBEL, GE, how can I
filter, by formula, to generate the number of times SC
appears in the column and then paste this number result
into a seperate worksheet cell (likewise for MBEL, GE
etc). Possible?
 
Sounds as though you could use the autofilter,
under custom you can select contains and then use
a formula to count the visible rows

=SUBTOTAL(3,Full_Range)

Regards,

Peo Sjoblom
 
Let's say the sheet you want the result is named
ResultSheet and the sheet you have labels is named
DataSheet; labels are in Column L between Rows 2 and 100.
Then write a following formula in the desired cell of
ResultSheet: =COUNTIF(DataSheet!L2:L100,"=SC")
 
Back
Top