Distinct Group by Index

Hi there, and welcome to the forum.

The steps to do this are:

• Select the Account column of your data -> Transform -> Group

Distinct Group by Index

Hey all,

I'm trying to accomplish a distinct Group-By index, by account number as pictured below and I want this to happen in the Power Query...

when cells value is entered change another cell to "0"

...

= to function

Hi All....

I'm really hoping that someone can assist me.

I have the below formula on one sheet:



...

Calculate a total (countifs)

What is the absolute maximum number of rows you'll ever possibly have to deal with, even in your wildest dreams?
More than a mllion?
Cutting...