Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Function for select data which NOT exist from the list
There are 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: A, B, C, D, E, F, G, H, I, J, K and L In B3 down is: B, A, H, C, F, I, K, J, H, C and J. The result which I want is to list or select the data which is NOT exist in the second set of data (Col B) when compare to the first set of data. In my example, the result is D, E, G, and L actomactic appear in cell C3, C4, C5 and C6 accordingly. I need an Excel formula to have this result! Many thanks, Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200804/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
Function to select random values from a list. | Excel Worksheet Functions | |||
how do you select these data from a list? | Excel Discussion (Misc queries) | |||
What function to select the last 3 small values from a list ? | Excel Discussion (Misc queries) | |||
What function to select the last 3 small values from a list ? | Excel Worksheet Functions |