RenameColumns(
AddColumns( GroupBy( Ungroup( AddColumns( SPList, Data, Split( CountriesVisited, "," ) ), Data ), Value, Year, Grouped ), Visits, CountRows(Grouped) ),
Value,
Country
)
ShowColumns(
RenameColumns(
Ungroup(
AddColumns(
SPList,
Data,
Split(
CountriesVisited,
","
)
),
Data
),
Value,
Visited
),
Name,
Year,
Visited
)
WarrenBelz
292
Most Valuable Professional
MS.Ragavendar
167
stampcoin
130