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) Sample File    Note: this workbook was copied from the original which is linked to a Form via Power Automate  I've tried Vlookup and Inde...
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