Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search row then column or column then row
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$1 2)),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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
How to search a column that is not the first of the table | Excel Worksheet Functions | |||
Column list search | Excel Worksheet Functions | |||
two column search | Excel Discussion (Misc queries) | |||
Search one column and return value from next column | Excel Discussion (Misc queries) |