G
Gotango
Hello,
I'm using Index Match functions to extract data from one table int
another, however how do I make sure the function skips blank cells an
only counts filled cells?
Some row headers have duplicates while column headers are unique
however only one of the cells intersecting each column header and eac
row header have data in it, and I would like the function to onl
capture data from the cell that is non empty. Essentially, on each ro
in the index array there is only one cell that is non-empty.
The function I am using is:
=INDEX(Sheet1!$A$1:$D$10,MATCH(Sheet2!A1,Sheet1!$A$1:$A$10,0),MATCH(Sheet2!B1,Sheet1!$A$1:$D$1,0))
Appreciate any help guys,
Thank
I'm using Index Match functions to extract data from one table int
another, however how do I make sure the function skips blank cells an
only counts filled cells?
Some row headers have duplicates while column headers are unique
however only one of the cells intersecting each column header and eac
row header have data in it, and I would like the function to onl
capture data from the cell that is non empty. Essentially, on each ro
in the index array there is only one cell that is non-empty.
The function I am using is:
=INDEX(Sheet1!$A$1:$D$10,MATCH(Sheet2!A1,Sheet1!$A$1:$A$10,0),MATCH(Sheet2!B1,Sheet1!$A$1:$D$1,0))
Appreciate any help guys,
Thank