Hi,
Assuming that your original data starts at A2 use
IF(A2=10,"AA",IF(A2=23,"HZ",IF(A2=7,"PM",0))) in cell B2 and then copy down
as needed.
This only works for this specific example so if you need to include more
numbers you will have to add more nested "IF" functions... Bear in mind that
you can only nest up to 7 "IF". In case you need more you will need to find
a different way...
Hope this helps...
Ο "pinar" <pinar @discussions.microsoft.com έγραψε στο μήνυμα
...
Hi I have a question regarding to excel. I have a column includes numbers.
It
is like;
Number:
10
10
7
7
23
55
40
I need specific numbers, lets say that, I only need number 10, 7 and 23
and
then I have to form a new column by using the data in the number column,
for
example
If the number is 10 write AA
If the number is 7 write PM
If the number is 23 write HZ
And the other numbers can be deleted or can be 0
So at the end , I have to have something like that
Number Name
10 AA
10 AA
7 PM
7 PM
23 HZ
55 0
40 0
I have around 10 different numbers .Is there any body knows how to do it
in
excel. better without writing any macro?
Thanks a lot