Copying only part of a formula from one column into the formula of another.

asked 2019-01-14 17:10:34 +0100

tbaker gravatar image

I'll give the "Why" below, but my question is this: Is there a formula available that will fill in Column 1 with the last numerical digits of Column 2?

Example

Why: I am trying to get the total average of a list that contains items that are often duplicated. Column 2 currently shows the sum of the duplicates and I'm trying to give that sum a name using the final title given in its final sequence. (For example, B204-B207 all have the same basic name with a few minor differences, i.e. Libreoffice, LibreOffice, L1breOff1ce, etc.)

Thank you.

edit retag flag offensive close merge delete