Forum Discussion

Aaron04's avatar
Aaron04
Occasional Reader
Feb 13, 2026

Formual Error

Trying to create and excel sheet that shows the top 3 tour members for each month of the year but the formula i'm using to show me that information is showing up as an error and i'm confused as to wh...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 13, 2026

An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

Power Query M code:

let
    Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Month"},  
                     {"GetandTransform", (t)=>
                                     let   sort = Table.Sort(t,{"Value", Order.Descending}),
                                           AddedIndex=Table.AddIndexColumn(sort,"Index",1),
                                           SelectRows = Table.SelectRows(AddedIndex, each [Index] < 4)
                                     in    SelectRows }),
    #"Expanded {0}" = Table.ExpandTableColumn(#"Grouped Rows", "GetandTransform", {"City", "Value",  "Index"}, {"City", "Value",  "Index"})
in
    #"Expanded {0}"