Forum Discussion
kris10yagerduarte
Jun 17, 2024Copper Contributor
generate a list of instances
Hello. Please see this example of what I'm trying to do. I don't want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a s...
dscheikey
Jun 17, 2024Bronze Contributor
Hi, there is also a function for filtering. The formula is
=FILTER(myTable[Case No],(myTable[Severit]="c")*(myTable[Type]="dog"))
kris10yagerduarte
Jun 17, 2024Copper Contributor
Thank you. Would this not just generate a filtered table?