Practical Microsoft 365 articles, implementation notes, and hands-on solutions.
645 articles
Get Collection Column Names Input collection: myTrucks5 Year Make Model Mileage 2020 Ford F150 12343 2018 Chevy Silverado 170567 2020 Ford F150 98765 2017 Ni...
Rank From Highest To Lowest With Ties Input collection: myHighScores28 Name Value Jim Anderson 100 Winnie Lee 78 Jane Nelson 100 Anders Erickson 135 Timothy ...
Get The First Rows Of A Collection Input collection: myCars12 Year Make Model 2016 Toyota Corolla 2014 Honda Civic 2019 Toyota Camry 2018 Honda Civic 2018 Hy...
Get The Last Rows Of A Collection Input collection: myCars13 Year Make Model 2016 Toyota Corolla 2014 Honda Civic 2019 Toyota Camry 2018 Honda Civic 2018 Hyu...
Get The Middle Rows Of A Collection Input collection: myCars21 Year Make Model 2016 Toyota Corolla 2014 Honda Civic 2019 Toyota Camry 2018 Honda Civic 2018 H...
Get The First Row With A Matching Value (Lookup) Input collection: myCars30 SerialNo Year Make Model 6453 2016 Toyota Corolla 8946 2014 Honda Civic 3571 2019...
Group By And Find The AVERAGE Input collection: myTravelExpenses 10 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hotel 1300...
Group By And Find The COUNT Input collection: myTravelExpenses9 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hotel 1300 1/3...
Group By And Find The MAXIMUM Values Input collection: myTravelExpenses 7 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hote...