Forum Discussion

RBoyerr's avatar
RBoyerr
Copper Contributor
Aug 19, 2022
Solved

Having trouble printing names from one column into another table's rows If a condition is met

PC/Windows 10 Pro Excel Version 2207 (Build 15427.20210) https://edisonfordwinterestates-my.sharepoint.com/:x:/g/personal/rboyer_edisonford_org/ETWZCpmtkttEpZRI3qH4360B034AFsEOBox5IavN81c8hQ?e=7e8b...
excel
Formulas and Functions
dscheikey's avatar
dscheikey
Bronze Contributor
Aug 19, 2022

HiRBoyerr,  

"I want the names of everyone who signed up for 25-Nov to show up in cells in Row 30."

=TRANSPOSE(FILTER(Table1[Name],ISNUMBER(BYROW(Table1[[Day(s)1]:[ Day(s)38]],LAMBDA(array,XMATCH(C30,array))))))

I did not understand what you wanted in addition.

Resources