Function IF problem to big

[pejot]

Hi,
I have cal like this

2columns
-id_engine
-engine

9000 rows

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

But its too big becouse have 1720 rows

Please help me

[hamjam]

Hello
Do you have the full MS Office on your PC or just Excel ?
The simplest and quickest will be to copy your data into MS Access and to run a simple query on it :

This will list all unique values. You can re-copy to Excel and number them in sequence.

Regards

[JBeaucaire]

the MATCH function may be all you need:

=MATCH(H2, $G$2:$G$1000, 0)

[pejot]

Hello
Do you have the full MS Office on your PC or just Excel ?
The simplest and quickest will be to copy your data into MS Access and to run a simple query on it :

This will list all unique values. You can re-copy to Excel and number them in sequence.

Regards

Unfortunatly its home/students edition :/

the MATCH function may be all you need:

=MATCH(H2, $G$2:$G$1000, 0)

Not working excel 2007 and google spreadsheet

[FDibbins]

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[JBeaucaire]

Match certainly works in all version of Excel. This isn't a Google Docs forum, so we won't be going into that. Definitely post a file if you can't get a simple MATCH to work, seems like it should.