Do some Excel Work
£10-20 GBP
Pago na entrega
Hello
I am hoping that someone will be able to write a formulae for me, when making the solution no vba please.
What I need:
I have a spreadsheet, in it there is a table in cells a1:p8. The data contained is organised in columns, (1 column per product)
Now not all columns have data in them , the products in column c, h, I n do not have info in them
What I need is a formula that will effectively consolidate the data in this table in to a new table on the same page, depending on whether row 2 is greater than 0. My new table will be in a12:p19
So effectively my new table will contain the products in the 1st table but will miss out the products (row 2) that have a 0 value.
You can complete this how you want, have additional rows to test the data and calculate which rows to bring down, but please no vba Maybe you will use if statements, maybe you will combine this with indexing the 1st table – I am not sure.
I have an excel document attached to show what I need and how it should look like
Once I have the soloution I will be able to copy it in to my much larger document which covers more products in addition to the data shown
Thank you for your time and good luck with the project should you chose to complete
ID do Projeto: #6598961
Sobre o projeto
Concedido a:
I have the solution to your excel, no vba, FULL FORMULAS. check the file here: [login to view URL] regards Aldo
31 freelancers estão ofertando em média £16 nesse trabalho
Such jobs are my daily practice. I have a solution ready for you. Fixing of bugs and minor changes are included in the bid without any additional fees.
Hi: Please note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects are related to Excel. Please connect with me to discuss more.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets and formulas. I am the expert you need to solve your project. Check my reviews and chat Mais
Hi..Thank you very much posting the job. *****************************************************************************I solved the problem. You can get the file*********************************
Hello, I am very much interested in this project. I am responsible and honest. I have the ability to learn quickly. I am capable for following instructions very well. I am a team player. Please see my profile for addit Mais
Hi. I'm good at computer, reliable and best typist. Can work right away and looking forward to work with you. Thank you.
Hi , I am having excellent work exp in data typing, copy writing, article writing and in excel work.I pursue high communication skill and work as a senior software engg in top indian MNC. Please consider my profile
Hello, I can easily do this assign, because I work with formulas every day. It is not hard and you'll get the output in a short time
Greetings for the Day!!! I have 5 years of Experience in VB, VBA Macros with SAP, Internet explorer, PDF and Text Files, MS Access and SQL server databases. And also in Excel and advanced excel formulas, charts, Mais