Prev: can not upload or access server with my frontpage wizzard
Next: Milo: Using Fp2003 to allow people to add an Outlook Calendar ite
From: Maracay on 30 Dec 2009 12:30
Hi Guys

I have a column (A) with different concepts repeated several times, what I
want is to create another column (B) having the concepts just 1 times. Ex.

Column A Column B
Trucks Trucks
Cars Cars
Trucks Bikes
Bikes Air Planes
Bikes
Cars
Trucks
Cars
Air Planes
Bikes

I will really appreciate if someone can help me with this.

Thanks

From: ANONYMOUS on 30 Dec 2009 15:28
You need to copy and paste your data in Excel and then sort the data
alphabetically. Once this is done, in column B you need to enter the
following formula:

In B! enter: =A1
In B2, enter: =IF(A2<>A1,A2,"")
Copy the formula in B2 to all the cells below it.

You are done.

Incidentally, this has nothing to do with FP 2003 so please post your
queries to the appropriate newsgroups.

hth

Maracay wrote:

>Hi Guys
>
>I have a column (A) with different concepts repeated several times, what I
>want is to create another column (B) having the concepts just 1 times. Ex.
>
>Column A Column B
>Trucks Trucks
>Cars Cars
>Trucks Bikes
>Bikes Air Planes
>Bikes
>Cars
>Trucks
>Cars
>Air Planes
>Bikes
>
>I will really appreciate if someone can help me with this.
>
>Thanks
>
>
>
 | 
Pages: 1
Prev: can not upload or access server with my frontpage wizzard
Next: Milo: Using Fp2003 to allow people to add an Outlook Calendar ite