Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you count how many times a cell is entered
How do you count how many times a cell is entered with a particular string. Example: If input cell is A1 and count cell is C1 and count string is 1K4. Then I want C1 to counts everytime 1K4 is entered in to A1. -- sammberg ------------------------------------------------------------------------ sammberg's Profile: http://www.excelforum.com/member.php...fo&userid=1019 View this thread: http://www.excelforum.com/showthread...hreadid=521413 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you count how many times a cell is entered
In general this is something Excel wasn't designed to do.
There are ways around, but be careful. Here's a link: http://www.mcgimpsey.com/excel/accumulator.html but again, make sure you read the last sentence too. -- Kind regards, Niek Otten "sammberg" wrote in message ... How do you count how many times a cell is entered with a particular string. Example: If input cell is A1 and count cell is C1 and count string is 1K4. Then I want C1 to counts everytime 1K4 is entered in to A1. -- sammberg ------------------------------------------------------------------------ sammberg's Profile: http://www.excelforum.com/member.php...fo&userid=1019 View this thread: http://www.excelforum.com/showthread...hreadid=521413 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count no. of times a character occurs in a cell | Excel Worksheet Functions | |||
Count the times a specific character appears in a cell | Excel Worksheet Functions | |||
How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
I need to keep a count of the times a cell is changed | Excel Discussion (Misc queries) | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions |