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

What is Office 65??? Please update your forum profile. Should it be 365?

If you have 365, try this:

=LET(s,SORTBY(A2:E30,B2:B30,1,A2:A30,1,E2:E30,1),FILTER(s,INDEX(s,,5)>=EDATE(TODAY(),-12)))

Does it give you the members you expect to be paid up?

Please update your forum profile, as requested above.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Your profile is still incorrect - 65 needs changing to 365, please.