View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Count Unknown Text

Too many unknowns to be able to make any sense.

1. You don't know who will be in the office.

2. You don't know the name of the person who may or may not be there.


Gord Dibben MS Excel MVP

On Mon, 16 Feb 2009 13:41:02 -0800, conflusterated
wrote:

I am needing to count text, but I don't know exactly what text it is that I
am counting. I am making a spreadsheet to tell what kind of business we are
getting, who is selling well, and where each persons strength is. Today I
may write 10 tickets ( I can count myself, and input my name), but tomorrow
it may be someone else. Without knowing who will be in my office, I would
like to count how many people and how many tickets each person writes,
without knowing the name of the person in my office that day.

I hope this makes sense! I would greatly appreciate any help!