LinkBack URL
About LinkBacks
Vanjul 
you could post a sample file and expected output...
or if i got you right
=if(A1="Cu",1,2)
you could post a sample file and expected output...
or if i got you right
=if(A1="Cu",1,2)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
so the data is like this:
Column A
Elment
Zr
Cu
Zr
Cu
Zr
Cu
Zr
Zr
Cu
Zr
Zr
Zr
Cu
Cu
Zr
Zr
Cu
Cu
Zr
Zr
Zr
Zr
Cu
Zr
Cu
Zr
Zr
Cu
ColumnB
type
1
1
1
1
1
1
1
2
2
2
2
2
2
as I mentioned there are tonnes of rows and I want the output as
Zu 2
Cu 1
Zr 2
Cu 1
......
and so on its like wherever I have Zr I want the type 2 and for Cu as 1.
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks