MICROSOFT EXCEL FORMULA NEEDED

$30-250 USD

Completed

Posted

almost 6 years ago

$30-250 USD

Paid on delivery

Excel Formula Needed For My Inventory. I have 2 Sheets 1ST Sheet is my Inventory Sheet named "2018" Serial Numbers are placed in Column "C" in Sheet 2018 2ND Sheet is my Sold sheet named "Sold05/02/2018" Serial Numbers are placed in Column "c" in sheet "Sold05/02/2018" In sheet "2018" Column M has the value "INSTOCK". In Sheet "Sold05/02/2018 Column M has the Value "05/02/2018 I want my formula to search for the SKU number scanned in Column "C" and search it in the field of Column "C" in both sheet then it replaces the value from Sheet "sold05/02/2018" in column M to the Column M in sheet "2018" Note that the SKU number it searches to replaces can be in different field number so it has to scan the whole column

Data Entry

Data Processing

Excel

Project ID: 16912873

About the project

30 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@sy3d

we can use index/vlookup to match the column c then we can extract sold quantities as far as sku are in different places, that doesn't matter, skus should be same in both sheets please share both sheets, i'll provide demo i am looking your response thanks

$60 USD in 1 day

4.9

(362 reviews)

7.4

30 freelancers are bidding on average $93 USD for this job

@asifdwan

Hi there! I've read the project details and ready to start it right away. I'm an expert in data entry and data scraping jobs. I've huge experience in working on this type projects. I look forward to hearing from you. Regards

$155 USD in 1 day

4.8

(255 reviews)

7.2

@Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "

$50 USD in 3 days

4.9

(274 reviews)

7.1

@khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$55 USD in 1 day

4.8

(332 reviews)

7.3

@DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I have understood the formula you need, and I am positive I can achieve it for you. I would like to take a look at your excel file, to be sure of what would be the best to accomplish it, but probably will be through the use of VBA macros, which will allow the process to be much faster. Thanks

$149 USD in 1 day

4.8

(108 reviews)

7.0

@c4cuteconain

I am a professional accountant with a decade of experience working with excel in a US based NASDAQ registered company's finance department. can make you your excel formula as you described

$30 USD in 3 days

4.9

(107 reviews)

6.1

@khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.

$150 USD in 3 days

5.0

(34 reviews)

5.8

@vlayausa

Hello, I am proficient with Excel and VBA and would love to help you with this problem. Please contact me for more information.

$51 USD in 3 days

4.9

(141 reviews)

5.9

@haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas etc. thanks

$70 USD in 1 day

4.9

(27 reviews)

4.1

@osamasuleman

Hello we are a team of chartered accountants, we have played with this type of data for many years. We can help you with yours as well. Lets chat to discuss it further and get your job done.

$49 USD in 1 day

5.0

(1 review)

0.3

@phamzky

I am an expert in PDF & Specialist on Data Entry. My aim is to provide 100% accurate service to my clients. I am available 7 days a week & very active to respond messages. I have much experience of PDF editing and data entry able do to almost any kind of image editing & data entry. I am here to provide you the best service on standard price. #Expert At (4 years of experience)

$155 USD in 1 day

0.0

(0 reviews)

0.0

@fxfrans6

Good excel

$155 USD in 3 days

0.0

(0 reviews)

0.0

@sherifmao

i can help you at your project at fast time and great performance if you hope to work with me, please get me permission to work at your project at near time

$40 USD in 2 days

0.0

(0 reviews)

0.0

@jatinsinghi

"Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started.

$100 USD in 2 days

0.0

(0 reviews)

0.0

@JIMMYPATEL422

I'm a professional data entry expert. I am here to help you to promote your business with 100% satisfaction. I will provide you fast and reliable service. I'm offering following services in this gig Online/offline data entry Internet research Simple copy paste Lead generation Website research Manual typing Product listing PDF to word/excel Image to word/excel Contact details search Google spreadsheet AND All kind of Virtual Assistant, Admin Support or Office Assistance in any type of data entry Jobs at your fingertips. Why you offer me I will offer you fast and accurate service. Unlimited revision until buyer satisfaction. Thank you, JIMMY PATEL

$155 USD in 3 days

0.0

(0 reviews)

0.0

@nguyenban88

Hello i have read your request and would like to cooperate for you on the job, please contact me, i will do my best, thank you MICROSOFT EXCEL FORMULA NEEDED

$55 USD in 1 day

0.0

(0 reviews)

0.0

@mahmoudkz

I have been able to work in companies of this type for several years but I am now starting to work on the site with sufficient experience in such jobs qualify me to get it I promise you that I will accept my offer and you will find the best service and fastest delivery

$45 USD in 1 day

0.0

(0 reviews)

0.0

@gurramsivakrishn

Hello, I have found your project interesting & very familiar to me. I have worked on 2 similar stock related projects & many excel related projects. I can finish off your work with high satisfaction Relevant Skills and Experience I have excellent excel skills and have experience in providing projects in time without fail. I can handover the mentioned work in 2 days. I will support you if you need help further..

$35 USD in 2 days

0.0

(0 reviews)

0.0

@husnahakim

Hai!May God bless you wherever you are! I am interested in job related to excel. I am interested to do this job where I can fully utilize my skills and make a significant contribution to the success of the employer and at the same time my individual growth

$111 USD in 5 days

0.0

(0 reviews)

0.0

@AnteMijic

Hi, the task you are asking is quite simply solved. Just send me a message and I will do it! I work as a DWH programmer, so I am quite familliar with all kind of database problems :)

$55 USD in 1 day