Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting remaining entries
Well I have made certain entries in a column A, column B contains some of the entries of column A . And the entries in column B are randomly selected entries from column A. Now i want the remaining entries(which are not in column B) in column C. How would I do this? With regards Harvinder -- harvindersingh1 ------------------------------------------------------------------------ harvindersingh1's Profile: http://www.excelforum.com/member.php...o&userid=31725 View this thread: http://www.excelforum.com/showthread...hreadid=534933 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting remaining entries
See if this will work (in the C column). =IF(COUNTIF(B:B,A1)0,"",A1) -- stvgarner ------------------------------------------------------------------------ stvgarner's Profile: http://www.excelforum.com/member.php...o&userid=20599 View this thread: http://www.excelforum.com/showthread...hreadid=534933 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sum certain entries in a column by reference letters | Excel Discussion (Misc queries) | |||
Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
Merge, update, and add only new entries into a list from other she | Excel Worksheet Functions | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
Points remaining formula | Excel Worksheet Functions |