Forum

Hi Ian, Have you got an actual Excel file? That image is small and I can't read it to understand what the issue is or the results you want. You...

Thx Riny

Hi Ian, No file is attached. You have to click Start Upload after selecting the file(s). Please supply an example of the result you are after, ...

Hi Susy, You can use .Attachments.Add Range("A1") where A1 contains the full path to the file. This post explains in further detail Create PD...

Hi Sunny, You can get this error when your source file has more columns in it than there were originally when the first import was done and the hel...

Hi David, See attached workbook for the formula. Writing something like this is a bit of a nightmare because Excel's formula editor is pretty rubb...

Hi Saliha, Check out this post, it may be useful for you Count, Sum and Average Colored Cells Regards Phil

Hi Jep, Nothing is attached. After selecting your file(s) you need to click on the upload button to actually upload them to the website regar...

Hi Carla, Please provide a sample file and show an example of the result you are looking for. Regards Phil

Hi Steven, No file is attached. You have to click the Upload button to load the file. Read This First | Forum Rules and Guides | Excel Forum • M...

Hi Emmanuel, You should do this with a Pivot Table - it will do the sum calculations automatically for you Excel Pivot Tables Explained • M...

Hi Rhonda, Please see this comment for a file that does what you ask Select Multiple Items from Drop Down (Data Validation) List • My Online Tra...

Yes, my code already does that. Have you tried using it? regards Phil

Hi Emmanuel, You're file did not upload but I could work it out from your description. This is the formula you need =IF(OR(B3="Cheryl",B3="De...

Hi Glenisa, If you supplied your file that would help to see your measure and data, but without it I can only give an example of this formatting. ...