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...
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.
In B4 on each of the JANE, MARLA and JON sheets:
=FILTER(MAIN!B4:B1000, MAIN!E4:E1000=B1, "")
Where does the B1 towards the end of the formula correspond with? Thank you!
