Categorising Data into Separate Views based on some criteria.

[jmd25]

Hi all

I am trying to undertake a categorisation of various products into 3 tables based on the following conditions.

1. Products where interest is always charged

2. Productions where interest is sometimes charged

3. Products where interest is never charged

For example, if I have input table below:

ID	Product	Interest Paid
1	Toaster	Yes
2	Toaster	No
3	Laptop	Yes
4	Phone	No
5	Car	No
7	Toaster	No
8	Food	No

I would like to be able to split this into the following views:

Interest Always Paid

ID	Product	Interest Paid
3	Laptop	Yes
6	Laptop	Yes

Interest Sometimes Paid

ID	Product	Interest Paid
1	Toaster	Yes
2	Toaster	No
7	Toaster	No

Interest Never Paid

ID	Product	Interest Paid
4	Phone	No
8	Food	No

I have tried doing this using a filter by Interest Paid = Yes, then joining the True vs False outputs. But the data set is pretty big and the J output is huge.

Welcome any suggestions,

Thanks in advance,

Kind Regards

[cjaneczko]

Here is one way. With the info filtered like this you can output to different tabs/sheets or a layout report.