G
Guest
Range("T4:T1443").Formula = "=IF(COUNTIF($H$4:$H$1443,H4)=1,H4)"
try as i may my ifcount always evaluates as false where as i want it show me
my unique product list - i dont care if the other cells are false
i appreciate all the help and i have got vba to enter the formula which is a
step forward but im not sure i understand the ifcount principal as i thought
it would do this
my code is shown below and i have been careful with both quotes and $ signs;
Sub spot_duplicates()
Sheets("Data").Select
Range("v4:v1443").Formula = "=IF(COUNTIF($H$4:$H$1443,$H$4)=1,H4)"
End Sub
try as i may my ifcount always evaluates as false where as i want it show me
my unique product list - i dont care if the other cells are false
i appreciate all the help and i have got vba to enter the formula which is a
step forward but im not sure i understand the ifcount principal as i thought
it would do this
my code is shown below and i have been careful with both quotes and $ signs;
Sub spot_duplicates()
Sheets("Data").Select
Range("v4:v1443").Formula = "=IF(COUNTIF($H$4:$H$1443,$H$4)=1,H4)"
End Sub