G
Guest
I am searching a talbe for dates that match a given month and ned to find the
row and column of the cells that match.
I have this array function...
=SMALL(IF(MONTH($C$5:$E$12)=$D$31,ROW($C$5:$E$12)),ROW(1:1))
It correctly returns all the rows whose dates match the right month
I have this array function...
=SMALL(IF(MONTH($C$5:$E$12)=$D$31,COLUMN($C$5:$E$12)),ROW(1:1))
It correctly returns all the columns whose dates match the right month
The problem is that the one returning the rows searches rows then columns to
report the data and the one returning the columns searches columns then rows
to report the data. Is there a way to force one of them to look the other
way?
Thank in advance for any help
Steve
row and column of the cells that match.
I have this array function...
=SMALL(IF(MONTH($C$5:$E$12)=$D$31,ROW($C$5:$E$12)),ROW(1:1))
It correctly returns all the rows whose dates match the right month
I have this array function...
=SMALL(IF(MONTH($C$5:$E$12)=$D$31,COLUMN($C$5:$E$12)),ROW(1:1))
It correctly returns all the columns whose dates match the right month
The problem is that the one returning the rows searches rows then columns to
report the data and the one returning the columns searches columns then rows
to report the data. Is there a way to force one of them to look the other
way?
Thank in advance for any help
Steve