Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
gigabitnokie
Dec 2, 2008
I have a worksheet that looks like this:

code:
John    Smith     10/22/09
Jane    Doe       8/17/09
...
I'd like to have another worksheet display the names and expiration dates of those records whose expiration dates have already passed. Make sense? In this case only Jane Doe would appear on the next worksheet, but on 10/23/09 John Smith would appear as well.

Thanks in advance for any help ya'll can provide :)

Adbot
ADBOT LOVES YOU

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply