This worked for me, now how can I get this total as you see above to pull from one sheet into another sheet, is it a query? what would the formula then be if you can help me
Sure, happy to help. Can you expand on "get this total as you see above to pull from one sheet into another sheet", please? I am not sure I understand what this total refers to and whether you need to transfer the data between sheets of the same document or different documents.
Hi, what formula should I use if I have 3 columns with multiple dropdown selections and I need to get the total number of each value from that columns. Example: The drop down list is just the same as the sample above but I need to add more column for specific dates. Dunno if I make sense but yeah
If I understood you situation correctly, you need to count how many times each unique dropdown value appears in three different multi-select dropdowns. You can do it with this formula: =LET(all_values, FLATTEN(MAP(A1:C1, LAMBDA(values, FLATTEN(SPLIT(values, ", ", false))))), QUERY(FILTER(all_values, all_values ""), "SELECT Col1, COUNT(Col1) GROUP BY Col1")) The formula assumes that dropdowns are in A1:C1. It will output a table with all options in one column, and number of occurrences in another. This formula can be tweaked in many ways, depending on your use case.
![The Power of Named Ranges in Google Sheets [2024]](http://i.ytimg.com/vi/btmvZuQsgjM/mqdefault.jpg)
![The Power of Named Ranges in Google Sheets [2024]](/img/tr.png)
Nice Video❤
This worked for me, now how can I get this total as you see above to pull from one sheet into another sheet, is it a query? what would the formula then be if you can help me
Sure, happy to help. Can you expand on "get this total as you see above to pull from one sheet into another sheet", please? I am not sure I understand what this total refers to and whether you need to transfer the data between sheets of the same document or different documents.
Hi, what formula should I use if I have 3 columns with multiple dropdown selections and I need to get the total number of each value from that columns. Example: The drop down list is just the same as the sample above but I need to add more column for specific dates. Dunno if I make sense but yeah
If I understood you situation correctly, you need to count how many times each unique dropdown value appears in three different multi-select dropdowns. You can do it with this formula: =LET(all_values, FLATTEN(MAP(A1:C1, LAMBDA(values, FLATTEN(SPLIT(values, ", ", false))))), QUERY(FILTER(all_values, all_values ""), "SELECT Col1, COUNT(Col1) GROUP BY Col1"))
The formula assumes that dropdowns are in A1:C1. It will output a table with all options in one column, and number of occurrences in another. This formula can be tweaked in many ways, depending on your use case.
How do you chart / graph non-numerical dropdown multiple selection data?
Interesting question. Can you give more details about your use case and/or sample data?
@@dataful-tech I sent you an email!