All Questions
3 questions
0
votes
3
answers
39
views
Filter data (Not In) based on condition within two data sets in Google sheet
Have employee data set with status active and relieved. And the second data set has the time they have reported to the office. Trying to achieve the names of employee who are absent for the day using ...
- 169
0
votes
1
answer
47
views
How to aggregate string by specific ID - (String1 - a)(String1 - b)(String2 - a)(String2 - b)
I need to be able to aggregate strings and the values of another cell based on the string value and its identifier value.
I have tried a couple of ways of summing the values, and filtering by ...
1
vote
1
answer
42
views
Is there a way to extract a particular string from a cell?
I'm trying to extract the value between round brackets of some substring that is part of a string separated by ,, and then add all those values.
For example:
Cell A1 : Text4(5),Text1(7)
Cell A2 : ...
