2019 Points

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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

Data Entry Data Processing Database Administration Personal Development Visual Basic

Project ID: #18759732

About the project

3 proposals Remote project Active 5 years ago

3 freelancers are bidding on average $170 for this job

asadkhan3533

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

$100 USD in 3 days
(91 Reviews)
5.8
tiaratechies

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.

$300 USD in 1 day
(32 Reviews)
5.0
musthree

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.

$111 USD in 0 days
(2 Reviews)
2.5