Saturday, April 26, 2014

yogi_Add To yogi_signs Items From Inventory That Have Not Already Been Assigned

                                         Google Spreadsheet   Post  #1619
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Apr-26-2014
post by Jacob W. Kerr: (compare 2 columns of address to creat a list of missing address)
I am making a sheet that keeps track of properties that have real estate signs put out for them.
I have a pull from another sheet that has the master inventory that pulls all properties with a available status.
In this document I have a tab that has validated field of street address that are manually selected, a vlookup attached to that field to pull the info for the sign (rest of address, beds, bath, price)
I want a section at the top that would be a list of address that are in the pull (available properties) but not not already on the page. The user would see what new address need to added in the correct area of the document.

so basically I want to compare two columns, a master list and a smaller list and get a new column that has the items missing from the master list.



let me know if you need further explanation.