2019 Points

Në Vazhdim Postuar 5 vite mё parё Paguhet në dorëzim
Në Vazhdim Paguhet në dorëzim

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

Futje të dhënash Përpunim të dhënash Administrim i bazave të të dhënave Zhvillim Personal Visual Basic

ID Projekti: #18759732

Rreth projektit

3 propozimet Projekti në distancë Aktiv 5 vite mё parё

3 profesionistë freelancer dërguan një ofertë mesatare prej $170 për këtë punë

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 për 3 ditë
(91 Përshtypje)
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 për 1 ditë
(32 Përshtypje)
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 për 0 ditë
(2 Përshtypje)
2.5