Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search criterias?
Hi
I need to perform a sort of look-up into a grid of information. I need to find how many times two adjoining cells met a criteria. For example, the grid has random numbers in a 10x10 grid, I need to now how many times "5" AND "9" (for example) appear adjacent to each other in a row. If they are not next to each other the result should come back as zero or false. I have tried the countif and Hlookup function, but does not account for them being adjacent. Please help....THANKS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search criterias?
Try this:
Assume the grid is in the range A1:J10 =SUMPRODUCT(--(A1:I10=5),--(B1:J10=9)) Biff "shnim1" wrote in message ... Hi I need to perform a sort of look-up into a grid of information. I need to find how many times two adjoining cells met a criteria. For example, the grid has random numbers in a 10x10 grid, I need to now how many times "5" AND "9" (for example) appear adjacent to each other in a row. If they are not next to each other the result should come back as zero or false. I have tried the countif and Hlookup function, but does not account for them being adjacent. Please help....THANKS -- shnim1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
build a search tool in excel | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |