Microsoft Ms sla excel lic/sa 3yr-1

Hello all, I have two questions, could you please help me:

1. I have many cells with values like that:

25pq5689

25tyu5689

25ter5689

25QD5689

I need to change letters with numbers (every letter correspond to appropriate number like a=02, b=05, etc...), and I expect to have in results:

250564569

255645689

250125689

2558956892. Next one, I have two columns:

| number | name |

| 29 | N1 |

| 56 | N1 |

| 45 | N1 |

| 58 | N2 |

| 89 | N2 |

| 55 | N3 |

| 65 | N3 |

| 47 | N3 |

| 56 | N4 |

| 10 | N4 |

I need to SUM values from column "number" for N1, N2... from column "name".

I'm a tad confused by your examples. Some of the "input" values have 2 letters and some have 3, yet your outputs don't seem to match those configurations. Were those supposed to be one-for-one inputs/outputs?

Is this a 1 time thing or will you have to repeat this conversion on a regualr basis?

As far as your second question, review the Help files for the SUMIF function.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Thank you very much for SUMIF function. For the first ask I found resolution.

Ask Your Question

Weekly Poll