Google released asynchronous tracking for Google Analytics earlier this year and I posted an example HTML page showing how to insert the code. On my just released New Zealand Running Calendar website I use jQuery Facebox popups to render a lot of content and wanted those to get tracked as additional pageviews. This post therefore …
On an Android phone there is a notification ringtone which will be used by default for all notifications. The Gmail app allows you to specify a different notification ringtone which can be quite useful for having the default for SMS messages and something else for new emails, but the option is buried quite deep and I can never remember where it is, so this post will help to remind me in the future.
Want to count rows and/or columns in a range with Excel no matter what content they contain? This post shows you how.
Count rows in Excel
Use this formula, where you want the number of rows selected from e.g. A1 to A10
This example will show 10 in the cell where the formula is.
Count cells in Excel
Use this formula, where you want the number of columns selected from e.g. A1 to E1
This example will show 5 in the cell where the formula is.
What happens when running the formulas against a block?
Note that the formulas will count the number of rows or columns, no matter what the selection. If we ran both rows() and columns() on the range A1 to E10, it would show 10 rows and 5 columns.
Yes, selecting 5 cells from A to E is obviously 5 columns, but I personally manage a very basic ad booking system using a spreadsheet that is very very wide and I need to know numbers of days an ad is booked for. Using these functions makes it a lot easier, especially when it’s running across cells FB17 to GS17. No, it’s not the best ad booking system, but it works 🙂
And I’m sure you have your own reasons for needing to use these formulas, otherwise you wouldn’t have been looking for this post.