IN the attached, I need for each sheet 1D, 2D, 3D, 4D, Hit to refer back the member sheet. Validate 3 ways
first if name is not on sheet then validate is NO and points to count is 0
2nd if name is on sheet but not current or have 19 as year (which eve is easiest) then validate is No and points to count is 0
3rd if name is on sheet and current (or 19) then compare the points start date on membership list to the show date on 1D.. if on or after then "yes" and points to count is same as points.. If show date is prior to points to start date then no and points to count is 0
** and is a pivot table the best way to keep the sum of points for each person.
I'm very basic at excel and don't know many shortcuts
3 freelance font une offre moyenne de $170 pour ce travail
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
Hello, as a certified advanced excel professionals I can provide the sheet in less than a day, Can we discuss about this in the chat box.
In the 3rd condition why are you saying compare date to the date in 1D, do you mean the current sheet that we are comparing? Please let's talk answer a few questions for me and I will do it for you in around an hour.