Tag: google-spreadsheets

77 How to create a formula for every row in a column in Google SpreadSheet? 2011-03-21T21:03:19.213

36 Pad numbers to specific length in Google Spreadsheet 2014-09-18T13:11:25.127

32 How to convert a duration into a number of hours in Google Spreadsheets? 2016-02-06T03:39:24.553

14 How to Label / Tag Items in a Spreadsheet 2012-03-27T09:23:13.277

13 How do I append a character to the end of every line in an Excel cell? 2019-02-26T22:02:56.433

12 Can you convert an address to a zip code in a spreadsheet? 2010-01-06T15:36:55.863

12 Date based sum in Excel / Google Docs spreadsheets 2008-08-29T05:57:00.343

8 Extracting email from text string in excel/google spreadsheet 2015-07-28T11:29:49.240

7 Spreadsheet (Excel, Google Docs etc), extracting value separated by comma 2017-05-16T17:42:11.060

6 Does any spreadsheet allow you to create your own functions? 2012-08-30T17:49:50.657

6 Equivalent for FILTER() formula in Libre Office 2014-09-04T14:52:01.637

6 how to highlight the cell with the max value 2015-05-20T19:54:52.317

6 How to auto-fill a numbered series WITHOUT a mouse (keyboard only) on Google Sheets 2017-08-25T17:17:59.260

5 How to "Round half to Even"? 2016-05-26T09:03:33.980

5 Determine United Airlines status level using worksheet functions 2016-11-25T18:00:52.550

4 How to freeze more than 5 column in google spreadsheet? 2009-12-29T05:35:33.487

4 How do I calculate the sum of 2 columns, using the max from each row? 2012-01-01T17:00:27.857

4 How to chart time of day in Google Spreadsheet with midnight crossover? 2014-05-17T19:11:31.067

4 "Array result was not expanded because it would overwrite data" 2014-07-01T06:40:14.610

4 Remove line breaks within cells in a range (\n) by Google Apps Script 2014-09-18T23:19:43.853

4 "Trying to connect" error in Google Docs on Safari 2015-01-23T23:56:42.360

3 How to open google spreadsheet's extra sheets in new window or tab? 2009-12-10T12:19:45.930

3 HTML tags in Google Spreadsheet 2013-03-12T15:10:48.613

3 In a spreadsheet, is it possible to separate rows into groups that will not change order when filtered? 2013-08-30T14:31:52.957

3 Histogram of dates in Google Sheets or OpenOffice 2015-05-12T17:27:37.257

3 How to create a data series for exponential decrease diagram 2015-07-14T09:50:05.673

3 Shortcut keys in Google Sheet don't work? 2015-09-11T08:50:35.790

3 How to convert to insert mode when editing formulas on Google Spreadsheets? 2015-11-12T22:43:23.763

3 COUNT all "P" from a row 2016-02-01T12:02:54.973

3 Calculate Median based on counts of value 2017-08-14T07:57:45.893

3 How to open .gdocs and .gsheets from browser, when no Google client installed? 2017-10-30T16:15:39.493

3 Smooth Scrolling in Google Sheets 2019-05-09T16:47:43.157

3 I want to count IF both condition are true Logically count by AND excel 2019-10-31T07:21:06.060

2 Google Spreadsheets: Counting number of matches between two rows 2009-08-06T16:55:25.263

2 In Google Docs, how to create a form that can store the data entered into it in an excel sheet automatically? 2009-09-26T17:22:46.580

2 In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells? 2009-12-17T14:44:31.287

2 Count substring occurrences within a cell 2010-07-24T03:26:18.890

2 What Excel formats are (most) compatible with LibreOffice and Google Docs? 2012-09-21T19:27:46.303

2 Merging CSVs with some common columns (though columns are in different places)? 2013-02-13T23:18:21.757

2 Generate an alphabetic index from a spreadsheet 2013-04-25T17:26:52.650

2 Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets 2013-08-12T20:07:25.980

2 How to look a value and sum it into a certain cell 2013-09-23T02:37:57.297

2 Major FIREFOX Redirect Error Problem (Error Code 11156) 2014-09-07T10:39:10.740

2 Auto-fill rows from columns in another sheet? 2014-09-14T18:58:56.007

2 Count the number of rows with equal values in two specified columns 2014-11-28T11:02:49.243

2 How do I copy rows based on single cell value in Google Sheets? 2014-12-16T11:21:49.743

2 Select all cells in a row 2015-03-02T01:48:13.920

2 Excel autonumber range 2015-07-16T09:57:50.707

2 AVERAGEIFS values that are not NA 2016-05-03T22:40:04.963

2 Google Sheets to Excel 2016-07-08T22:30:41.083

2 Insert horizontal axis values in line chart 2016-07-26T08:48:12.763

2 Combine multiple email addresses (in separate cells) into one cell (separated by comma) Google Sheets or Excel 2016-07-27T01:55:55.537

2 Excel : VLOOKUP returns the last value in the column 2016-07-29T18:58:24.667

2 How can I associate the .csv file extension with Google Sheets? 2017-03-08T15:57:12.057

2 How to add IFERROR to long formula in google sheets 2017-06-08T15:07:12.280

2 Tracking the longest streak of 100+ points in a column? 2017-06-12T06:16:57.580

2 Enter the no.s from two columns and the numbers in between to a 3rd column 2017-06-22T15:10:51.817

2 Highlight the cell if greater than value in the next column 2017-07-05T03:50:28.123

2 Is there an Excel function that works the same as filter() from Google Sheets? 2018-01-17T17:15:42.167

2 How to calculate the difference in months between now and beginning of a loan in Excel 2018-01-26T19:21:01.040

2 Q: Conditional formatting to highlight the maximum value in each row 2019-09-23T01:11:42.977

2 I want to make new column with Logic? 2019-11-08T09:44:36.063

2 Chromebook - Sort and Filter in Google Sheets while Offline 2019-12-30T00:20:55.693

1 How to visualize historical data 2010-12-14T18:35:05.270

1 Advanced spreadsheet auto-formatting 2011-08-19T21:18:26.400

1 Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath? 2012-04-13T04:37:50.743

1 Pull row of data from one place in spreadsheet to another 2012-07-05T18:59:33.167

1 Can I add rows to a Google Drive spreadhseet from a local text file? 2012-08-29T11:13:10.433

1 Google docs, speadsheet, how to make one column to the sum of others 2013-01-14T10:24:33.263

1 Google Spreadsheet. Retrieve only one cell from ImportData-result 2013-10-11T14:24:17.620

1 How focus on the document after find? 2013-12-21T07:00:28.750

1 Insert text to the beginning of every Cell in a Column 2014-07-07T12:54:05.620

1 How to xml to xml parse 2014-09-04T06:27:15.200

1 Convert duration text to duration value 2014-09-19T07:42:12.843

1 Is there a tool to put a phone number into E.164 format? 2015-02-22T19:46:47.553

1 Copy every nth column on a specific row from one sheet to another (in Google Sheets) 2015-05-18T18:14:44.057

1 How to make a formula to calculate how many of each unique item are in a column in the last 365 days 2015-05-19T12:29:43.813

1 Count number of cells that match certain criteria with formulae 2015-07-01T16:34:29.463

1 Creating a table similar to pivot table 2015-08-25T00:24:18.420

1 How to simplify Excel/Google Sheets formula with redundant method calls? 2015-10-19T20:43:02.893

1 Google Sheets - How to find penultimate (second-last) non-empty cell in a column? 2015-11-06T15:43:16.540

1 Populate Spreadsheet with files within a folder 2016-01-28T04:09:46.237

1 Excel If cell is blank show nothing else carry out this IF statement 2016-02-18T09:48:01.867

1 Extracting data from an excel sheet into another excel sheet 2016-03-02T01:24:25.727

1 Generate Contacts CSV from SpreadSheet 2016-04-14T20:13:05.340

1 Google Sheets - Conditional Formatting based on column heading of cell value 2016-06-17T04:27:28.140

1 Excel: How do you add a number to each cell in a range then multiply them together? 2016-11-18T14:25:26.387

1 I need a formula in Google Sheets that does the following 2016-12-06T00:17:41.573

1 How to create a graph with two Y axis with different values in Excel 2017-05-18T15:06:55.273

1 Use series number as X axis label in Google Spreadsheet 2017-07-19T11:44:01.300

1 How to parse JSON array data from GMail to Google Spreadsheet? 2017-10-02T12:26:28.883

1 Formula Needed: How to calculate Time Escaped 2017-11-03T20:18:32.957

1 Output matched value based on range 2017-11-26T13:38:15.317

1 Automatically import data into excel from Google sheets 2018-01-26T18:26:27.763

1 Add a value to a cell based on the criteria set in 2 text-based cells? 2018-03-16T07:31:54.890

1 how to save time with multiple COUNTIFS possibilities? 2018-05-13T17:36:25.397

1 How to add a cell range, then divide the sum by 1 cell. 2018-05-24T15:55:36.923

1 Conditional Formatting using average function in Google Sheets/Excel 2018-05-31T11:34:46.503

1 How to count all the items in 2 columns depending on comparison? 2018-07-20T14:58:03.657