Excel formula

In Excel (Apple numbers), need a formula to look at 4 cells, in 20 different rows (so 80 cells total), and identify the 3 cells that contain the highest numeric values, and then for those 3 cells, each has a different cell to look to if it was one of the top 3, and then taking those 3 numbers in the referenced cells and producing a result based on a rule as to what numbers are in the 3 referenced cells. This same type of formula would need to be modified 3 more times to do the same, but for top 5, 10 and 15 cells. Also would need to replicate each formula a few times just to change rows being looked at for cells.

Skills: Excel

See more: job hiring data encoder excel type home based, cell address based vlookup result macro excel, zillow zestimate formula excel, screen scrape formula excel, payment formula excel, capitalised interest formula excel, yield formula excel, tiered pricing formula excel, paste formula excel, call web service formula excel, excel data type data process cnet 2008, ranking formula excel lowest number, mma type web based games, rank formula excel, excel macro cut paste based cell value, excel content type extjs, hide rows page based result page, lowest bid formula excel, quickbooks import excel name type, reading excel file pega rule, formula excel, advertising formula excel, interest payment formula excel

About the Employer:
( 7 reviews ) Lake Forest, United States

Project ID: #12164652

Awarded to:


Hello, I would like to work on your project, I have great experience using Excel and macros, vba. I have had many similar work before. I would like to work on your sample file. Provide please further details. Thank you More

$50 USD in 2 days
(65 Reviews)

40 freelancers are bidding on average $79 for this job


"I have read your project description clearly and what I understood is you want some formulas in Excel. I am expert in advanced excel formulas and agree that we can complete tasks with high quality and [login to view URL] More

$30 USD in 1 day
(109 Reviews)

Hello there! I would love to work on this project. I am a Qualified Chartered Accountant (CPA equivalent) with 5 years of experience in the field of accounts, auditing, taxation and financial management. I am curren More

$166 USD in 3 days
(80 Reviews)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y More

$150 USD in 5 days
(92 Reviews)

Could you send me the Excel spreadsheet please? I would like to take a look at the data and possibly give you sample formulas. Regards,

$35 USD in 1 day
(89 Reviews)

Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$77 USD in 3 days
(74 Reviews)

Hello, I am Excel and VBA expert. Can I see the file? What is rule to produce a result "on those cells"? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$88 USD in 1 day
(51 Reviews)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$89 USD in 2 days
(39 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o More

$100 USD in 1 day
(66 Reviews)

- Can build the macros to look for the 4 cells wihin the 80 cell range and bring up the max 3, max 5 etc. - - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macr More

$80 USD in 2 days
(25 Reviews)

A proposal has not yet been provided

$200 USD in 5 days
(22 Reviews)

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$60 USD in 0 days
(28 Reviews)
$55 USD in 3 days
(12 Reviews)

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating strings and numbers between sheets and using calculations. More

$45 USD in 3 days
(30 Reviews)

Dear the client, It's super easy. why did they bid so high? My name is Hai, I'm an expert in VBA programing and excel template, contact me and, I'll offer the best price I'll also provide samples of my work upon req More

$30 USD in 1 day
(12 Reviews)

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens More

$55 USD in 3 days
(9 Reviews)

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if y More

$100 USD in 2 days
(11 Reviews)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec More

$30 USD in 1 day
(14 Reviews)

A proposal has not yet been provided

$77 USD in 1 day
(4 Reviews)

Feel fee to contact me for excel formula and [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment onl More

$30 USD in 3 days
(6 Reviews)
$30 USD in 1 day
(3 Reviews)