• ## Excel - Power Query

### Installing Power Query and Power BI Desktop

by Published on 2018-07-10 12:20 AM

Installing Power Query
The Power Query add-on is installed by default in Excel 2016 and can be found in the Get & Transform section of the Data tab. However, for Excel 2010 and 2013, the add-on needs to be downloaded and installed. You can download the most recent version from the Microsoft site.

1. It takes admin rights to install.
2. You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match your
...

### Legacy Installers for Power Query and Power BI Desktop

by Published on 2017-08-24 07:45 PM

Legacy Installers for Power Query and Power BI Desktop
Let's be honest, one of the incredibly cool things about Power Query and Power BI Desktop is that they are updated monthly. We always get new features and bug fixes, but there is a potential downside ...

### Power Query Connectors

by Published on 2017-08-23 07:51 PM

Data Connectors for Power Query in Excel
One of the things that makes Power Query so powerful is able to connect to almost any type of data source. So how come you find yourself asking, "Why is this connector not available to me?" Well, it very likely has ...
• ### Recent Forum Posts

#### Number of consecutive cells in a row

Optional response to your true meaning : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))- COUNTIF(B1:F1,0)...

Roger Haney Yesterday, 08:55 PM

#### Number of consecutive cells in a row

If I understand you correctly, then this formula will work : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))-1. The " -1 " at the end of the...

Roger Haney Yesterday, 08:30 PM

#### Tracking numbers in a row & counting them in columns

Try this one in I5 copied across and down:

=SUMPRODUCT(COUNTIF(\$H5:\$K5,S\$5:S\$13))

=MAX(range) simply finds the...

AliGW Yesterday, 05:32 PM

#### Tracking numbers in a row & counting them in columns

Ali what you did was perfect and brilliant and I have a use for those numbers in that order.

How would the formula be different if my numbers...

ExcelHelpNeeded Yesterday, 04:51 PM

#### Tracking numbers in a row & counting them in columns

That is brilliant! I was making this soooo much more complicated. I have never used or even seen the &MIN and &MAX though. Can you explain how...

ExcelHelpNeeded Yesterday, 03:34 PM