Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help needed please.
I need a formula that can read vertically down the contents of a column of
data and list all of the results in another column. I do not want to list duplicate results, I only want the first instance listed once, then ignore any exact matches that have already been identified after that. EXAMPLE: Column A, Column B (column "B" would be the results of reading column "A") 1 1 3 3 87 87 3 60 60 5 3 4 5 9 87 60 4 9 1 5 5 5 1 4 9 9 1 The results in column "B" would be similar to the display you see when clicking the down arrow on a column of data when the sort is enabled. Can someone help me please. Thank you, David D. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help needed please.
Hi,
look into CPearson web http://www.cpearson.com/excel/ListFunctions.aspx "David D." wrote: I need a formula that can read vertically down the contents of a column of data and list all of the results in another column. I do not want to list duplicate results, I only want the first instance listed once, then ignore any exact matches that have already been identified after that. EXAMPLE: Column A, Column B (column "B" would be the results of reading column "A") 1 1 3 3 87 87 3 60 60 5 3 4 5 9 87 60 4 9 1 5 5 5 1 4 9 9 1 The results in column "B" would be similar to the display you see when clicking the down arrow on a column of data when the sort is enabled. Can someone help me please. Thank you, David D. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help needed please.
How about a technique and not a formula?
If that's ok... Visit Debra Dalgleish's site: http://contextures.com/xladvfilter02.html David D. wrote: I need a formula that can read vertically down the contents of a column of data and list all of the results in another column. I do not want to list duplicate results, I only want the first instance listed once, then ignore any exact matches that have already been identified after that. EXAMPLE: Column A, Column B (column "B" would be the results of reading column "A") 1 1 3 3 87 87 3 60 60 5 3 4 5 9 87 60 4 9 1 5 5 5 1 4 9 9 1 The results in column "B" would be similar to the display you see when clicking the down arrow on a column of data when the sort is enabled. Can someone help me please. Thank you, David D. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help needed please.
ps. Remember to add headers if you don't have them already.
David D. wrote: I need a formula that can read vertically down the contents of a column of data and list all of the results in another column. I do not want to list duplicate results, I only want the first instance listed once, then ignore any exact matches that have already been identified after that. EXAMPLE: Column A, Column B (column "B" would be the results of reading column "A") 1 1 3 3 87 87 3 60 60 5 3 4 5 9 87 60 4 9 1 5 5 5 1 4 9 9 1 The results in column "B" would be similar to the display you see when clicking the down arrow on a column of data when the sort is enabled. Can someone help me please. Thank you, David D. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function needed | Excel Worksheet Functions | |||
Help needed with a function - not sure which one? | Excel Discussion (Misc queries) | |||
Function Needed! Please Help! | Excel Worksheet Functions | |||
Function Help Needed | Excel Worksheet Functions | |||
Function needed please | Excel Worksheet Functions |