Need an Excel formule that gets 5 results from a list of data

€8-30 EUR

Ukończony

Opublikowano

ponad 4 lata temu

€8-30 EUR

Płatne przy odbiorze

I have an example table (see attached) containing 14 rows (my real table has 100k+ rows). The example has 8 columns. In the green cells I want 5 results where: - columns D has the value "a" - sorted on column C (low to high) - and then returning column A I'm already able to get results with INDEX and MATCH but the struggle is with the duplicate values in C, there are to rows with A as a value and 808 in column C... The formula has to be done with excel only, so no visual basic tricks. Because I need to be able to change it :-) (I have manually added the expacted results in the orange column. You can't use this values in your formula ;-)

Excel

Data Processing

Data Entry

Identyfikator projektu: 22271840

Informację o projekcie

30 ofert

Zdalny projekt

Aktywny 4 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@nvchien94

Hello there, Can you send me the file? I can download your attachment for looking. I am an Excel expert. I can create these formulas for you. If needed we can create a VBA script that you can easily customize so do not worry about it. Thank you.

€20 EUR w 1 dzień

5,0

(229 opinii)

6,6

30 freelancerzy składają oferty o średniej wysokości €22 EUR dla tej pracy

@P0L

Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.

€30 EUR w 1 dzień

5,0

(479 opinii)

8,0

@sparkingboy2010

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor

€19 EUR w 1 dzień

4,9

(348 opinii)

7,3

@elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

€30 EUR w 1 dzień

5,0

(305 opinii)

7,3

@aparupadas655

Hi there, I can remove the duplicate. Your project requirements match with my profile. I am very flexible in web research, data processing, data entry, data scrapping, data mining and SEO related everything. I can assure you that i will be able to assist you in your task with quality work. Please ping me for sample. waiting for your reply. Thanks...

€15 EUR w 1 dzień

4,9

(215 opinii)

6,6

@TechnoGuruu

Hi, As per requirements I will develop VBA macro for you as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed.I look forward to discussing the project with you and hopefully secure a long term working relationship. I am ready to work on this project now. Thanks and regards, Mohan

€30 EUR w 3 dni

5,0

(99 opinii)

6,5

@Nidhijain123

Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi

€19 EUR w 7 dni

4,9

(134 opinii)

6,6

@wkcompany

Hi there! I read your description. I can make this done in very short time! I am ready to start work right now. i can do this work easily. IF you are interested to work with me message me.

€30 EUR w 1 dzień

4,8

(61 opinii)

5,2

@dervish11

Hello I am highly interested to work with you on this project and can assure you quality results. Thank you

€19 EUR w 1 dzień

5,0

(25 opinii)

4,9

@camcruz031897

Hi, I am interested in this project. 100% quality is my top priority. I'am a new freelancer and I've got 5 consecutively stars and very positive reviews. Please send me a message so we can get started. Hope to hear from you soon. Thank you

€30 EUR w 1 dzień

5,0

(32 opinii)

4,8

@shohelxpertseo

Hi, Can I help you. I've extensive experience ready to start work when you ping me. I willdo this job manually. I'll do the work will be absolutely perfect and sound which can able to make you 100% satisfy of my work. Please full free ask and any query necessary. Best Regards Shohel

€30 EUR w 1 dzień

5,0

(52 opinii)

4,9

@Prompty

Hi, i have seen your attachment. It is fairly clear. With my experience in EXCEL, i can address your problem with formula.

€20 EUR w 2 dni

5,0

(23 opinii)

4,7

@haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks

€30 EUR w 1 dzień

4,9

(30 opinii)

4,3

@hkh581e5c8f1cb8a

Hi Sir, I’m a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Please, feel free to contact me. Thanks

€17 EUR w 1 dzień

5,0

(15 opinii)

4,3

@ritajee

Hi! I'm interested on working on your file. I have good skill on PDF, Data Entry and Excel With VBA/Macro. I'm really organized and pay attention to detail. I'm available to start immediately. If interested, please contact me via chat. Thanks. Rita

€30 EUR w 2 dni

4,9

(4 opinii)

3,8

@whaldane78

I have over 40 years of work experience, in positions of Middle and Senior Management, during which I utilized Excel for Human Resources, Operational, Resources and Financial management and measurement purposes My business is focused entirely on Excel based projects and with my experience and qualifications, I am certain that I will be able to provide you with the service you require. I will be able to advise and complete your project accordingly.

€21 EUR w 7 dni

5,0

(1 opinia)

2,4

@TauseefSatt1

HI. I will insert formula in your excel sheet and organize your data according to that . I am ready to submit this result as a test work. thnanks

€30 EUR w 1 dzień

5,0

(4 opinii)

2,2

@languagedr

I saw your project and want to help with it if you will accept my proposal. Of course, I cannot convince you to but I can give you an assurance of a good job. I agree to do your project. I am an expert on your project-related work. I am an individual person for work but I can provide you with the best quality & accuracy. you can proceed after 100% satisfaction.

€8 EUR w 2 dni

2,2

(6 opinii)

3,4

@lamyaa4ever

Hello, my name is lamiaa , i am software engineer and I am interested in your job offer. Contact me to discuss further details of the project. thanks

€19 EUR w 1 dzień

5,0

(2 opinii)

1,2

@bestsolz1

Hello Sir! I have checked your description regarding attached excel file. I can do your job. For further discussion and getting quick result leave a simple message. Thanks.

€12 EUR w 1 dzień