Time-dependent information in an Excel web page

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.

Related posts:

Advertisements

One Response to Time-dependent information in an Excel web page

  1. Datawiz, forgive me for hi-jacking this thread but I couldn’t find any other way to get in touch with you. Someone has asked me about collaborative workspaces. Have you any experience of these? Any recommendations? please email me ruth@mypaperwork.co.uk

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: