Google-sheets – Query Function with Unique References

formulasgoogle sheetsgoogle-sheets-queryworksheet-function

I am currently using the QUERY function to move relative information to another sheet, which is then used for forecasting. Now what is currently happening is the same business names are showing up in the forecasting sheet. I have a correct QUERY function, to further this I would like to then remove duplicates from that function. How do I do this?

My current formula is:

=QUERY(Business!$A$2:$H$1000,"select A,C,D,G, H order by A desc limit 1000 ")

Best Answer

did you try =UNIQUE ?

=UNIQUE(QUERY(Business!$A$2:$H$1000,"select A, C, D, G, H order by A desc limit 1000 "))

Related Solutions

Google-sheets – Eliminate empty cells from a sort

Try:

=sort(filter(Leaderboard1!E5:F126, len(Leaderboard1!E5:E126)),1,True)

Google-sheets – Change a working function from onOpen() to onEdit()

Yes, if you want a script to be triggered by updates to spreadsheet A, then it should be bound to that spreadsheet. It can still access the other spreadsheets by their URL or Id. For example, this function copies the cells F2:H6 of the present sheet to the cells A1:C5 of another one.

function copyStuff() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sourceSheet = ss.getSheetByName('MasterSheet1')
  var ss2 = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/...');
  var targetSheet = ss2.getSheetByName('Sheet1');
  targetSheet.getRange("A1:C5").setValues(sourceSheet.getRange("F2:H6").getValues());
}

Best Answer

Related Solutions

Google-sheets – Eliminate empty cells from a sort

Google-sheets – Change a working function from onOpen() to onEdit()

Related Topic