Forum Discussion
Solved
EXCEL FORMULA HELP
I need help. I have attached the sheet I'm working on. I need to pull the data in column B (CLIENT) from the MAIN sheet to the respective individual sheet based on column E (PREPPER). For example, if the data in B4 says 'Jason Smith' and E4 says 'Jon'; I need it to go to the JON sheet in cell B4 but not show up on sheets JANE or MARLA. Help please!! Thank you! :)
B1 seems to be the cell that contains the Prepper's name (on the Prepper-specific worksheet). See the attached workbook for more information and more sample data. You can use the workbook for experimentation.
5 Replies
In B4 on each of the JANE, MARLA and JON sheets:
=FILTER(MAIN!B4:B1000, MAIN!E4:E1000=B1, "")
