Đã hoàn thành

Need Excel expert to help figure out a formula to identify a particular criteria

We have a large excel sheet that has something like this:

LINE: ORDER # ITEM

1 0001 iPhone

2 0001 Charger

3 0002 iPhone

4 0002 Charger

5 0002 Case

6 0003 Charger

7 0003 Case

8 0004 iPhone

9 0004 Charger

10 0004 Case

We need to find and delete all rows from orders that do not have "iPhone" in it. So for example, Order #001 is ok because there is iPhone in Line 1.

Order #002 is ok because there is iPhone in the order (Line #3)

Order #003 is BAD because nowhere in Order #003 is there an iPhone. There is only Charger (Line #6) and Case (Line #7). So we need to delete/clear Line #6 and Line #7 to remove Order #003.

Order #004 is ok because there is iPhone on Line #8

So we need someone to provide method, instructions, or formula to allow us to fix a spreadsheet that contains thousands of rows.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem nhiều hơn: excel find function, find text in excel, excel vlookup return multiple values horizontally, vlookup multiple criteria, excel substring function, excel vlookup return multiple values vertically, search formula in excel, excel find character in string, need help with excel expert consultant in marathahalli, need expert help with excel vlookup, need excel expert on hire, excel expert help online, excel expert help free, excel expert help beaumont tx, excel expert help bangalore, any company need excel expert from home, microsoft excel expert help, i need excel expert, excel formula help need onetomany vlookup type of formula, excel expert help

Về Bên Thuê:
( 71 nhận xét ) Corona, United States

ID dự án: #15532128

Được trao cho:

cgullapalli

Hi, I have reviewed the question and i can use sumproduct formulas and sumif formula to get the required. Looking forward to work on the project. I can provide instructions in the chat. -Chandra Relevant Skills an Thêm

$24 USD trong 0 ngày
(667 Đánh Giá)
7.7

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

ReliableMate

Need to delete those rows that do not have "iPhone" on the cell Relevant Skills and Experience Excel Proposed Milestones $20 USD - Work

$20 USD trong 0 ngày
(102 Nhận xét)
6.5
ianfosgate23

I can help you produce the best formula for this. I have worked on similar projects and can assist you now. Won't take long. Please message me. Relevant Skills and Experience Excel Proposed Milestones $30 USD - Miles Thêm

$30 USD trong 0 ngày
(130 Nhận xét)
6.3
ESOLUTIONSSS

A proposal has not yet been provided

$25 USD trong 1 ngày
(32 Nhận xét)
4.6
prabakarm23

I have worked on similar projects before, If awarded i can make it with 100% accuracy and Satisfaction Relevant Skills and Experience I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creati Thêm

$35 USD trong 1 ngày
(46 Nhận xét)
4.6
bktk

Hi sir I am offering my services of row deleting which is with out i phone in excel according to instruction on urgent basis. Sir I have done several project [login to view URL] i can tell you or apply you such formulas w Thêm

$10 USD trong 0 ngày
(34 Nhận xét)
3.7
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks. Relevant Skills Thêm

$25 USD trong 1 ngày
(8 Nhận xét)
3.1
MizanurWorker

Hello Dear Sir, I read your project and I understand that what type of rearmament do you need to complete this project .Sir give me the files and let's start it's very easy project for me . Relevant Skills and Exper Thêm

$25 USD trong 0 ngày
(3 Nhận xét)
2.3
arshadsa

I am confident that I can do the required work efficiently and within a very short time. I have completed very similar project before. Relevant Skills and Experience Macro, Excel VBA, Programming Proposed Milestones Thêm

$55 USD trong 1 ngày
(1 Nhận xét)
1.4
Stavroula14

Hi, i am from Greece my name is [login to view URL] s clear what you need to keep orders with iphone in a line.i am able to do it no matter how many lines you have b using pivot table andthen [login to view URL] m Relevant Skills Thêm

$29 USD trong 1 ngày
(1 Nhận xét)
0.9
mmhasankc

Hello I'm a Digital Marketing Specialist with 3 years Experience. Specially I am Expert in Data Entry, Data Processing, Excel Relevant Skills and Experience Data Entry, Data Processing, Excel Proposed Milestones $25 Thêm

$25 USD trong 1 ngày
(1 Nhận xét)
0.0
Rajeshu7

I am good at ms excel And i can keep the data in specific and simple with conclusion

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
seoexpertlg

Hi, I am very professional and have valuable experience in data entry, excel, data processing. I have already done project like this recently. I would be very interested in working with you. Relevant Skills and Expe Thêm

$11 USD trong 1 ngày
(1 Nhận xét)
0.0
rasifiqbal

A proposal has not yet been provided

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
parasharwebservi

Updating the Sheet by separating/removing the records as per mentioned criteria Sharing the method/formula Relevant Skills and Experience Advanced Excel VBA Proposed Milestones $15 USD - Updating Data and Sharing met Thêm

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