I need an excel expert

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 4 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

using pivot tables I am trying to sort a year's worth of hourly traffic volume counts. I am using the large function to return the 30th highest hours. I am using sumproduct to index the date and time to return. sumproduct does not return the correct date and time when there are two volumes that are EXACTLY the same. See tab labeled "82_002_EB ALL" The highlighted items are not returning correctly. Not looking to do CTRL +F to get date and time. I have hundreds of these sheets to do and need a formula to return date and time of the hours selected. I also could not get the LOOKUP formula to work.

Ταυτότητα εργασίας: 27874716

Σχετικά με την εργασία

6 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 4 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@MohsanEijaz

I am an excel and vba expert. I can fix the vlookup and other issue. Malik

$30 USD σε 1 ημέρα

5,0

(98 αξιολογήσεις)

6,6

6 freelancers δίνουν μια μέση προσφορά $20 USD για αυτή τη δουλειά

@rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

$20 USD σε 1 ημέρα

4,8

(38 αξιολογήσεις)

5,3

@BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 54 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done on personal finance applications. Looking forward to hearing from you. Thank you BAVarun PS: Please have a look at the reviews given to me on this platform.

$20 USD σε 7 ημέρες

4,8

(67 αξιολογήσεις)

5,5

@Jatin77777

Hello, I have gone through with contents and attached files to understand the requirements. This is pretty straight forward task and I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more Thanks, Jitender Kumar

$30 USD σε 1 ημέρα

5,0

(24 αξιολογήσεις)

4,7

@vnbhardwaj93

Hello, I read your requirement and I am pretty confident that I can complete your project with utmost proficiency and with zero errors. I have vast experience in working on MS excel and MS word. You can see that I have no ratings and no reviews as I am new to freelancer.com. At the moment, I am looking to build reputation here. So I can do this project free of cost. Lets discuss further regarding this project so that we can work on it as soon as possible Looking forward to hearing from you. Thankyou.

$10 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

2,0

@foyej115

My name is Foyej. I am happy to be a member of the freelancer community. My hobby is to provide the best service to my clients. When no one is happy with my work I try my best to offer the client 100% guaranteed satisfaction. I will do any data entry work

$12 USD σε 7 ημέρες