Forum Discussion
Index/Match Array Issue
I am trying to figure out a formula for Index/Match to return the gross value for certain rows for each employee. The problem is the array for each employee can change depending on if they have or ha...
You shall instruct Excel somehow which rows are with names and which are with items. As variant add helper column and mark in it each row with name; or keep blank row before each name, etc. Any formal logic you can implement, based on it to select name block.