Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare lists in cells Excel
I have 1 column and 5 rows, each row contains a set of
numbers separated by commas. I want to compare the numbers in the rows, and if a number is repeated in another row, I want to increase my X value +1. So if row one contains 1,2,3 and row two contains 4,5,6 and row three contains 1,4,7 then X=2. And if row 4 contains 1,8,9 then X=3. The number of entries per cell will not be the same, so I can't just put each number in an individual cell, and I need Excel to realize that the comma is a delimiter and not a place holder. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Using certain data from lists in other cells in Excel. | Excel Worksheet Functions | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
changing the way Excel displays selected cells | Excel Discussion (Misc queries) | |||
Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions |