Here are two solutions:
=if(isna(vlookup(a1,b:c,1,false)),"",a1)
or
If you want to know how many times it repeats you can do:
=countif(b:b,a1)
But, neither takes into account if the item in column A repeats itself.
For creating a list like your expected output, I don't know.
I was afraid of that. Too bad the Word development team doesn't work with the Excel development team. Word has much better options to use.
Thanks anyway!
Hi everyone,
Is there a way of automatically entering a user's name into the footer without using VBA? I haven't found any solution yet that works without me having to get into the VBA side of it.
This is as far as I've gotten:
printed &[Date] @ &[Time] by ...
Your help is appriciated.
D