Assistance with index formula
I'm in need of assistance on an Index formula. The situation is I have a master sheet with a unique number in the Primary Column. Another column has a flag. In my second sheet, I would like returned a list of the unique numbers from the master sheet where the flag=true. I have tried so many versions of this formula that I don't know what is up any more. Currently I have:
Can anyone assist with this formula?
Help Article Resources
Check out the Formula Handbook template!