Forum Discussion

Akram79's avatar
Akram79
Copper Contributor
Oct 07, 2022

Multiplication of string and values

Hi everyone,   I have a Excel file where there two columns, one is Description (Column A) and Quantity (Column B). Now in that Description Column there are items which are repeating(has exact same ...
excel
Formulas and Functions
office 365
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Oct 08, 2022

Akram79 

 

A picture is worth a 1000 words.  And an Excel file is worth 1000 pictures.

 

Ideally, click "browse" at the bottom of the reply window to attach an Excel file.  The Excel file should demonstrate expected results, which you might cobble together manually,

 

If the forum does not permit that (yet), upload the Excel file to a file-sharing website, and post the download URL.  I like box.net/files; others like dropbox.com.  You might like onedrive.live.com because it uses the same login as this forum.  But in that case, IMHO, be sure that the download URL does not allow others to edit the file.  Thus, others cannot make changes by accident (or on purpose).  (I'm all thumbs.  sigh)

 

If the forum does not permit you to post URLs (yet), spell out the URL.  For example, the URL for this thread is techcommunity dot microsoft dot com /t5/excel/multiplication-of-string-and-values/td-p/3647602

Resources