Whenever you are dealing with lists it seems like you always are looking to count how many of a certain item is in the list. Maybe you want to count how many cars were sold by a certain salesperson, or how many times an employee called out sick. Luckily Excel makes it easy to count cells meeting certain criteria just like this. Count cells meeting certain criteria with Excel's … [Read more...]
Counter
Sometimes it is useful to know how many times a macro has been run. For example, if you run a macro once a week to perform a particular task, but don't want it run more than once a week, having a counter might be helpful. Copy all of the code below. Paste it into your workbook's Visual Basic editor, either under a Microsoft Excel Object or Module. You can also add other … [Read more...]