Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unknown Text
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unknown Text
Create a pivot table on your data. If will sum whatever people have sold
tickets for you. Regards, Fred. "conflusterated" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Looking for a way for excel to count unknown repeating values? | Excel Worksheet Functions |