Show/Hide Rows Based on Value of a Cell
March 27th, 2007Suppose you had a list of items where you wanted to be able to show or hide certain rows based on the value of a certain cell. For example, a task list where there’s a status column that indicates wether or not the task has already been completed and you wanted to be able to hide the completed tasks in order to focus more on the on-going ones. A simple VBA subroutine is all you’ll need.
Continue reading Show/Hide Rows Based on Value of a Cell…
Posted in Excel, VBA | No CommentsThe COUNTIF() Function
March 21st, 2007The COUNTIF() Function is used for counting the number of cells in a certain range that matches a given criteria. For example, COUNTIF(A1:A100, “Blue”) will give the number of cells in the A1:A100 range that has the value “Blue”.
The syntax for the COUNTIF function is:
COUNTIF(range, criteria)
Range is the range where you want to count cells that match your criteria. Criteria is the expression that defines your criteria. It can be expressed as 100, “100″, “>100″, “Blue”.
Continue reading The COUNTIF() Function…
Posted in Excel, Functions | No CommentsDisplay Number of Seconds in ‘hh:mm:ss’ Format
March 19th, 2007Let’s say you have an Excel file where you track some kind of process by the number of seconds it took to complete. Usually, it makes more sense to see the elapsed time in hh:mm:ss format. To do this, we divide the number in seconds by the number of seconds in a day (60 seconds/minute * 60 minutes/hour * 24 hours/day = 86,400 seconds/day). We then give the cell a custom format of “hh:mm:ss”. The reason behind the division is that time values in Excel are stored as fractions of a day. So if we were given a value in minutes, we need to divide it only by the number of minutes in a day which is 1,440 minutes.
« Previous Page — Next Page »
(C) by Virgilio Adriano. All rights reserved. Powered by WordPress.
Entries and comments feeds.
It took 0.231 seconds to load this page.