| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding matching numbers in different rows.
I have a spreadsheet with a list of 20 numbers in each row. What I want to
do is find out if any numbers in the below row, match any numbers in the top row. Ex: 6,9,10,15,27... 1,3,5,6,10,14... Next to the 6 in the top row I want to add a column(cell) which tells me how many times 6 was repeated in the row below it. I have worked with a few different ideas but so far I have had no luck. Any help on this would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding matching numbers in different rows.
Assuming you have 6 in A1 and your numbers to search for 6 in A2:T2 then in
B1 enter =COUNTIF(A2:T2,A1) "classic3283" wrote: I have a spreadsheet with a list of 20 numbers in each row. What I want to do is find out if any numbers in the below row, match any numbers in the top row. Ex: 6,9,10,15,27... 1,3,5,6,10,14... Next to the 6 in the top row I want to add a column(cell) which tells me how many times 6 was repeated in the row below it. I have worked with a few different ideas but so far I have had no luck. Any help on this would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not finding matching value in vlookup | Excel Worksheet Functions | |||
| Finding matching values | Excel Worksheet Functions | |||
| Finding One Value, Matching Three Criteria | Excel Discussion (Misc queries) | |||
| finding matching cells in worksheets | Excel Worksheet Functions | |||
| finding the no. of rows in a COL filled with numbers, zeros and bl | Excel Worksheet Functions | |||
Linear Mode
