Tag: worksheet-function

4 excel index match do not ignore 0's 2012-12-13T23:17:36.183

4 Solve systems of linear equations in Excel without using VBA 2012-12-15T04:08:03.930

4 sum of vlookup using array formula 2013-01-30T04:55:19.350

4 Excel Concatenate Time 2013-03-01T09:14:45.333

4 Excel - concatenating cells where reference number matches 2013-03-05T14:52:35.820

4 extract date from string in excel 2013-03-07T20:16:46.297

4 Robust way of creating formulas in Excel 2013-03-07T11:15:34.133

4 How is OFFSET supposed to work on filtered EXCEL data? 2013-03-19T12:19:27.057

4 SUMPRODUCT with condition 2013-05-27T12:15:11.187

4 Does excel have an arrow key shortcut to skip blank cells? 2013-05-28T02:16:47.430

4 Excel 2010, How do I write this formula? Data is on a different worksheet, same workbook 2013-06-19T15:57:53.733

4 Excel reference named range with text and formula 2013-08-25T14:03:06.023

4 Excel: searching for a maximum lower than X 2013-09-05T11:52:36.850

4 Linking Excel 2013 cell to Word 2013 table cell adds unwanted line breaks 2013-09-16T03:22:27.363

4 Combining two IF functions in one cell using Excel 2010 2013-09-16T10:31:21.257

4 Excel-MATCH function doesn't work on pasted values 2013-09-20T17:40:29.860

4 Excel saves a file in .csv but it keeps the columns and the rows as they were in the original sheet 2013-11-24T15:40:51.260

4 Conditional Formatting in excel based on another column 2014-01-01T12:34:44.153

4 Excel/Libreoffice returning TRUE for IF() instead of expression 2014-01-31T07:10:50.370

4 Cannot delete created excel table 2014-04-08T06:26:46.893

4 Excel Convert XML cell to columns 2014-04-22T15:03:13.377

4 Add/Subtract button Excel VBA 2014-05-23T13:08:05.903

4 Highlighting Cells in Excel based on the Value Associated with the Cell 2014-05-27T21:36:02.197

4 Auto formatting new pivot rows to data bars 2014-05-29T23:23:47.947

4 Replace cell references with values without F9 using macro 2014-07-03T14:58:11.707

4 Showing whether a list in Excel has a 1 or a 0 in it 2014-07-29T14:20:23.513

4 Subtracting TIME UNITS (not time of day) 2014-08-12T10:27:55.237

4 How do I get "yes" or "no" in Excel if the information comes from "true" and "false"? 2014-08-25T14:07:19.707

4 How to find the last value in a column in excel? 2014-09-26T12:34:10.077

4 How to convert data in Excel to percentages of total? 2014-10-20T13:00:03.143

4 How to automatically colour cell background with value selected from custom dropdown list in MS Excel 2010 2014-12-15T12:01:03.830

4 Formula bar view changes when document is saved and reopened 2015-02-04T20:48:53.630

4 MS Excel - Cumulative sum of a column based on "id values" in another column? 2015-04-15T09:51:02.950

4 Taking an indirect reference in Excel and making it a direct reference 2015-04-21T19:39:03.187

4 Apply Names in Excel is bugged? 2015-05-25T21:55:52.170

4 Getting a webpage title into Excel 2015-06-10T16:04:43.057

4 How to make a formula-based cell read-only in MS Excel? 2015-07-17T09:32:51.740

4 How can I parse a string from a cell multiple time in excel? 2015-08-06T14:39:54.347

4 Raise matrix to power without VBA 2015-08-07T13:36:39.573

4 INDEX + MATCH function returning wrong values 2015-08-21T19:48:05.370

4 Extract number from complex string if it falls in a given range 2015-08-23T15:55:38.650

4 How to interpolate intermediate values for arbitrary data in Excel 2015-10-11T00:32:43.310

4 Bizarre COUNTIF/COUNTA behavior in excel for counting text cells that are not "" 2015-11-16T17:11:24.450

4 Auto (drag)incrementing only one cell value in Excel 2015-12-13T09:41:59.207

4 What does the double dash ( - - ) do in Excel? 2016-01-12T21:52:32.197

4 Excel "And" and "Or" Command 2016-01-19T09:14:54.880

4 Generate Combinations in Excel 2016-02-04T14:25:36.120

4 Separate text string into separate columns in Excel 2016-02-19T18:08:27.663

4 How to Index-Match upwards from a specified cell until non-blank 2016-03-02T21:20:19.607

4 How to convert text with middle blank space to a number in Excel? 2016-05-10T06:14:37.903

4 Excel vlookup reference purposely missing shows #N/A - stop it 2016-05-21T18:41:39.683

4 Sort by Formula (without VBA) 2016-05-22T18:25:20.240

4 Excel- How do I find common text values from multiple (>2) rows? 2016-06-15T22:02:45.410

4 Hierarchical or recursive counting in excel (preferably within a pivot table)? 2016-09-03T18:15:33.010

4 Compare columns in two worksheets, list missing values on third worksheet 2017-03-07T00:28:01.460

4 Fill a formula down without dragging in Excel for Mac 2011 2017-04-06T18:46:26.370

4 Too many functions used in MS Excel? 2017-04-26T23:15:29.387

4 How can I combine VLOOKUP within an IF statement where the column index of the VLOOKUP function is a number extrapolated from a text? 2017-05-02T09:43:16.940

4 Excel format from mm/dd/yyyy to mm-dd-yyyy 2017-07-05T21:53:31.090

4 Working with Averages in Pivot Table (Calculated Field) 2017-07-24T16:58:27.617

4 YEARFRAC function in Excel 2017-10-16T12:26:35.670

4 How to use multiple array in one countif formula 2017-11-07T13:16:50.547

4 Issue with LOOKUP in excel 2017-11-17T11:28:10.650

4 Search the string of a formula 2017-11-24T09:12:56.243

4 In Excel, exactly why doesn't EOMONTH() (and others) not work in array formulae? 2018-01-27T22:09:45.743

4 Converting bar-codes to specific format using IF, FIND & MID function of excel 2018-05-23T04:08:44.697

4 Not sure how to shorten a formula 2018-05-31T12:19:31.987

4 Count non-empty cells that fulfill a criterion 2018-06-05T12:15:11.730

4 How do I extract a value from a time formatted value in excel? 2019-03-27T21:27:55.187

4 How to create (truly) blank cells from formula so that they get skipped in Ctrl+Arrow? 2019-08-14T13:50:39.890

4 Outlook Table Relative Cell Reference Error 2019-10-11T17:39:43.777

3 What is an excel formula that will return me the last row number of a cell within a range that contains specific data? 2009-11-01T16:46:15.497

3 How to set Function "formula" for whole column in Excel 2007? 2009-11-02T12:52:59.420

3 How can I change a cell's background color based on the cell's current value? 2010-03-31T21:22:13.263

3 How can I calculate the sum of all positive integers less than n? 2009-08-03T23:07:32.790

3 How to fill cell reference down column without changing cell reference 2010-04-15T17:28:51.493

3 Excel - Delete specific word in each row? 2010-07-13T18:09:32.557

3 How do I copy a worksheet without creating local copies of workbook-scoped named formulas? 2010-07-26T13:57:09.160

3 Averages spread out over several fields in Excel? 2010-08-12T23:42:39.460

3 Cross Referencing Data between Excel Sheets, plus a conditional statement 2010-09-05T15:57:40.043

3 Is there a way to tell which cells reference a selected cell in Excel? 2010-12-06T19:56:46.990

3 How do I stop Excel from adding double quotes to my formula? 2010-12-29T13:49:36.513

3 In Excel, doing a "Freeze Panes" on the right-most column instead of the left-most? 2011-01-26T15:04:26.163

3 Displaying a value only if another cell has a value in Excel 2011-02-01T20:32:42.927

3 How to make a relative formula in a Microsoft Word table? 2011-02-15T15:29:48.393

3 Absolute reference all cell references in a Microsoft Excel formula? 2011-02-23T16:39:25.593

3 Excel Range with IF 2011-03-11T16:48:35.200

3 Numbering grouped data in Excel 2011-03-15T21:04:03.100

3 Random Excel bug when referencing a different sheet 2011-05-06T12:50:13.973

3 How to add time duration column total from Skype Call History CSV file in Excel 2010? 2011-05-10T21:46:03.713

3 Convert time to decimal equivalent it Excel / Emacs 2011-06-23T16:34:42.513

3 How does one find the definition of a function in Excel 2010? 2011-06-27T18:42:20.907

3 Get adjacent column value in OpenOffice.org Calc 2011-07-03T03:15:05.090

3 How to count number of repeat occurrences 2011-07-07T20:53:12.157

3 How to make many column formulas ignore the same lines in Excel? 2011-07-28T14:04:48.343

3 Convert "Mon Aug 01 09:08:25 CDT 2011" to a usable date/time using Excel 2011-08-03T14:42:32.257

3 Sum up totals if name is Persons Name 2011-08-05T14:53:53.057

3 Split a string in a cell in Excel using numbers as the divider 2011-08-08T20:02:38.167

3 How do I make a random selection in a spreadsheet using more than one criteria 2011-08-15T15:26:31.630