Normalization

How can i normalised my data to 1NF, 2NF and 3NF using excel.

Normalizations usually involve the transformation of data in the format
y=a*x+b
Let's put you a-factor in A1 and your b-factor in B1. If your raw data is
in C1 thru C100, then in D1 enter:
=$A$1*C1+$B$1
and copy down
--
Gary's Student


"Jar" wrote:

> How can i normalised my data to 1NF, 2NF and 3NF using excel.

Excel isn't a database, so it doesn't support relational database concepts.
(assume 1NF means first normal form and so forth as defined by Codd).

--
Regards,
Tom Ogilvy




"Jar" <Jar@discussions.microsoft.com> wrote in message
news:1EE010F8-BB79-48D5-83B3-7706B253F1B1@microsoft.com...
> How can i normalised my data to 1NF, 2NF and 3NF using excel.