Charity Data Geek

Power BI, Power Query, Campaigns, Stats, Data Visualization, Raiser's Edge, Excel, GDPR and Data Protection. What could possibly be more fun?

Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Thursday, 24 July 2025

Excel's yellow triangles when imports matches no exports

›
  If you've ever seen a yellow triangle here the chances are it might have taken you a while to fix it. When I asked Co-Pilot it was use...
Wednesday, 5 July 2023

Formula for converting US dates to UK in Excel

›
If you've ever imported data from a US supplier into a (UK) spreadsheet you may have found that the dates and times have gone wrong in E...
Friday, 28 October 2022

Add extra rows in Power Query dependent on value in cell/column

›
If you're working in Power Query, and you need to add a whole bunch of blank rows, or rows based on the value from another column. How d...
Thursday, 20 October 2022

How do you sum a total for a column in Power Query?

›
Power Query has a "Count Rows" button, but there's no equivalent button for when you want to quickly get the total of your val...
Monday, 9 October 2017

Get a List of Excel Tab Names and Compare Headers on Multiple Tabs

›
Get a List of Excel Tab Names 1. Go to Formulas > Define Name 2. Then in the New Name box, put Tabs in to the "Name" box 3. ...
›
Home
View web version

Contributors

  • GoatShipMate
  • Matt Page
Powered by Blogger.