256 Kilobytes

All Content > Google Sheets

Type All Category All Tag Google Sheets

Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

Last ReplyHere's a better version that removes the " results" string and then casts the result to a number instead of a string: =VALUE(substitute(importXML... August R. Garcia,

Here's a better version t...

Tue, 08 Oct 2019 09:17:50 -07009 months ago1
🗨 1
🐏 0
👁 390
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

The answer is to fucking kill yourself.<...

MoreThe answer is to fucking kill yourself.
🗨 0
🐏 0
👁 319
Profile Photo - August R. Garcia

[Video] 8 Things You Didn’t Know Were Keyword Research Tools

Articles in Search Engine Optimization | By August R. Garcia

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyAlso, most of the content that would be in a "real"/standard "top free SEO tools" guide is summarized here: Best Free Search Volume Tools Sea... August R. Garcia,

Also, most of the content...

Tue, 18 Jun 2019 10:19:30 -07001 year ago1
🗨 2
🐏 4
👁 781
Profile Photo - Some Guy

[Google Sheets] Dollar sign usage? What does it do?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Univa

Last ReplyThe $ is used in a cell reference to create an absolute reference. An absolute reference is one that will not change when the formula is copied. Th... Univa,

The $ is used in a cell r...

Fri, 31 May 2019 10:47:38 -07001 year ago1
🗨 2
🐏 0
👁 368
Profile Photo - August R. Garcia

Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets

Articles in Spreadsheets | By August R. Garcia

Published | Last Update 📌

Profile Photo - Hash Brown

Last ReplyAny opportunity to spit in the face of god is good by me. Excellent post homie.  Hash Brown,

Any opportunity to spit i...

Mon, 27 May 2019 07:59:54 -07001 year ago1
🗨 2
🐏 2
👁 2,395
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

What a nice trick.

MoreWhat a nice trick. How to Extract Emails from HTML with Google Sheets Code function get_raw_html(url) { // The code below logs the H...
🗨 0
🐏 0
👁 581
Profile Photo - Some Guy
Profile Photo - Univa

Last ReplyCreate sheets by clicking the "+" button at the bottom of your browser window. In Sheet1, type this formula into any cell in column A: =INDIRECT("... Univa,

Create sheets by clicking...

Thu, 16 May 2019 08:10:10 -07001 year ago1
🗨 1
🐏 0
👁 337
Profile Photo - Some Guy

How to split cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Univa

Last ReplyIn Google Sheets, paste your data into a column. You’ll see a little clipboard icon appear in the lower right-hand corner of your data. Click on... Univa,

In Google Sheets, paste y...

Tue, 16 Apr 2019 07:58:40 -07001 year ago1
🗨 1
🐏 0
👁 343
Profile Photo - August R. Garcia

[MatthewGraham] [Easy Trick] How to Scrape All Competitor URLs, Titles, Descriptions, and Meta KWs in 5 Minutes Max

Articles in Internet Marketing | By August R. Garcia

Published | Last Update

Profile Photo - August R. Garcia

Old/archive.

MoreStep 1: Find a Competitor's Sitemap Basically any site large enough to be worth scraping will have an XML sitemap. It should be located here...
🗨 0
🐏 0
👁 440
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

Old/archive.

MoreAfter reading the https://support.google.com/docs/table/25273?hl=en (which you should do), I came across a neat trick to spin anything you want effort...
🗨 0
🐏 0
👁 377
Profile Photo - Some Guy

How to copy formulas in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - KacssPL

Last ReplySelect the cell you would want to copy from the formula and select edit on the toolbar. Once selected navigate to copy and you can then paste the form... KacssPL,

Select the cell you would...

Sat, 30 Mar 2019 14:37:55 -07001 year ago1
🗨 1
🐏 0
👁 331
Profile Photo - Some Guy
Profile Photo - -alxl_

Last ReplyHaving these error messages come up can be frustrating to work with. Without seeing specifics/knowing more of the spreadsheet you deal with it can be... -alxl_,

Having these error messag...

Sat, 30 Mar 2019 13:46:47 -07001 year ago1
🗨 1
🐏 0
👁 753
Profile Photo - Some Guy

How to tab in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last ReplyI believe you mean another sheet, right? On the bottom of the screen, you will find a bar that houses your sheet on the left. Further left and, in fac... roxblade,

I believe you mean anothe...

Thu, 21 Mar 2019 01:07:37 -07001 year ago1
🗨 1
🐏 0
👁 302
Profile Photo - Some Guy

How to alphabetize content in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply > Open a spreadsheet in Google Docs.  > Select the group of cells that are to be sorted.  > Select Data and then > Sort... roxblade,

 > Open a spreads...

Wed, 27 Feb 2019 15:49:29 -08001 year ago1
🗨 1
🐏 0
👁 341
Profile Photo - Some Guy

[Google Sheets] Conditional formatting based on row value?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last ReplyHighlight the data range you want to conditionally format. Choose Format from the top menu > Select Conditional Formatting from the D... roxblade,

Wed, 27 Feb 2019 15:43:19 -08001 year ago1
🗨 1
🐏 0
👁 316
Profile Photo - Some Guy

How to merge cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Open the file. 3. Select the cells you want to merge. 4. Click on the merge option on the above toolbar. The merge... roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:42:16 -08001 year ago1
🗨 1
🐏 0
👁 323
Profile Photo - Some Guy

How to wrap text in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Select the cells to be wrapped. 2. On the Menu, click on Format. 3. On the Menu > Click on Text Wrapping > Select Wrap. 4. The proce... roxblade,

1. Select the cells to be...

Wed, 27 Feb 2019 15:41:49 -08001 year ago1
🗨 1
🐏 0
👁 359
Profile Photo - Some Guy

How to lock a row in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Go to the View Menu. 3. Point your mouse to Freeze Rows. 4. You will be able to see the Frozen Rows. roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:41:27 -08001 year ago1
🗨 1
🐏 0
👁 310
Profile Photo - Some Guy

How to make a drop down list in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply Open Google Sheets. Select the cells for creating the drop-down menu. Data > Data Validation. There will be an optio... roxblade,

 Open Google Sheets.

Wed, 27 Feb 2019 15:40:30 -08001 year ago1
🗨 1
🐏 0
👁 342
Profile Photo - Some Guy

How to sort in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Select the number of rows/columns / cells. Click on the top left corner to sort the entire sheet. 3. Click on Data &gt... roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:39:16 -08001 year ago1
🗨 1
🐏 0
👁 347
Profile Photo - Some Guy

How to add columns in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Spreadsheet in Google Sheets. 2. Select the number of rows or columns you want to add. ( Mac Command + click, Windows Ctrl + Click). 3.... roxblade,

1. Open Spreadsheet in Go...

Wed, 27 Feb 2019 15:37:52 -08001 year ago1
🗨 1
🐏 0
👁 328
Profile Photo - Some Guy

How to zoom out in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last Reply1. Open Google Sheets. 2. Click on 100% on the toolbar and you will see values from 50-200 appear. 3. Select 50/75 if you want to zoom out. roxblade,

1. Open Google Sheets.

Wed, 27 Feb 2019 15:35:43 -08001 year ago1
🗨 1
🐏 0
👁 306
Profile Photo - August R. Garcia

Custom Capitalization in Google Sheets -- Handle Acronyms, Industry Terms, Etc. in Titles

Articles in Spreadsheets | By August R. Garcia

Published | Last Update

Profile Photo - Some Guy

Last ReplyBonus note. If the value in F2 does not contain any question marks, add a question mark at the end; otherwise, get the unmodified string in F2:... Some Guy,

Bonus note. If the value...

Fri, 01 Feb 2019 23:46:51 -08001 year ago1
🗨 1
🐏 0
👁 444
Profile Photo - Some Guy

How to count non-blank cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last ReplyThe count function does the counting for you. Like =COUNT(A2:A11). But it also ignores hidden contents like "" (empty string) or a space. Th... roxblade,

The count function does t...

Thu, 24 Jan 2019 04:59:32 -08001 year ago1
🗨 1
🐏 0
👁 330
Profile Photo - Some Guy

[Google Sheets] Remove/find/highlight duplicates?

Answers in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - roxblade

Last ReplyFinding and highlighting is pretty much the same thing when it comes to handling duplicate cells. Removal has to be manual. Here's the simple proc... roxblade,

Finding and highlighting...

Thu, 24 Jan 2019 04:45:07 -08001 year ago1
🗨 1
🐏 0
👁 364
Profile Photo - Some Guy

How to freeze a row in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - roxblade

Last ReplyFreezing a row is easy on Google Sheets. You need to open the sheet in question, go to View, and then go to the option "Freeze rows" or &quo... roxblade,

Freezing a row is easy on...

Thu, 24 Jan 2019 04:41:25 -08001 year ago1
🗨 2
🐏 0
👁 332
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyFrom the Google Sheets documentation: To format an entire row based on the value of one of the cells in that row: On your computer, open a... August R. Garcia,

From the Google Sheets do...

Fri, 18 Jan 2019 23:12:06 -08001 year ago1
🗨 1
🐏 0
👁 350
Profile Photo - Some Guy

How to merge cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyYes this is very possible, not even hard if you know what you're doing. Highlight the cells you want to merge and then click this button. Hash Brown,

Yes this is very possible...

Tue, 15 Jan 2019 19:08:33 -08001 year ago1
🗨 1
🐏 0
👁 365
Profile Photo - Some Guy

Function comparable to PHP implode() in Google Sheets?

Answers in Server-Side | By Some Guy

Published

Profile Photo - Hash Brown

Last Reply#fuckTurks Hash Brown,

#fuckTurks

Mon, 14 Jan 2019 16:23:51 -08001 year ago1
🗨 3
🐏 0
👁 334
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreCan anyone tell me how I can combine a 2D range into one column with a formula in Google Sheets?
🗨 0
🐏 0
👁 226