Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulae needed
Hi
I have colmn A with 100 chassis numbers and Colmn B with 85 chassis numbers, Column B is 15 chassis numbers short of column A ( all column B hassis numbers are in column A as well ), is there a formulae I can use to extract these 15 chassis numbers from "A" |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulae needed
Graham,
In column C, use a formula like this (entered in C2) =ISERROR(MATCH(A2,B:B,FALSE)) and copy down, then sort or filter on column C and select the values in A where the value in C is TRUE. HTH, Bernie MS Excel MVP "Graham" wrote in message ... Hi I have colmn A with 100 chassis numbers and Colmn B with 85 chassis numbers, Column B is 15 chassis numbers short of column A ( all column B hassis numbers are in column A as well ), is there a formulae I can use to extract these 15 chassis numbers from "A" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
students grades, formulae to calculate what grade is needed based. | Excel Worksheet Functions | |||
Formulae | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |