#46 — Find The Category Meeting The Specified Condition

Problem description & analysis:
In the Excel table below, the 1st column is the category and the 2nd column contains detailed data whose values are true or false.

Task: Find the category whose detail data does not have the true value. The expecte…


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Problem description & analysis:
In the Excel table below, the 1st column is the category and the 2nd column contains detailed data whose values are true or false.

original table
Task: Find the category whose detail data does not have the true value. The expected result will be Andy and Tim.

Solution:
Use SPL XLL to get this done:

=spl("=?.groups(~1;count(~2)).select(#2==0).(#1)",A1:B6)

As shown in the picture below:

result table with code entered
Explanation:
groups() function groups and summarizes data; ~1 represents the 1st child member of the current member; #1 is the 1stcolumn of the table.


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing


Print Share Comment Cite Upload Translate Updates
APA

Judith-Excel-Sharing | Sciencx (2024-08-16T03:40:11+00:00) #46 — Find The Category Meeting The Specified Condition. Retrieved from https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/

MLA
" » #46 — Find The Category Meeting The Specified Condition." Judith-Excel-Sharing | Sciencx - Friday August 16, 2024, https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/
HARVARD
Judith-Excel-Sharing | Sciencx Friday August 16, 2024 » #46 — Find The Category Meeting The Specified Condition., viewed ,<https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/>
VANCOUVER
Judith-Excel-Sharing | Sciencx - » #46 — Find The Category Meeting The Specified Condition. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/
CHICAGO
" » #46 — Find The Category Meeting The Specified Condition." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/
IEEE
" » #46 — Find The Category Meeting The Specified Condition." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/. [Accessed: ]
rf:citation
» #46 — Find The Category Meeting The Specified Condition | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2024/08/16/46-find-the-category-meeting-the-specified-condition/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.