HELP ME

  • Thread starter Thread starter ernie
  • Start date Start date
E

ernie

Hey guys pls help me now.

I got a worksheet of raw data. Inside this worksheet, I need to find and
count the number of cells containing the word " People" and this figure will
automatically appear in another worksheet in a cell. Is this possible.

Please advice
 
okay. thanks for your response. Sorry for not being clear enough. The raw
data under the row AG contains "People-1,People-2...." in each cell. and also
under row D, it contains the dates created.

So i need to filter out the numbers of cells with the word "People" and at
the same time, according to their month in a new worksheet. Thanks.
 
If you want contains "People", use:
=COUNTIF(A1:A9,"*people*")

For the last part, you'll need to provide more detail on "according to their
month in a new worksheet". However, I suspect your best bet is a Pivot
Table.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching records based on a common field 1
Changing multiple worksheet references in formulae 2
Lookup to find the last value based on name and date field 4
Need your help Excel Worksheet/Form 1
Linking cells in Excel 2007 4
Macro to find value and then copy associated range 1
Word-Wrap Help? 4
How add a digit to front of number in each cell in excexl column 1

Back
Top