Formula Please

[Dazzawm]

A bit tricky to explain this one but would be a great help if it can be done.


In columns B & C I have various data stretching down 21000 rows. I need a formula to do the following:-

Starting in E2 I need it to look at the information in column B and put 001 whenever the information is the same in column E, but if the info is different in column C then put 002 in each cell in E and so on

e.g
cell b2 abc123 cell c2 456 cell e2 001
cell b3 abc123 cell c3 456 cell e3 001
cell b4 abc123 cell c4 789 cell e4 002
cell b5 abc123 cell c5 123 cell e5 003
cell b6 abc456 cell c6 456 cell e6 001
cell b7 abc456 cell c7 789 cell e7 002

and so on..

I hope I have explained myself ok!!. Thanks

I can e-mail an example spreadsheet if someone PMs me.

 

[Aladin Akyurek]

I notice there are references to 'D1' put there is nothing in 'D1'?

That's right. I have "Concat" there as field name. See the exhibit.

 

[Dazzawm]

Thank you so much for all your time and help. You have saved me quite some time if i had to do all these manually. Again many thanks.