Forum

Hi Jimmy, Do you have a workbook with sample data we can see? Regards Phil

Hi, I understand what you are asking but in your sample file, the Expected Output has no data in it and the sample data layout is incomplete? Ma...

Hi Bill, No VBA required for this, see attached workbook. =SUBSTITUTE(A1,","," and",LEN(A1)-LEN(SUBSTITUTE(A1,",",""))) By using SUBSTITUTE t...

Hi Trond, There's no attachment. Regards Phil

Hi Humayun, This is what you are looking for these posts will also help Regards Phil

Hi Hope, Please provide a workbook with data. Recreating your data takes time and is prone to error if we do it by hand. Best for you to supply i...

Hi Tiffany, You're calculating a percentage by dividing three numbers =IFERROR(1-((SUMIF($D$18:$D$67,E$1,$P$18:$P$67))/(SUMIF($D$18:$D$67,E$1,$O...

Hi Martin, Please supply the workbook so we can help. Phil

Hi, Your description and the images you supply don't match up so I'm finding this a little confusing. There is no Col C shown in the images...

Hi Anna, The name of the file you uploaded and the name in the code weren't the same, so once I amended the code, this worked fine. There were onl...

Hi John, at the top of the course page there's a link to Download Course Files. In that download is a workbook with sample data. Regards ...

without seeing your code I can't do anything

Hi Pablo, Can you share the file with us? Phil

Hi Anna, Can you please share your workbook with data. I thought you are maybe trying to overwrite a file that already exists, hence the 002, 00...

Hi Kayla, Do you mean you want the button to appear on all pages, or for whatever code it executes to act on all pages? Always best to supply yo...