Hi to All,
First of all sorry for my english...
I need help with a formula in excel. I have in one sheet several columns with data. Imagine that in column A I have a code and in column F I have a value. I need in sheet number 2 the total of values of the codes that finish in some values. Example:
Sheet 1
Code ---- Value
AB123 -----2
AC123 -----3
AB133 -----6
AA124 -----1
AB124 -----8
Sheet 2
Semi-code-----Total
123-------------5
133-------------6
124-------------9
This semicode can be hard coded or the right 3 digits of Code.
Thank you very much
JK
Bookmarks