N
nil jones
I have two columns (A & B) with data. I'm trying to come up with a
third column consisting of cells that appear in column A and not in B.
(Due to the way I have hidden some columns of strings this 3rd column
will be G). I have used the formula =(COUNTIF($A:$A,B1)=0)*(B1<>"") to
conditionally format everything in B that isn't in A. These cells
missing from A have been shaded.
I'm either trying to select and move just these formatted (shaded)
cells into column G (and from there to another file) OR use some other
process (not conditional formmatting) to simply output what's missing
from A into my 3rd column.
Is there a way to select only cells with a particular formatting? If
not, what should I do to populate this 3rd column with cells in B and
not in A.
Thanks! nil jones
third column consisting of cells that appear in column A and not in B.
(Due to the way I have hidden some columns of strings this 3rd column
will be G). I have used the formula =(COUNTIF($A:$A,B1)=0)*(B1<>"") to
conditionally format everything in B that isn't in A. These cells
missing from A have been shaded.
I'm either trying to select and move just these formatted (shaded)
cells into column G (and from there to another file) OR use some other
process (not conditional formmatting) to simply output what's missing
from A into my 3rd column.
Is there a way to select only cells with a particular formatting? If
not, what should I do to populate this 3rd column with cells in B and
not in A.
Thanks! nil jones