Đã Hủy

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 thêm: 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, need excel expert create macro, need excel expert match columns, excel expert need simple solution, help need tumblr expert, need excel formula expert, need java expert help, need excel expert

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

Mã Dự Án: #15532128

Đã 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
(563 Đánh Giá)
7.6

17 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
(78 Đánh Giá)
6.4
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
(97 Đánh Giá)
6.0
ESOLUTIONSSS

A proposal has not yet been provided

$25 USD trong 1 ngày
(29 Đánh Giá)
4.5
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 Giá)
4.5
c4cuteconain

With excel can do anything Relevant Skills and Experience Data Entry, Data Processing, Excel Proposed Milestones $25 USD - Data Entry, Data Processing, Excel can discuss on chat

$25 USD trong 1 ngày
(16 Đánh Giá)
3.9
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 [url removed, login to view] i can tell you or apply you such formulas w Thêm

$10 USD trong 0 ngày
(20 Đánh Giá)
2.9
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
(3 Đánh Giá)
2.1
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 Giá)
1.4
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
(2 Đánh Giá)
0.8
Stavroula14

Hi, i am from Greece my name is [url removed, login to view] 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 [url removed, login to view] m Relevant Skills Thêm

$29 USD trong 1 ngày
(1 Đánh Giá)
0.8
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
(0 Đánh Giá)
0.0
rirakib586

Hello, I have good experience with data entry. I usually can catch on to a new job fast as long as the instructions are clear. If you awarded me in this project plz message me. Relevant Skills and Experience Data Entr Thêm

$15 USD trong 1 ngày
(0 Đánh Giá)
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 Giá)
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
(0 Đánh Giá)
0.0
rasifiqbal

A proposal has not yet been provided

$10 USD trong 1 ngày
(0 Đánh Giá)
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 Giá)
0.0