Extract list from range Google Sheets
I have some data from workplaces with some different work areas, I need to extract a list for each workplace with their corresponding availables working areas, I have an example of some kind of attempt really close what I wanted. I use this formula but with more data will be long time to do it =IF(D2=$G$1, "Yes", "No"). I want to do it more automatic with some formulas but I don't know where to start.
Solution
Give a try on below formula. Put the formula to G1 cell then drag down as needed.
=TRANSPOSE(IFERROR(FILTER($D$2:$D$16,$A$2:$A$16=F2,$D$2:$D$16<>""),""))
- Length filter for list not working correctly
- How to get sorted list of map keys in Go?
- Doing math to a list in python
- Is there a way to use two if conditions in list comprehensions in python
- Find maximum value and index in a python list?
- How can I manually (with an explicit loop) find the index of the maximum value in a list?
- How to find all positions of the maximum value in a list?
- Transpose list of lists
- Transpose/Unzip Function (inverse of zip)?
- Why does Python return None on list.reverse()?
- Why is `tranpose [[]] == []` in Haskell?
- C# List with Unique data based on the Date
- Java 8 Streams remove duplicate entries, keeping the element with the min date
- Pop multiple items from the beginning and end of a list
- How to get the first value in a Python dictionary
- Inheriting from List<T>
- vim: How to search/replace in all opened files?
- Checking to see if a list of lists has equal sized lists
- Parse yaml into a list in python
- Splitting a list into N parts of approximately equal length
- How to traverse a base R list vertically/by rows using R's characteristics
- Create a program to ask a number and print all divisors
- Apply function to one element in a list of lists
- python get first x elements of a list and remove them
- list cbind with two list element in R
- Non-alphanumeric list order from os.listdir()
- GetValueOrDefault or null-coalescing for Dictionary or List
- Convert one element in list to uppercase in Python
- material ui: how to change fontSize in Lists?
- How to find all occurrences of an element in a list