DashboardNovice
Member
1. The formulas I'm trying to work on are in yellow. All I want to do is replace the 2nd argument of the FIND( ) with a structured reference in column S, so that S7 is always referenced, then the part after the ":" will automatically expand to the current row, like what you would do if you were calculating a running total.
2. I don't understand why I'm getting a #SPILL error.
3. Why does the formula copy down to F15:F22?
In short, for any given row in column F, I'm trying to do this:
Look to the corresponding value in column S and reference the parent project code (which is already extracted in column E), then use FIND( ) to check if the parent charge code appears anywhere in column S in the cells above.
For example, in cell F11, use FIND( ) to check if the value in E11 appears anywhere in S7:S10.
I'm new to the SPILL feature and while I thought I understood it earlier today, I feel like I'm starting all over now.
2. I don't understand why I'm getting a #SPILL error.
3. Why does the formula copy down to F15:F22?
In short, for any given row in column F, I'm trying to do this:
Look to the corresponding value in column S and reference the parent project code (which is already extracted in column E), then use FIND( ) to check if the parent charge code appears anywhere in column S in the cells above.
For example, in cell F11, use FIND( ) to check if the value in E11 appears anywhere in S7:S10.
I'm new to the SPILL feature and while I thought I understood it earlier today, I feel like I'm starting all over now.
Attachments
Last edited: