All Questions
3 questions
0
votes
2
answers
186
views
Google Sheets Bucket Monthly Country Data (QUERY?)
I have a Google Sheets spreadsheet of monthly data showing percentages by country. There are a few countries and EU that we are trying to highlight, along with grouping the rest of the countries as &...
- 11
1
vote
1
answer
539
views
Count values based on both row and column condition in google spreadsheets
I've got the following table:
Next to that I have the following table:
The value in column Q of the second table is calculated with the following function:
=COUNTIF(INDEX(B:M,MATCH(P1,A:A,1),0),&...
- 790
1
vote
2
answers
1k
views
How to duplicate rows based on columns? Google sheets (only formulas please)
I have something like this:
Item
Color
Id
TEST1
WHITE
ID001
ST01
ST02
ST03
TEST2
RED
ID002
ST02
ST03
And i want to have something like this:
Item
Color
Id
TEST1
WHITE
ID001
ST01
TEST1
WHITE
ID001
ST02
...
- 13