yogi_Pull From Sheet1 Only First Instance Of Records In Columns A to D

Google Spreadsheet   Post  #2058

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-08-2016

question by: arianne2013new:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/daoENIdAq9o;context-place=forum/docs
Unique Value

Can anyone help me to find a unique value for Reference Number.  I want to remove duplicates of the REference numbers

Here is the link

https://docs.google.com/spreadsheets/d/1faueLcS57aJEbOOj2q1goVp-2qzjSW1umK4YWO-EP0Y/edit?usp=sharing

------------------------------------------------------------------------------------------------------------------------------------------