Membership list Database

Hi,

I am trying to organize my membership database download. I can see that someone has renewed by manually scanning the list but my real list has 400 members.

Is there a way to organize the excel worksheet by name and if they are current(paid within the last year) or they have not renewed.

I am kind of lost. I can pivot by name and get the summary of their membership but cannot figure out how to identify if they are current or not without manually scanning the table.

Any help would be greatly appreciated.

Toni

UPDATE: The answer that was supplied was great it took 1013 lines of membership data and gave me an array that has the members who are current, 388.
This is great but I need to use the array in a vlookup(or other function) that will let me identify the expired memberships.

I know absolutely no nothing about arrays or how this formula works.

I am so close. Please help.

Toni