I have a table with people participating in a certain event over the week. I need to get a list of these people that are sorted based on their average position in each column. The goal is to determine which people prefer turning up in the morning, later in the day, or in the evening.
这方面的一个例子是,我想要做到:
| Moday | Tuesday | Wednesday | Average |
|---|---|---|---|
| Sarah | Andy | Sarah | Sarah |
| Andy | Sarah | Andy | Andy |
| Blake | Max | Max | Max |
| Max | Blake | Karen | Blake |
| Karen | Karen | Blake | Karen |
基本上,我需要把这些人排在首位,然后根据我所认为的级别制定一份独一无二的名称清单。
你可以尝试这种做法:
UNIQUE(TOCOL(A2:C,1))之后,在意大利圣公会和圣公会协会的帮助下,你可以穿过每一个名字。
=LET(names,UNIQUE(TOCOL(A2:C,1)),
{names,MAP(names,LAMBDA(each,
BYCOL(A2:C6,LAMBDA(percol,XMATCH(each,percol)))))})
有了AVERAGE,你就能够找到理想的价值名称:
=LET(names,UNIQUE(TOCOL(A2:C,1)),
{names,MAP(names,LAMBDA(each,
BYCOL(A2:C6,LAMBDA(percol,XMATCH(each,percol)))))})
最后,你可以按该栏分类,而不是显示:
=LET(names,UNIQUE(TOCOL(A2:C,1)),
SORT(names,MAP(names,LAMBDA(each,
AVERAGE(BYCOL(A2:C,LAMBDA(percol,XMATCH(each,percol)))))),1))
I m making a script that will populate a Google Sheet with info about our GA4 analytics properties. It starts by listing all our accounts, then looping through them and listing any GA4 properties in ...
I need an urgent help i have data as follows in a google sheet i need to add a year counter to the column d as follows using google apps script
I have a Google Spreadsheet with 3 columns that are either blank or have a value. I want to get the count of the number of rows that has A and either B or C populated. If I were writing a SQL query ...
If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don t know if Google Sheets supports any events. For example: a ...
I am working with a small theatre company. Currently they have a list of people on paper with notes about their skills next to each one. I want to create a database / directory for them so that they ...
I ve seen; Accessing Google Spreadsheets with C# using Google Data API and http://code.google.com/apis/spreadsheets/data/2.0/developers_guide_dotnet.html#CreatingRows However i m still having ...
I have this code which is working, to load a Google Spreadsheet and load some data from it. If the spreadsheet in question is public, how do i modify the code to not require a username/password? $key=...
I ve got a pre-existing Google spreadsheet. Each month I update this document. I ve got a template workseet in the spreadseet that I d like to clone and then update. I d prefer to clone the ...