New answers tagged

0 votes

'Large' 'If' Formula Help

I prefer to use a query and get all 3 results directly with: =ifna(query(A2:B,"select B where A = 1 order by B desc limit 3"))
  • 1,565
0 votes

'Large' 'If' Formula Help

Use FILTER to capture only the values in Column B that have an associated number in Column A. Use LARGE with the filtered data to get the 1st, 2nd and 3rd biggest numbers e.g.: This formula in cell ...
  • 4,868
0 votes

Google takeout doesn't include shared photo albums

It doesn't appear you can. But you can go to your shared album at and select 'download all' from the dot menu. This will allow you to backup that shared album.
  • 101
2 votes

Google Drive - how to open files in a new tab by default without having to preview in a modal window in the same tab first

Answer originally posted at Jan 2, 2021. Use Ctrl / ⌘ + Shift + Left Click (New Tab). I verified that this ...
0 votes

Unable to download large files from Google Drive

Mac and Windows user might try to use Google Drive for Desktop. Once it's installed, using Finder / Windows Explorer locate the file and set it to be available offline.
  • 42.3k
0 votes

In Google Drive, can I make a file read-only so that not even I can edit it?

The following seems to work reasonably well: from google.colab import drive drive.mount('/content/drive') from google.colab import auth auth.authenticate_user() import subprocess[&...

Top 50 recent answers are included