Forum

If the FORMAT conditional formatting works it's based on text, not values. Excel also gives numbers formatted as text an order. To answer your ques...

Hi Erik, Glad you got it working. Just to be clear, if your colleagues don't have access to the folders they won't be able to refresh the queries. ...

We've talked about this before. Remember the FORMAT function converts the value to text. You can try writing a formula to base the conditional formatt...

Hi Fendy, The problem is caused because there are multiple matches in your List e.g. item 5, AR is in the value in cell A23 as is item 46, 'MARKOS ...

I agree with Phil and Anders, but some other options are: 1. plot the data on a log scale (chart axis settings) 2. chart the salt intake in a se...

Where is the file where you've tried to add the series?

Hi Yousef, You need to add 5 more series for each leave type. If you right-click the chart > Select Data, you can see how the existing series ar...

Hi Erik, Are the files from each folder consolidated into a separate table? If so, you could just create a separate dynamic file path for each fold...

Hi Amar, This is why it's very important to give the whole picture of what you're trying to do and why. You can use this Power Query formula in ...

Hi Wansley, Welcome to our forum! You haven't attached your file or code, so I can't check it. However, if you want to toggle highlighting of ce...

Hi David, Are you able to upload a sample Excel file so I can see what you mean. I'm not familiar with the blood pressure/salt relationship. Che...

Hi Socheat, Welcome to our forum. It's difficult to be exact without seeing your data, but I would add a conditional column that returns either ...

Hi Gunashekar, Right-click one of the row label fields > Field Settings > Layout & Print tab > check the box 'Show items with no data'...

Hi Chris, Yes, you're supposed to use the filters before combining to exclude the Sheets and only get the Tables, otherwise your data is double cou...

Hi Adam, There is no way to prevent the 'Columns=n' clause being automatically entered in the query. You just have to remember it's there and if yo...