In the table below you will see values so you can easily understand what I am asking for! This is what I have and which have no pattern in cells!
I want this as seen in the table below. I highlighted myself to show you what I have and what I want in the adjacent column!
Can anybody help me with this thing because I have to do it for thousand of rows and I do it manually until now.
Your quickly help and answers are appreciated.
Hi
Use combined IF and LEN functions
=IF(LEN(B2)=9,A1,B2) ect
Hi
Use combined IF and LEN functions
=IF(LEN(B2)=9,A1,B2) ect
Hi Tomasz,
how to deal with the following in table.
The formula worked until characters of supplier no was different that product no. but afterwards you find in the table given at the end product and supplier no are same in character.
Can you please help!
Thanks in advance!
Hi Ubaid
Please see the file
The best solution for that it could be to create a table with all suppliers number if you know them (or you can update every time if appears a new one)
=IF(COUNTIF(Table1[SupMatNr],B3),B3,A2)
I guess what you are trying to do, but first, I will have to see the source of the data, you can do that with the PivotChart Wizard, it is potentially the quicker way
