Delete Duplicate Text

[hopeful]

I have a work book inside this workbook there are 7 work sheets (one for
each day). Each sheet uses columns A, B, C, D

I have sheet call weekly all in formation in this sheet from the 7th
everything work fine only one column it has text and there are several
duplicate. Example : clinic A, clinic B, clinic A
How to remove the duplicate from this column to be like this : clinic
A, clinic b and so on

other Questions
I am using this function to get week number =WEEKNUM(C12,1)
is there any way to get it work

Is that possible and if so can someone please help with the formula for
making this work.

Any help would be appreciated.

 

[Mbt6]

I have a work book inside this workbook there are 7 work sheets (one for
each day). Each sheet uses columns A, B, C, D

I have sheet call weekly all in formation in this sheet from the 7th
everything work fine only one column it has text and there are several
duplicate. Example : clinic A, clinic B, clinic A
How to remove the duplicate from this column to be like this : clinic
A, clinic b and so on

other Questions
I am using this function to get week number =WEEKNUM(C12,1)
is there any way to get it work

Is that possible and if so can someone please help with the formula for
making this work.

Any help would be appreciated.

no clue on ? 1, not sure what you are trying to do there
2) perhaps you need to go to Tools / Add Ins and make sure Analysis ToolPak
is checked.