Function IF problem to big

**pejot** · 03-06-2013, 09:36 AM

Hi,
I have cal like this

2columns
-id_engine
-engine

9000 rows

    id_engine       Engine
            0.0 (49 kW)
            0.0 (49 kW)
            0.0 ZEV (80 kW)
            0.7 (50 kW)
            0.8 (38 kW), 1.0 (47 kW)
            0.8 (38 kW), 1.0 (47 kW)
            0.9 (29 kW)
            0.9 (29 kW)
            0.9 TCe (66 kW)
            0.9 TCe (66 kW)
            0.9 TCe (66 kW)  13–, 1.5 dCi (66 kW)  13–
            0.9 TCe (66 kW)  13–, 1.5 dCi (66 kW)  13–
            0.9 TCe (66 kW)  13–, 1.5 dCi (66 kW)  13–
            0.9 TwinAir (62 kW)  12–, 1.4 (51 kW)  12–, 1.4 (58 kW), 1.4 (70 kW), 1.4 (77 kW)
            0.9 TwinAir (62 kW)  12–, 1.4 (51 kW)  12–, 1.4 (58 kW), 1.4 (70 kW), 1.4 (77 kW)
            0.9 TwinAir (62 kW)  12–, 1.4 (51 kW)  12–, 1.4 (58 kW), 1.4 (70 kW), 1.4 (77 kW)
            0.9 TwinAir (62 kW)  12–, 1.4 (51 kW)  12–, 1.4 (58 kW), 1.4 (70 kW), 1.4 (77 kW)
            0.9 TwinAir (62 kW)  12–, 1.4 (51 kW)  12–, 1.4 (58 kW), 1.4 (70 kW), 1.4 (77 kW)
            0.9 Twinair (63 kW)  10–, 1.3 D Multijet (55 kW)
            0.9 Twinair (63 kW)  10–, 1.3 D Multijet (55 kW)
            0.9 Twinair (63 kW)  10–, 1.3 D Multijet (55 kW)
            1.0 - 70 (50 kW), 1.4 Hdi (40 kW)
            1.0 - 70 (50 kW), 1.4 Hdi (40 kW)
            1.0 (40 kW)
            1.0 (40 kW), 1.1 (46 kW)
            1.0 (40 kW), 1.1 (46 kW)
            1.0 (40 kW), 1.1 (46 kW)
            1.0 (40 kW), 1.1 (46 kW)
            1.0 (43 kW)
            1.0 (43 kW)
            1.0 (43 kW)
            1.0 (43 kW)
            1.0 (43 kW)
            1.0 (43 kW)
            1.0 (43 kW)
            1.0 (44 kW), 1.0 (55 kW)
            1.0 (44 kW), 1.0 (55 kW)
            1.0 (44 kW), 1.0 (55 kW)
            1.0 (44 kW), 1.0 (55 kW)
            1.0 (44 kW), 1.0 (55 kW)
            1.0 (44 kW), 1.0 (55 kW)
            1.0 (44 kW), 1.0 (55 kW), 1.0 Hybrid (50 kW)
            1.0 (44 kW), 1.0 (55 kW), 1.0 Hybrid (50 kW)
            1.0 (44 kW), 1.0 (55 kW), 1.0 Hybrid (50 kW)
            1.0 (44 kW), 1.0 (55 kW), 1.0 Hybrid (50 kW)
            1.0 (44 kW), 1.2 (51 kW)
            1.0 (44 kW), 1.2 (51 kW)
            1.0 (44 kW), 1.2 (51 kW)
            1.0 (44 kW), 1.2 (51 kW)
            1.0 (44 kW), 1.2 (51 kW)
            1.0 (45 kW), 1.0 (52 kW), 1.0 Turbo (62 kW), 0.8 CDI (33 kW), 0.8 cdi (40 kW)
            1.0 (45 kW), 1.0 (52 kW), 1.0 Turbo (62 kW), 0.8 CDI (33 kW), 0.8 cdi (40 kW)
            1.0 (45 kW), 1.0 (52 kW), 1.0 Turbo (62 kW), 0.8 CDI (33 kW), 0.8 cdi (40 kW)
            1.0 (45 kW), 1.0 (52 kW), 1.0 Turbo (62 kW), 0.8 CDI (33 kW), 0.8 cdi (40 kW)
            1.0 (48 kW), 1.2 (63 kW)
            1.0 (48 kW), 1.2 (63 kW)
            1.0 (48 kW), 1.2 (63 kW)
            1.0 (48 kW), 1.2 (63 kW)
            1.0 (48 kW), 1.3 DDiS (55 kW)
            1.0 (48 kW), 1.3 DDiS (55 kW)
            1.0 (50 kW)
            1.0 (50 kW)
            1.0 (50 kW)
            1.0 (50 kW)
            1.0 (50 kW)
            1.0 (50 kW), 1.2 (60 kW)
            1.0 (50 kW), 1.2 (60 kW)
            1.0 (50 kW), 1.2 (60 kW)
            1.0 (50 kW), 1.2 (60 kW), 1.4 (70 kW), 1.4 HDi (50 kW)
            1.0 (50 kW), 1.2 (60 kW), 1.4 (70 kW), 1.4 HDi (50 kW)
            1.0 (50 kW), 1.2 (60 kW), 1.4 (70 kW), 1.4 HDi (50 kW)
            1.0 (50 kW), 1.4 D (66 kW)
            1.0 (50 kW), 1.4 D (66 kW)
            1.0 (50 kW), 1.4 HDI (50 kW)
            1.0 (50 kW), 1.4 HDI (50 kW)
            1.0 (51 kW)
            1.0 (51 kW)
            1.0 (51 kW)
            1.0 (51 kW)
            1.0 (51 kW)
            1.0 (51 kW), 1.0 LPG (Gas) (60 kW)
            1.0 (51 kW), 1.0 LPG (Gas) (60 kW)
            1.0 (51 kW), 1.0 LPG (Gas) (60 kW)
            1.0 (51 kW), 1.3 (64 kW)
            1.0 (51 kW), 1.3 (64 kW), 1.4 D-4D (66 kW), 1.3 (74 kW)
            1.0 (51 kW), 1.3 (64 kW), 1.4 D-4D (66 kW), 1.3 (74 kW)

and i want in 1 column(id_engine) get same id(number) wchen in column(engine) is the same name

I done form like this

....

=IF(H2="0.0*(49*kW)";"1";
IF(H2="0.0*ZEV*(80*kW)";"2";
IF(H2="0.7*(50*kW)";"3";
IF(H2="0.8 (38 kW), 1.0*(47*kW)";"4";
IF(H2="0.9*(29*kW)";"5";
IF(H2="0.9*TCe*(66*kW)";"6";
IF(H2="0.9*TCe*(66*kW)  13–, 1.5*dCi*(66*kW)  13–";"7";
IF(H2="0.9*TwinAir*(62*kW)  12–, 1.4*(51*kW)  12–, 1.4*(58*kW), 1.4*(70*kW), 1.4*(77*kW)";"8";
IF(H2="0.9*Twinair*(63*kW)  10–, 1.3*D Multijet*(55*kW)";"9";
IF(H2="1.0*(40*kW)";"10";
IF(H2="1.0*(40*kW), 1.1*(46*kW)";"11";
IF(H2="1.0*(43*kW)";"12";
IF(H2="1.0*(44*kW), 1.0*(55*kW)";"13";
IF(H2="1.0*(44*kW), 1.0*(55*kW), 1.0*Hybrid*(50*kW)";"14";
IF(H2="1.0*(44*kW), 1.2*(51*kW)";"15";
IF(H2="1.0*(45*kW), 1.0*(52*kW), 1.0*Turbo*(62*kW), 0.8*CDI*(33*kW), 0.8*cdi*(40*kW)";"16";
IF(H2="1.0*(48*kW), 1.2*(63*kW)";"17";
IF(H2="1.0*(48*kW), 1.3*DDiS*(55*kW)";"18";
....

But its too big becouse have 1720 rows

Please help me