Forum Discussion
Akram79
Oct 07, 2022Copper Contributor
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 ...
JoeUser2004
Oct 08, 2022Bronze Contributor
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