Thread: Excel Function for select data which NOT exist from the list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wilchong via OfficeKB.com wilchong via OfficeKB.com is offline
external usenet poster
  
Posts: 90
Default 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

Reply With QuoteReply With Quote