How to get data that only have value

[botakilmu]

Hi all members. I want to get data as in picture below. I want to get data from column that only has the price. Thank you for your help, very appreciate it.

5555.JPG

[6StringJazzer]

Sorry but your question is unclear. Why do you want to remove PENCIL and ERASER in the final version?

[botakilmu]

Sorry its my mistake,, this is what I want. I want only column have a price and I don't want to include item have no price.Attachment 855607

[botakilmu]

Sorry but your question is unclear. Why do you want to remove PENCIL and ERASER in the final version?

Sorry my mistake, i have add new image for reference. I wan to get item and price column that has the price shown only. I hope you understand and thank you for your reply.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[botakilmu]

Hi, I'm sorry about not reading the rules. I'll change the image to excell sheet. Thank's for your advice.

[DJunqueira]

My solution.

Please Login or Register  to view this content.

Press [Ctrl]+[Shift]+[Enter]