Forum

It works for me, Mey. If you change cell A2 to 6:18:00 the result in B1 is 0:03:30 and the conditional format is yellow fill. Mynda

Hi David, You can choose a different delimiter in the CSV dialog box that appears after you click the double down arrow to expand the binary. Also ...

Can't do it, as far as I know. Why don't you provide Slicers so your boss can filter the data to show the detail he's interested in?

Hi Ian, Yes, you should load all of your tables into Power Pivot. You'll need to add a dimension table that contains a unique value for the account...

Hi Digalo, I'm not clear on how you're getting your data, whether it's going into multiple sheets in the file or multiple files etc. An example fil...

My two cents; it's not clear if the files are being saved to SharePoint or OneDrive/OneDrive for business. I know when I save files to OneDrive even a...

Hi Deepak, You have two issues, firstly the range you're looking up in your VLOOKUP formula is A1:K162 but the Folder column in Sheet 2 is in colum...

Hi Cheryl, I don't blame you for feeling daunted. That report sure is ugly. In the attached file I've cleaned and unpivoted the data and you'll ...

Ah, I'm afraid you've reached the limitation of regular PivotTables. You'll need to use Power Pivot and write a DAX measure for that. Mynda

Hi Frans, In the PivotTable options > Data tab there is a check box for 'Refresh data when opening the file'. Also, if your data is from an e...

Hi Mary, Ideally your data should be in a tabular format for this. i.e. the survey question should be in one column and all the scores in another. ...

Hi David, Follow these steps: 1. Put your two files into a folder on their own. i.e. no other files in that folder. 2. change the sheet names...

Hi Mary, I'm not clear on whether you want to calculate an average across the criteria, the total table or the average of one criteria (e.g. even q...

Thanks, David. You can use Power Query to easily merge ELE_Sheet-A and TAK_Sheet-A files into something that resembles the 'Main.xlsx' file, since ...

Hi David, Nothing attached. Please add your file again and then click the orange 'start upload' button to upload the file. In the meantime from ...