Forum Discussion
Help with Index Match formula
Hi there, I'm having trouble writing a formula, and wonder if anyone can point me in the right direction. I want to produce a unique list of Names based on a fixed date (Year End) falling bet...
Spill error means that the area needed to show all the resulting values, is not empty.
The formula cell (anchor) is always top left. Click on it and you will see a blue shimbering frame that shows the needed spill area.
If you have other things on that sheet, you could try to cut the formula cell and paste it on row one on a blank sheet.
Row one? If a formula results in a full column, it cannot show all the results, from another row than the top row.
You probably have data (not empty cells) in the needed spill area or you formula gives a much wider hit than you expect.
The two cinditions may be the reason for finding everything (a milion rows). Filter takes only one condition and by multiplying severeal conditions the result becomes 1 (true) if they all are true.
The formula cell (anchor) is always top left. Click on it and you will see a blue shimbering frame that shows the needed spill area.
If you have other things on that sheet, you could try to cut the formula cell and paste it on row one on a blank sheet.
Row one? If a formula results in a full column, it cannot show all the results, from another row than the top row.
You probably have data (not empty cells) in the needed spill area or you formula gives a much wider hit than you expect.
The two cinditions may be the reason for finding everything (a milion rows). Filter takes only one condition and by multiplying severeal conditions the result becomes 1 (true) if they all are true.