Time-dependent information in an Excel web page
January 20, 2011 1 Comment
In one of the WordPress forums there was a question about displaying the list of pharmacies that are on duty today, given a list of all the pharmacies in an area and when each of them is on duty. I’ve decided to give it a try below. Note how the list will change if you come back to this site some other day.
Here is how the workbook works. On the second sheet, there is a table with a list of pharmacies, their address, and when they are on duty. I have added a calculated column, that determines if they are on duty today (by using the =TODAY() function). Then, I have other columns that calculate, for rows that are “on duty”, their index on the list. On the first sheet, I show (by using =VLOOKUP()) only those rows that are on duty today.