Filtering

[philb99]

I have three columns H,M L measured against Product Risk based on countries that I sell to, for example I have 3 high , 2 medium and 6 low risk products I sell to Australia

I compare from one month to another.

I need to report all products where the numbers within H, M and L have increased. Therefore if my products to Australia are now 4 high, 2 medium and 5 low, I need to filter out as the rows run into hundreds

I cant just filter on H then M nor can I add the total as some Risk (H,M,L) may have gone up whilst others gone down as you can see from the example

So I need some help in trying to resolve please

 

[S Oberlander]

did you mean to attach an example?

 

[philb99]

did you mean to attach an example?

Sorry here is an update, I am trying to filter so I can capture all of the increases, for example in Austria I wish to see H and L, in Belgium M and L

Country	H	M	L
Austria	2​	-5​	2​
Belgium	0​	1​	1​
Cuba	-1​	0​	1​
Denmark	1​	-1​	0​
Ecuador	4​	0​	1​
France	0​	-4​	6​
Germany	1​	-6​	7​

 

[S Oberlander]

You just want to see for each country if H, M or L increased, or you also want to see how much it increased?

 

[philb99]

You just want to see for each country if H, M or L increased, or you also want to see how much it increased?

The figures posted are the increased amounts, therefore I wish to see Austria showing an increase of H = 2 and L = 2

 

[S Oberlander]

So you want instead of having three columns where you have increase and decrease amounts you only want one column that should tell you just which products increased and how much it increased?

 

[philb99]

So you want instead of having three columns where you have increase and decrease amounts you only want one column that should tell you just which products increased and how much it increased?

Columns will be

Country
H = TOTAL INCREASE
M - TOTAL INCREASE
L - TOTAL INCREASE

 

[S Oberlander]

so how is that different from what you have now?
are you simply trying to clear the cells that have no increase or a decrease?

 

[philb99]

so how is that different from what you have now?
are you simply trying to clear the cells that have no increase or a decrease?

re you simply trying to clear the cells that have no increase or a decrease? - Yes as I have over 300 lines

 

[S Oberlander]

I would do this:
assuming your info is in columns a, b c, and d
In cell E2 =IF(B2>0,B2,"")
F2 =IF(C2>0,C2,"")
G2 =IF(D2>0,D2,"")
copy this down to the end of the data
then hide columns b, c and d