Google Spreadsheet Post #1465
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-02-2014
post by Patric C(http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!category-topic/docs/spreadsheets/axej9go3HU0)
trying to use google spreadsheet to find names that appear in column A but not B.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-02-2014
post by Patric C(http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!category-topic/docs/spreadsheets/axej9go3HU0)
trying to use google spreadsheet to find names that appear in column A but not B.
I have a list of names in column A and a list of names in column B. Some of the names in A are the same as B. I am hoping to use google spreadsheet to find the names that appear in column A, but not column B.
Thanks,
Patrick
----------------------------------------------------------------------------------------------------------------------------------------------
please note that when the following formula
=filter(A2:A; isna(match(A2:A; B2:B; 0)))
that I have used in a solution posted in another thread did not work
further investigation indicated that names in your column B list have some extraneous (other than space) characters
No comments:
Post a Comment