When using VLookup in Google Sheets, it is possible to search a specific column?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:35 -0800

Last ReplyHere's an example that I used recently:=if(I2="-", "NULL", VLOOKUP(I2, {E$2:E41,B$2:B41}, 2,0))In Google Sheets, curly braces... August R. Garcia,

Here's an example th...

How to access conditional formatting in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:30 -0800

Last Reply1. Highlight the cells that you want to format2. Right Click --> Conditional Formatting August R. Garcia,

1. Highlight the cells th...

Converting URLs to domains and vice-versa?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:26 -0800 | Last Update 3 years agoSun, 02 Dec 2018 13:03:41 -0800

Last ReplySolutions Using Google Sheets Extract domain from subdomain Example input: howtogoaround.wordpress.com =RIGHT(REGEXEXTRACT(D25, "\..*... August R. Garcia,

Solutions Using Google Sh...

What is the easiest way to generate random passwords in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:10 -0800

Last ReplyHave also run into this issue over the last few years. You'd think there'd be an easy way to do this. Messed around with a few options below... August R. Garcia,

Have also run into this i...

[Google Sheets] How to get the first element of an array?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:05 -0800

Last Reply// Get first element of an array=INDEX(SPLIT(B2, " | ", FALSE);1;1) August R. Garcia,

// Get first element of a...

What do curly braces do in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:00 -0800

Last ReplyCurly braces are used to combine ranges into arrays. [] August R. Garcia,

Curly braces are used to...

How can I monitor my GPU usage on Ubuntu?

Answers in Scripting and Automation | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:57 -0800

Last ReplyIf there is no usable/relevant GUI, this can also be done from the terminal with a looping BASH script like this: # Monitor GPU stats and usage... August R. Garcia,

If there is no usable/rel...

I am new to Google Sheets. What functions should I know about?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:44 -0800

Last ReplyHere are examples of a few very commonly used formulas:Replace substrings in spreadsheets: =SUBSTITUTE("Today is Monday", "Monday"... August R. Garcia,

Here are examples of a fe...

[Google Sheets] How to convert the string "1k" to the number 1,000?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:39 -0800

Last ReplyTry this function:#Change 1.3k to 1300, etc.=((VALUE(substitute(A1, "k", "")))*1000)=((VALUE(substitute(I201, "k", &quot... August R. Garcia,

Try this function:#Change...

[Google Sheets] Convert cell contents to (basic) HTML?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:38 -0800

Last ReplyThis seems to work:// 1. Wrap entire cell in a <p> tag, then use REGEXREPLACE to address newlines// 2. Replace newlines with the end of the prev... August R. Garcia,

This seems to work:// 1....

Is there a good way to split/divide cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:35 -0800

Last ReplyThere is a built-in split function here:https://support.google.com/docs/answer/3094136?hl=enFor your use case, this function should work:=SPLIT(A1, &q... August R. Garcia,

There is a built-in split...

How can I find the array element most similar to a string in a JavaScript array?

Answers in Scripting and Automation | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:25 -0800

Last ReplyOne potential approach is to use Levenshtein Distance. August R. Garcia,

One potential approach is...

Renaming files from BASH?

Answers in Scripting and Automation | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:23 -0800

Last Reply# Convert clocks subfolders from png to jpgconvert */*.png */*.jpgfor f in $(find */*.png); do echo $f to $f--.jpg convert $f $RANDOM-RANDOM-.jpg r... August R. Garcia,

# Convert clocks subfolde...

[Google Sheets] Does anyone know how to get a random number rounded to a certain interval?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:19 -0800

Last ReplyTo get a random number in a range of 2k to 3k rounded to the nearest interval of 100: =round(randbetween(2000, 3000)*0.01)*100 August R. Garcia,

To get a random number in...

In Google Sheets, can you set up conditional formatting based on the value of another cell?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:44:33 -0800

Specifically, is it possible to highligh...

[Google Sheets] What are pivot tables?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:43:17 -0800

[Google Sheets] SUMIF cell is an even number?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:55 -0800 | Last Update 3 years agoSun, 02 Dec 2018 12:36:00 -0800

How to get a random character (alphanumeric plus basic symbols) in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:51 -0800 | Last Update 3 years agoMon, 03 Dec 2018 06:47:58 -0800

Can you escape a cell's content in Google Sheets to sanitize data for an SQL query?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:34 -0800

[Code] Script Editor function to create an insert statement from Google Sheets data?

Answers in Spreadsheets | By Some Guy

Published 3 years agoSun, 02 Dec 2018 03:42:22 -0800