blackie42
04-08-2016, 04:36 AM
Hi,
Wondering if its possible to do the following
In column C (starting at C10) I have an amount, in column D (again starting at D10) I will start with nothing, a dropdown list/filter
in col G that is set to N to begin with (i.e. C10 does not equal D10)
If I select Y in the filter on that line (because the filter selection has Y unchecked) the line will disappear/hide as it should
My issue is that I can select the Y even though C10 (or any others in that column of course) don't necessarily = D10 -
the line will disappear/hide anyway. I only want this to happen where the amount in cell C = cell D - so matches
Anyway to stop this happening if the 2 cells don't match (and for all cells on cols C& D) when selecting Y in the line filter?
many thanks
Jon
Wondering if its possible to do the following
In column C (starting at C10) I have an amount, in column D (again starting at D10) I will start with nothing, a dropdown list/filter
in col G that is set to N to begin with (i.e. C10 does not equal D10)
If I select Y in the filter on that line (because the filter selection has Y unchecked) the line will disappear/hide as it should
My issue is that I can select the Y even though C10 (or any others in that column of course) don't necessarily = D10 -
the line will disappear/hide anyway. I only want this to happen where the amount in cell C = cell D - so matches
Anyway to stop this happening if the 2 cells don't match (and for all cells on cols C& D) when selecting Y in the line filter?
many thanks
Jon