Forum

Doh, I misread the year! I shouldn't answer questions at night after a long day 🙂 You can add a Status column to the ledger that marks shares as...

Hi Jae, Have you double checked the source data to make sure there aren't any rows containing the items you're expecting to be gone? If that's not ...

Nope. SharePoint is controlling access to the file. The only way it can be refreshed by someone is for the person with the file open to verify they ar...

Hi Mike, Thanks for sharing your file. Not sure how the Amazon shares work. It appears you bought 28 on Feb 4, then sold 32 on March 3, which i...

No! Sorry. You cannot format the axis labels area. Mynda

Hi Aarun, The formula does use the old date first because the data is sorted by the 'Symbol' and then the 'Date& time' column in ascending orde...

Hi Foday, Welcome to our forum! There are a few issues with the data in your file, most notably, the numbers are text (weights and freight costs), ...

Hi Shafiq, In session 9.08 I cover the ALLSELECTED function. Please watch his session as I think it will address your question. Mynda

Hi Jomili, Can you please upload a sample file from your vendor so we can see how the dates are stored? Note: it's important the file is original, ...

Hi Lew, Welcome to our forum! I wish I had time to build a variation of the dashboard for you. You can use Power Query to get the data from the ...

Hi and welcome to our forum! Please provide a sample Excel file showing your data and desired result so I can understand what you mean. Also, pleas...

Hi Mojtaba, Thanks for clarifying. You don't need an Office 365 account with Excel 2019 to use Map Charts, but I wonder if there is an IP limitatio...

Hi Tom, You can use this formula in cell C5 then copy down (if you're not on 365 you need to enter the formula with CTRL+SHIFT+ENTER): =IF(MATCH...

Hi Mojtaba, Welcome to our forum! I've not seen that error before, but based on what you describe, all I can think is there is an interruption t...

Hi Mike, No file attached. Be sure to click the 'Start Upload' button after selecting your file and wait for the green notification under the butto...