How can i normalised my data to 1NF, 2NF and 3NF using excel.
G Gary''s Student Oct 17, 2005 #2 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
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
T Tom Ogilvy Oct 17, 2005 #3 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).
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).
