google-sheetssplitgoogle-sheets-formulacountif
Count and group equal values in the same cell in Google Sheets
In Google Sheets I want to create a formula that separates the values separated by "|" in the "Memory" column and count the same values, so that the result is the same as in the "Result" column:
| Memory | Result |
|---|---|
| 4GB | 4GB | 8GB | 8GB | 8GB | 8GB | 4GB | 3 x 4GB + 4 x 8GB |
| 4GB | 1 x 4GB |
| 4GB | 8GB | 1 x 4GB + 1 x 8GB |
Solution
You can use a formula like this, that splits the values and makes the count:
=BYROW(A2:A,LAMBDA(mem,IF(mem="",,
LET(splitted,SPLIT(mem," | "),
uniq, UNIQUE(TOCOL(splitted)),
counts, BYROW(uniq,LAMBDA(each,COUNTIF(splitted,each)&" x "&each)),
TEXTJOIN(" + ",1,counts)))))
- SUMIF is giving me wacky numbers when inside array. Other answered questions were for more complicated issues. How can I fix this?
- Running a similar App Scripts code on Multiple Sheets
- Shortens the data back to 5 characters if you put more that 5 in
- How to use query and flatten formula in google sheets with null & desc
- How to clear a range in google sheet via gspread
- Conditional formatting if a cell is a duplicate value
- Google Script to return calendar guest names (only) into one cell separated by comma
- onEdit to run only on one cell in one sheet
- How to extract url from Google Sheet Cell with anchor text hyperlink
- Function onEdit(e) works only for single cell edit
- Cancel Script is a cell is RED
- Can we hide column in sheet using google apps script?
- JavaScript function in Google spreadsheets to send QR codes to emails
- Google Sheet Concatenate + Filter
- Google Sheets QUERY is returning with a no column found errors
- Get eventID for Google Calendar Event
- How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?
- COUNTIF Statements: Range Across All Sheets + Cell Reference as Criterion
- Writing a googlefinance wrapper
- Getting a macro to run using checkbox in google sheets
- Auto expanding formula in google sheets to the length of a dynamic range
- Issue in Auto close Modal Dialog - Google App-Script
- CSV extracted automatically into a sheet. Need help for filtering
- How can I sum top 5 values from column in Google Sheets
- Remove duplicates based on one column and keep latest entry in Google sheets (while ignoring blank entries in that column)
- Find the list of different values in 2 tables by id key
- VAT Checker Apps Script
- Script to lock a different tab sheet everyday
- Trigger python code from Google spreadsheets?
- Function to convert Google Sheet Table into one row