Google Sheets Sort rows by highly active non blank first?

发布于 2020-11-29 13:09:11

I have a large sheet where participant data are entered in either positive or negative values. If they did not participate the cell is blank.

         D1  D2  D3  D4  D5  D6
Player1  20  -5   3  50     -10
Player2      10   8      -8 
Player3      -9  98  46  -89 
Player4  10      25

I would like to sort by most active players to least, how to achieve that? As of now I'm summing the data and sorting high to low now but it is evidently inaccurate to know the "highly active"

Questioner

Nix

Viewed

Original

Alok 2020-11-29 22:56:38

So you can introduce a new column (say Nonparticipation) in the start, I mean immediately after Player name column and use COUNTBLANK function to check how many blank cells are there in a row, and then sort that column Nonparticipation from lowest to highest, so lowest value of Nonparticipation mean highest active player.

热门github

A multi-platform library for OpenGL, OpenGL ES, Vulkan, window and input

Dev tool that writes scalable apps from scratch while the developer oversees the implementation

shadcn/ui, but for Svelte. ✨

The Python Risk Identification Tool for generative AI (PyRIT) is an open access automation framework to empower security professionals and machine learning engineers to proactively find risks in their generative AI systems.

Performance-portable, length-agnostic SIMD with runtime dispatch

ZK Credo

OpenCodeInterpreter: Integrating Code Generation with Execution and Refinement

Joplin - the secure note taking and to-do app with synchronisation capabilities for Windows, macOS, Linux, Android and iOS.

Mamba is a new state space model architecture showing promising performance on information-dense data such as language modeling, where previous subquadratic models fall short of Transformers. It is based on the line of progress on structured state space models, with an efficient hardware-aware design and implementation in the spirit of FlashAttention.

This repository contains System Design resources which are useful while preparing for interviews and learning Distributed Systems

Curso para aprender el lenguaje de programación Python desde cero y para principiantes. 75 clases, 37 horas en vídeo, código, proyectos y grupo de chat. Fundamentos, frontend, backend, testing, IA...

🎓 Path to a free self-taught education in Computer Science!

1️⃣🐝🏎️ The One Billion Row Challenge -- A fun exploration of how quickly 1B rows from a text file can be aggregated with Java

A collective list of free APIs

📚 Freely available programming books

Google Sheets Sort rows by highly active non blank first?

热门帖子

热门github