Excel: Data cleanup & sorting formula

Đã hoàn thành Đã đăng vào 2 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

I am looking for someone to help me with Excel. I am attaching a sample excel file and looking for someone to provide me with formula & steps to clean up/sort the data.

Basically I want to see all IDs, when there is:

- CODE and CODE-M values are same

AND

- APPROVE = N OR No value

AND

ID Must have a value

Excel Xử lí dữ liệu Visual Basic

ID dự án: #32749574

Về dự án

46 đề xuất Dự án từ xa 2 năm trước đang mở

Được trao cho:

(1128 Đánh Giá)
8.3

46 freelancer chào giá trung bình$24 cho công việc này

daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Thêm

$20 CAD trong 1 ngày
(153 Nhận xét)
7.0
merinsinha

I can start. Excel expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Thêm

$25 CAD trong 1 ngày
(130 Nhận xét)
5.5
rumarahman

Hi Sir, ✅ I am an Excel Expert ✅ Gone through the job details and happy to help you. I am an expert in excel formulas, dashboards, macros. I will be able to finish before the deadline. Thanks Ruma

$45 CAD trong 1 ngày
(57 Nhận xét)
5.5
hamidr2020

Hi, I can help and provide you formula and steps to clean up and sort data as demonstrated in the attached file and based on CODE, CODE-M, APPROVE and ID criteria mentioned. I am an Excel expert. You can check my revie Thêm

$15 CAD trong 1 ngày
(50 Nhận xét)
5.3
PERPETUAL0

Hello there i can do it within short time regards ILYAS

$30 CAD trong 1 ngày
(101 Nhận xét)
5.5
mhfsha

Hello sir/ madam I checked your project description. I can do Microsoft Excel task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saan Thêm

$20 CAD trong 1 ngày
(96 Nhận xét)
5.3
ACCASpogmai

"Hello Sir, I WILL provide you formula & steps to clean up/sort the data. Text me to discuss further. I am an advance level EXCEL EXPERT and all Excel related work. This task is very easy ,I will complete this task wi Thêm

$15 CAD trong 1 ngày
(21 Nhận xét)
3.9
MamukaB

Good Day ( Edited/Added Text: I already make code, that can be used for any like this file and get result I also can provide instruction how and which formulas and steps must use, for get correct result ) I have 15+ y Thêm

$30 CAD trong 1 ngày
(14 Nhận xét)
3.9
EDSRD

Hi, I can write formulas to check if Code and Code-M matches and with approve status as either N or no value. I can even write a macro code if required to make the same checks. Kindly contact me and assign the work Thêm

$20 CAD trong 1 ngày
(13 Nhận xét)
3.3
Maherun75

"""Hi There, I am a Professional writer with 5 years of experience. I hold an M B A and first Degree in Economics which provides me with the necessary background to handle your projects. I provide 100% free plagiarism Thêm

$20 CAD trong 1 ngày
(3 Nhận xét)
2.6
Jayedbinjasim

I have completed the FMVA certification and this was part of the program. I am sure I would be able to serve you better with the skills that I have. Looking forward to discuss with you in details.

$11 CAD trong 3 ngày
(3 Nhận xét)
2.2
CPanayi

Hello there. Excel and VBA expert. Your request seems very straight forward. I can have that ready in an hour!

$20 CAD trong 7 ngày
(1 Nhận xét)
1.7
gauravatbest95

Hey, I can do this for you in a day. Kindly DM if interested to discuss the details. I can do it for a fixed 30$.

$30 CAD trong 1 ngày
(2 Nhận xét)
1.3
sana1aa

hi I am a data entry specialist proficient in Microsoft Office excellent typing speed and deliver project on time having ability to complete tasks i hope you consider me for your project Thanking You

$20 CAD trong 1 ngày
(2 Nhận xét)
0.6
Excelchief

Please forget all automatic bidders and give me a chance. I can do this work very fast and be available all the time. Don't pay more. My work is quality, you don't need to hire a person with lots of comments. Do you ne Thêm

$15 CAD trong 1 ngày
(0 Nhận xét)
0.0
aftabyarkhoon

Hello Finding myself a good fit for the project requirements I am offering my services for your project. I can demand even less than the bid amount.

$10 CAD trong 2 ngày
(0 Nhận xét)
0.0
Bimshendra99

Hi There, My name is Bimshendra & I have 8 plus years of experience in Banking & finance sector. I'm new to Freelancer & I'm looking for my 1st project. Since I'm in Banking sector I handle excel day in & day out. I Thêm

$15 CAD trong 7 ngày
(0 Nhận xét)
0.0
DanLepage

Hi there, This is a relatively easy project and id love to help you out. There are functions to be used to validate your properties (as you specified in your post) and I can add VBA coding to hide different rows if th Thêm

$30 CAD trong 7 ngày
(0 Nhận xét)
0.0
payoussef

Hi, my name is Peter, I’m a trilingual computer engineer. I have more than three years of experience in business operations and reporting. I usually handle regular mails and reports easily all day using Microsoft offic Thêm

$20 CAD trong 2 ngày
(0 Nhận xét)
0.0
ZafarQaimkhani9

Hi there! I am an expert in Data cleanup & sorting formula in Excel. I have excellent knowledge and Experience in Excel, MS Word, Google Sheet, Data Entry, Internet Research. Delivery within frame time and Quality of w Thêm

$15 CAD trong 1 ngày
(0 Nhận xét)
0.0