All Questions
6 questions
1
vote
1
answer
132
views
Google Sheets Formula that finds employee with most hours worked for a specific location and shift (INDEX/MODE with multiple Criteria)
In Google Sheets, I need to find out which employee works more than 50% of the hours for a given shift at a given location based on timecard data (Table in col G:J). In the attached google sheet I ...
- 15
1
vote
1
answer
57
views
gSheet - Unable to get results using filter in an array
I'm trying to reference data that has multiple matches using an array formula.
It's not able to find any data. Yet if I change "DTR!C:C=B:B," to "DTR!C:C=B6, B7, etc," and use the ...
- 13
1
vote
1
answer
79
views
Google Spreadsheet ArrayFormula + VLookup Transformation
I have the following table on Google Spreadsheet:
And would need to get the following transformation result:
I precise that for each vegetable i can have only 1 buy price, and 1 or several sell ...
- 25
1
vote
2
answers
319
views
Index-Match with Sum-Function
I have two tabs Product-Overview and Prices.
On the Prices-tab I would like to add my data and get an overview on the financials tab.
I was trying to use index-match, however if there are several ...
- 5,235
0
votes
1
answer
84
views
Filter unique results to reduce the number and order those results by most recent Google Sheets
I have a data set from which I want o filter some data. I have managed to query the data I want which includes selecting where the date is. The problem is that I need to take the formula a little ...
- 85
1
vote
1
answer
44
views
How to count the number of occurences of a string across a range in google sheets?
I've tried combining vlookup and countif functions - match function. But none of them are the actual solution to the problem given how they are supposed to work. I've gone through their documentation. ...
- 11