Forum Discussion
Excel Formula Help
Hi everyone, i am needing help pulling data from one sheet to another. The "DATA" tab is a bunch of data that is pulled from a Microsoft forms survey and i copy and paste it in the sheet. Once i copy...
Try the following formula-
=LET(x,FILTER(OfficeForms.Table[[Module]:[Comments]],(OfficeForms.Table[District]=A1)*(OfficeForms.Table[Job Code]=C1)),
HSTACK(TOROW(TAKE(x,,6),3),TAKE(x,,-5)))
Hi Harun24HR, after inputting this into other cells on my actual spreadsheet, i was getting an error.
Thank you! That formula worked!
