I keep getting the spill error. I am looking for it to return every 3rd result from a row, not a column, starting at a specified point as "1" for counting cells to return the 3rd.
#SPILL error occurs when there is not enough space for the output array. Try clearing everything after the formula cell. You can also let me know the formula you're using.
Please check the formulas carefully, check if the formula cell has proper formatting, check the system date settings if the output is a date, extend the formula cell so that it can occupy the output contents. And for the FILTER function, it is only available on newer excel versions.
it is interesting that you propose different solutions, this gives good ideas
Thank you 😊
I keep getting the spill error. I am looking for it to return every 3rd result from a row, not a column, starting at a specified point as "1" for counting cells to return the 3rd.
#SPILL error occurs when there is not enough space for the output array. Try clearing everything after the formula cell. You can also let me know the formula you're using.
if formula is showing #### instead of data
same ### in offset formula
FILTER is not valid
Please check the formulas carefully, check if the formula cell has proper formatting, check the system date settings if the output is a date, extend the formula cell so that it can occupy the output contents. And for the FILTER function, it is only available on newer excel versions.
This formula is not working in Excel2010
Sorry😥 The FILTER Function is not available on older versions.
*Promo SM*
Ok.