admin管理员组

文章数量:1127989

Hi everybody,

I'm new to Google Spreadsheets and I found a lot of tips online but some things won't work at all.

Every person to the left (A9:A23) has a particular race schedule and this sheet is a tracker of which rider competes in which race. Whenever the cells D9:M23 are NOT empty, it fills with a particular color (based on race strenght) so its easy to keep track.

First question: How can I link every value in a row together so whenever I would sort a particular column, the other cells (of that row) also change position, linked to the corresponding person?

Second question: Your seeing "sorteer" buttons in D8:M8. Whenever clicked on this button, I would like to sort that column based on the fact if there is a value/color inside or not. With this button I would see which persons compete in that particular race. So for example in E9:E23 everyone with the x in that cell (or colour) would be grouped towards the top of the column. If for example Ben O'Connor (E13) would move to the 3rd spot in the list, all his other "race confirmations" would also move to the 3rd position. Thats what I also mean with the first question

If anyone could help, it would be much apreciated! Sorry for my lingo, new to GS.

Greetings,

MD

Watched a lot of YT videos and read articles on the topic but it didnt help.

Hi everybody,

I'm new to Google Spreadsheets and I found a lot of tips online but some things won't work at all.

Every person to the left (A9:A23) has a particular race schedule and this sheet is a tracker of which rider competes in which race. Whenever the cells D9:M23 are NOT empty, it fills with a particular color (based on race strenght) so its easy to keep track.

First question: How can I link every value in a row together so whenever I would sort a particular column, the other cells (of that row) also change position, linked to the corresponding person?

Second question: Your seeing "sorteer" buttons in D8:M8. Whenever clicked on this button, I would like to sort that column based on the fact if there is a value/color inside or not. With this button I would see which persons compete in that particular race. So for example in E9:E23 everyone with the x in that cell (or colour) would be grouped towards the top of the column. If for example Ben O'Connor (E13) would move to the 3rd spot in the list, all his other "race confirmations" would also move to the 3rd position. Thats what I also mean with the first question

If anyone could help, it would be much apreciated! Sorry for my lingo, new to GS.

Greetings,

MD

Watched a lot of YT videos and read articles on the topic but it didnt help.

  • sorting
  • hyperlink
  • cell
  • spreadsheet
  • group
Share Improve this question edited Jan 9 at 7:58 Rafael 1,9372 gold badges25 silver badges61 bronze badges asked Jan 8 at 15:50 Maxim DuquesneMaxim Duquesne 211 silver badge2 bronze badges New contributor Maxim Duquesne is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
Add a comment  | 

1 Answer 1

Reset to default 0

A useful link with instructions could be found here . Please check the colored paragraphs :

If needed, let us now what you have tried and when you get stuck send us where, in order to help you.

本文标签：

版权声明：本文标题：hyperlink - Google Spreadsheets - Grouping cells in 1 row + sorting based on valuecolours in the column - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736707743a1948771.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。