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.


--
hopeful
------------------------------------------------------------------------
hopeful's Profile: http://www.excelforum.com/member.php...o&userid=30149
View this thread: http://www.excelforum.com/showthread...hreadid=498325

"hopeful" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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.
>
>
> --
> hopeful
> ------------------------------------------------------------------------
> hopeful's Profile:
> http://www.excelforum.com/member.php...o&userid=30149
> View this thread: http://www.excelforum.com/showthread...hreadid=498325
>

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.