| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hot to get a tally of the number of times a cell is clicked
I want to click a cell as a tally record to show how many times I have
clicked each cell. This will be used in an analysis spreadsheet of no. of people enquiring about various products at our trade show. So I want to display a number tally to be shown in each cell. Currently I am writing the new number each time I enter in the cell - would be much easier to just click the cell & let it increase the number count by 1 each click. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to keep a running tally of the number of times a certain w | Excel Discussion (Misc queries) | |||
| How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
| create tally sheet for positions- insert names and tally # | Excel Discussion (Misc queries) | |||
| Tool bar Icons should get brighter when clicked several times | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
![Steve Jones[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
