hi, everyone
i am using below event to add unique data to my range as i input data

Please Login or Register  to view this content.
what does above code?

when i input data in range B10:B300 Then code add this data to range Column(X) but unique only

now i want here
when i input data in range F10:F300 then code add data of range B10:B300 and add unique value to Column(X)

Note: range B10:B200 have formula so i want to add only result of formula (value)
FORMULA
Please Login or Register  to view this content.
Capture3.JPG
thanx