using countif from a vba macro
hi all
i have a problem with a countif function if anyone could help please do : (
im a novice user so forgive me if my use of system is not as it should be )
i have a range H4:H1443.. its full of product name with many duplicates
as in ;
chris
tony
brian
chris
h4 is start of range
H1443 is end of range
what i want to do in vba in cells t4:T1443 is write something like -
if ifcount(H4:H1443,H4)=1,h4) to be placed in cell T4
and then in T5 using if ifcount(H4:H1443,H4)=1,H5)
formula works when i type it in excel but how do i put it into a vba macro ?
--
C Ward
|