vzachin
01-23-2008, 06:14 AM
hi,
i have data in column C. in column B i have the unique values by doing an advanced filter. and finally in column A, i have a countif formula that will give me the count of the unique values from column C.
this was all done manually.
is there a way to write this in vba:
to place the count of the values in corresponding Column A
thanks
i have data in column C. in column B i have the unique values by doing an advanced filter. and finally in column A, i have a countif formula that will give me the count of the unique values from column C.
this was all done manually.
is there a way to write this in vba:
to place the count of the values in corresponding Column A
thanks