En cours

2019 Points

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

Compétences : Saisie de Données, Traitement de Données, Administration de Bases de données, Développement Personnel, Visual Basic

en voir plus : supercross 2019 results, supercross 2019 points, ama supercross 2019 points, dvc points chart 2019, 2019 supercross points standings, dvc point charts 2019, supercross points system 2019, disney cruise points chart 2019, sql table import file indian states list, joomla membership list, html project in table, im on benefits need a divorce need a lawyer that deals in legal fees in southampton no solicitors fees, there is a design that nomarlly appear in a flyer though i don t know what it is called but i really want to learn it, writing in the works 3rd edition ebook, collinear points in real life, finda job in germany no work expirience electrical enginer, graphic design jobs in gauteng no experience, hiring in dubai no palacement fee 2016 marketing specialist, jobs in australia no experience, junior civil engineer jobs in johannesburg no experience needed

Concernant l'employeur :
( 0 commentaires ) Union Grove, United States

Nº du projet : #18759732

3 freelance font une offre moyenne de $170 pour ce travail

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(91 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(2 Commentaires)
2.5