Ask Your Question
0

Filter exact items [closed]

asked 2014-04-21 22:04:55 +0200

epiblue gravatar image

Hi all,

I'm looking for solution to filter items from my product list.

I have one document with all the categories and the products in those categories. And second file is a list of all the product's combined with prices etc.

I want to make separate file for every category.

So I need to make a custom filter to filter the items from column:A in column:B

Example: Columns A:

TS0100
TS0150
TS0200
TS0250
TS0300
TS0350
TS0400
TS0450
TS0500
TS0550
TS0600
TS0650
TS0700
TS0750
TS0800
TS0900
TS1000
TS2000
TS3000
TS4000
TS5000
TS6000
TS7000
TS10000
TS15000
TS20000
TS30000
TS50000
TS100000

Column B

TR8EKIT
TR8ERTR
TR8TERTR
T8V3
TR8KIT
TR8TRTR
T02001
T02002
T02003
T02004
T02005
T02006
T02007
T02008
T02008S
T02009
T02010
T02011
T02012
T02013
T02014
T02015
T02016
T02017
T02018
T02019
T02020

What is the easiest way to do it?

Sorry, I'm a newby wih LibreOffice Calc

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 06:56:47.408632

1 Answer

Sort by » oldest newest most voted
0

answered 2014-04-21 23:45:29 +0200

m.a.riosv gravatar image

updated 2014-04-21 23:48:47 +0200

Hi @epiblue, IMO except you really have the need for have the items in a separate places, please don't do it. Adding a column with the category I think is more useful, and you have several tools that work nicely with tables, as the Pivot table or Subtotal and the rest of tools in Menu/Data.

You can do it with Menu/Data/Filter/Standard filter, choosing in more options set up a destination for filtered data.

Calc documentation

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2014-04-21 22:04:55 +0200

Seen: 79 times

Last updated: Apr 21 '14