Last seen: Jun 23, 2026
This thread might give you some ideas. You'll still need to fix any data that doesn't conform to your list e.g. CampAB without the space.
Hi Chris, I'm using Office 365. You can try updating your version of Excel to see if you get the new functions. In regards to your messy data. E...
Congratulations on your persistence to get it working!
Hi Aye, Still not completely clear, but I'm assuming you want to find the first instance of Y in row 1 and return the date in row 3 + 1. The second...
Hi Cheryl, You can add a step after 'Source' with this formula which will change the text of headers to upper case: = Table.TransformColumnNames...
Hi Andrea, You just need to change the order of the series in the chart 'Select Data Source' dialog box. Right-click the chart > Select Data >...
Hi Chris, Yes, you can extract the camp from the text string and then use Merge Tables to bring in the Region column. See example attached. Mynd...
Hi Aye, I suspect there might be some information missing as this is a fairly easy IF formula: =IF(F1="Y",F3+1,"") Please let me know if I mi...
You're welcome, Luna. You can always renew your membership for 50% off 😉 See your 'My Profile' page for details.
I suppose you could use an IF formula that populates the cells based on a certain condition. e.g. you could have a check box (see session 5 of the Das...
An alternative to Excel Survey is to build a User Form with VBA that will take the user through the questions and deposit the answers in a table that ...
There is a known bug with PivotTables losing the connection to the source data. It can happen if you rename or save a copy of the file containing the ...
Hi Mike, It's difficult to picture what your workbook currently looks like and what you have in mind. Yes, I'm sure you could make it more appealin...
Hi Mike, You'd need to use a macro/VBA for this. You could try recording a macro and then assigning it to a button. If you get stuck, please post y...
You could try temporarily changing the PivotTable source and then change it back. The only other place might be a named range, but this wouldn't trigg...