Filtring specefic rows based on a column values

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

Hi there ,

I have a large excel sheet and I need to delete specefic rows with specefic criteria. In the below example , I want to delete all rwos starting from "Dom." until before "log."

Model No.

Cod.

A 4

Dom.

A 7

Res.

A 12

Over.

A 5

Log.

A 8

Cod.

A 10

Dom.

A 13

Res.

A 5

Over.

A 6

Log.

A 9

So the final result I want should looks like this :

Model No.

Cod.

A 4

Log.

A 8

Cod.

A 10

Log.

A 9

I have tried to many times using conditional formating to colour the area between 'Dom.' and before 'log.' so I can then easily remove this area using filter option but I wasn't abe to find a way to tell excel colour only the range I want.

Could you please help me ?

Regards

Excel

Project ID: #20832901

About the project

25 proposals Remote project Active 4 years ago

Awarded to:

TonmoyRoy111

I can help you in pretty quickly. Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kind More

£20 GBP in 1 day
(355 Reviews)
6.9

25 freelancers are bidding on average £21 for this job

HardWorker1989

Hello Sir/Ma'am. I am a professional Virtual Assistant with vast experience in different kind of jobs like Data Entry, Data Management, Website Scraping, Data Sorting, Data Uploading, Document Controlling, Bookkeeping More

£20 GBP in 1 day
(81 Reviews)
6.8
imperturbable54

Hope you are having a great day! I am interested in this project and would like to offer my help. I would like to help with the task and I have an idea of how to achieve this but for that I need to see the excel file More

£15 GBP in 1 day
(137 Reviews)
6.5
citijayamala

I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Ex More

£135 GBP in 3 days
(67 Reviews)
5.7
AnowarRatul

£ 10 ONLY!!! In just 30 Minutes!! [EXCEL VBA MACRO & FORMULA EXPERT] Sir, please CONTACT with me, I can SEND you a DRAFT project file to ensure my EXPERTISE. If you are 100% satisfied first, then please award me the p More

£10 GBP in 1 day
(88 Reviews)
5.2
shahinrahimi

hi and yes I can help you with this problem. you need to delete or filter some rows. we would find the best solution for you. I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to sa More

£15 GBP in 1 day
(50 Reviews)
5.1
sajidkhan45

Hello mate, A simple code can help you do that. Fairly confident that i can sort this out for you. Hope to chat with you soon mate Thanks Sajid

£20 GBP in 1 day
(63 Reviews)
5.7
Mokshith30

Hi https://www.freelancer.in/u/Mokshith30?w=f I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous More

£20 GBP in 1 day
(37 Reviews)
4.5
umairabdillah12

Hi There, I can help you to solv your problem, i have many experience using excel formulas over 10 years, please kindly check my profile. thanks. regards.

£20 GBP in 1 day
(15 Reviews)
4.0
Aragornsan

Good day Sir/Madam I have extensive excel experience and I am certain I can assist with this challenge. I can help you right now if you contact me. This shouldnt take too long to do and I can teach you how to do it on More

£13 GBP in 1 day
(8 Reviews)
4.0
Coworkingeng

Hello According to our experience, this will be an easy job for us. We can prepare the project in less than a day for you. We recently started working as freelancers and we need to upgrade our rankings on the site by d More

£15 GBP in 1 day
(2 Reviews)
1.0
dharshands

I'm a Data analyst and have degree in statistics, I'm good in doing projects, smart worker, quality work, time management, looking for a opportunity

£10 GBP in 1 day
(0 Reviews)
0.0
chhetiamanish

Expert in excel with over 14 years experience in IT. Please connect ; for me to start on task.

£18 GBP in 1 day
(0 Reviews)
0.0
mraouf0702

i can make it to you by filter and pivot tables as i am working as an operations analyst in a company which most of my tasks are on excel

£15 GBP in 7 days
(0 Reviews)
0.0
Superworker0609

I can do the work with high efficiency and will complete the work in time with my knowledge on Excel.

£18 GBP in 1 day
(0 Reviews)
0.0
KANNUTHAKUR

i will complete this project within 5 days.+91 7814228347 this is my Skype number. if you will give me this project please contact me on my Skype id. or send me your data sheet on this My mail ID

£10 GBP in 5 days
(0 Reviews)
0.0
parshurambanda

In particular, my profession skills and managerial experience make me an ideal candidate for the position.

£50 GBP in 7 days
(0 Reviews)
0.0
QuickMostafa

Hello, i am an expert user of excel with 14 years of experience, i can do it in 1 day, error-free, Thank you

£10 GBP in 1 day
(0 Reviews)
0.0
SriniEngg

Hi, I have read your post and understood your requirement. I have great experience in handling excel and documentation works. I can handle this task for sure. I hope we can work together. Kindly initiate the c More

£10 GBP in 1 day
(1 Review)
0.0
singhdivdeep

Greetings I am an Excel expert and have experience in Excel from the past 10 years. I have done much work in Excel. Created my thesis results in Excel. Created the thesis results in Excel of my brother and friends. I More

£15 GBP in 1 day
(1 Review)
0.0
sudheer0703

I HAVE VERY MUCH EXPERIENCE IN EXCEL. AND I CAN EASILY COMPLETE THIS WORK WITH IN SHORT TIME WITH ACCURACY

£15 GBP in 7 days
(0 Reviews)
0.0