Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
First two columns of data which will vary depending on other functions in
worksheet 8 9 5 5 7 5 5 7 4 4 5 0 2 5 1 5 0 4 0 0 I want to in a third column to list any occurences of values in column 2 that appear in column 1, including multiples, there will always be 16 rows of this data. I already have data sorted in accending order in first and second columns using Large function. Also would be helpful to blank any 0 value. Would be nice if empty values in third column are blank, but can deal with anything. Thank You in advance Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Total numbers in column where the row cell matches the search crit | Excel Worksheet Functions | |||
Count matches within two columns | Excel Discussion (Misc queries) | |||
Search for matches and then append data | Excel Discussion (Misc queries) | |||
How to search a worksheet for text-value matches? | Excel Worksheet Functions | |||
Counting matches from more columns | Excel Worksheet Functions |