logo
down
shadow

Google Sheets: How to Find the Least Popular/Common Value


Google Sheets: How to Find the Least Popular/Common Value

By : Russ A
Date : November 14 2020, 04:48 PM
hop of those help? I'm looking for help finding a function/formula to find the least common value in a col on Google Sheets. , Assuming the range you want to count is A2:A40, try:
code :
=unique(filter(A2:A40,countif(A2:A40, A2:A40)=MIN(countif(A2:A40,A2:A40))))


Share : facebook icon twitter icon
Find out which is most popular keyword from google?

Find out which is most popular keyword from google?


By : user3640350
Date : March 29 2020, 07:55 AM
google sheets or excel find most popular value

google sheets or excel find most popular value


By : Jiawei
Date : March 29 2020, 07:55 AM
google script, merge the data from different sheets based on common values in a common column

google script, merge the data from different sheets based on common values in a common column


By : Nickaya
Date : March 29 2020, 07:55 AM
wish helps you To be faster, you should avoid so much call on Range.getValue() method, cause it's cost a lot of ressource and time. Instead, make a big call in the beginning and work on your data from some arrays. Here is a possible solution:
code :
  function myFunction2(){

  // Get your spreadsheet and the sheets "TB" and "2"
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheetTB = ss.getSheetByName("TB");
  var sheet2 = ss.getSheetByName("2");

  // Get the range on sheet "TB"
  var tabTB = sheetTB.getRange(5, 3, sheetTB.getLastRow(), 8);

  // Get the values to compare
  var dataTB = tabTB.getValues();
  var data2 = sheet2.getRange(8, 21, sheet2.getLastRow(), 3).getValues();

  for(var i = 0; i < dataTB.length; i++){

    for(var j = 0; j < data2.length; j++){

      // Compare data: if they're the same, put the value 
      if(dataTB[i][0].localeCompare(data2[j][0]) == 0){

        dataTB[i][7] = data2[j][2];

      }

    }

  }

  // Take the modified tab and put it on the spreadsheet
  tabTB.setValues(dataTB);

}
Google Sheets script - find matching tuples and copy data between sheets

Google Sheets script - find matching tuples and copy data between sheets


By : Canoli
Date : March 29 2020, 07:55 AM
wish of those help The reason of error is the start number between array and range. The index of array starts from 0. The row and column of getRange() start from 1. So how about this modification?
From :
code :
sheet2.getRange(j, 6).setValue( sheet1.getRange( i, 4 ).getValue() )
sheet2.getRange(j+1, 7).setValue( sheet1.getRange( i+1, 5 ).getValue() )
Find the most common max value & 2nd from Max value from a number of sheets

Find the most common max value & 2nd from Max value from a number of sheets


By : Andy Alldis
Date : March 29 2020, 07:55 AM
wish help you to fix your issue
code :
=SORTN(QUERY({'Season 1'!A2:C6;'Season 2'!A2:C6;'Season 3'!A2:C6},"Select Col1,Col2,count(Col1) group by Col1,Col2 order by Col1,count(Col1) desc"),2^9,2,1,1)
shadow
Privacy Policy - Terms - Contact Us © ourworld-yourmove.org