2018-05-23 10:47:01 +0200 received badge ● Notable Question (source) 2018-03-10 19:08:31 +0200 received badge ● Teacher (source) 2018-02-17 21:31:31 +0200 received badge ● Popular Question (source) 2018-02-17 07:44:18 +0200 commented question copy entire column automatically Since the question wasn't really answered. One way would be to manually enter a reference to Sheet1 cells in a row or tw 2018-02-17 07:18:15 +0200 commented answer How to find where in the interval a number is For eg. =VLOOKUP($F$2,$A$2:$C$10,3) To check the range, perhaps use MIN() and MAX() Ie, =IF(MAX($A$2:$A$10)<$F$ 2018-02-17 07:14:46 +0200 commented answer How to find where in the interval a number is For eg. =VLOOKUP($F$2,$A$2:$C$10,3) To check the range, perhaps use MIN() and MAX() Ie, =IF(MAX($A$2:$A$10)<$F$ 2018-02-17 07:08:22 +0200 commented answer How to find where in the interval a number is For eg. =VLOOKUP($F$2,$A$2:$C$10,3) To check the range, perhaps use MIN() and MAX() Ie, =IF(MAX($A$2:$A$10)<$F$2, 2018-02-17 07:07:17 +0200 commented answer How to find where in the interval a number is For eg. =VLOOKUP($F$2,$A$2:$C$10,3) To check the range, perhaps use MIN() and MAX() Ie, =IF(MAX($A$2:$A$10)<$F$2, 2018-02-17 07:06:58 +0200 commented answer How to find where in the interval a number is For eg. =VLOOKUP($F$2,$A$2:$C$10,3) To check the range, perhaps use MIN() and MAX() Ie, =IF(MAX($A$2:$A$10)<$F$2,"T 2018-02-17 07:06:39 +0200 commented answer How to find where in the interval a number is For eg. =VLOOKUP($F$2,$A$2:$C$10,3) To check the range, perhaps use MIN() and MAX() Ie, =IF(MAX($A$2:$A$10)<$F$2," 2018-02-17 05:49:36 +0200 commented question Writer: Convert text to columned table What is the format of the original file? (Or what is it being generated from?) 2018-02-17 04:43:21 +0200 commented answer Is there a way to enter numbers with suffixes? Lupp, like ve3oat, I hadn't interpreted the "units" as a variant of SI. I was thinking "M" for metres, for example. (I'v 2018-02-17 03:31:54 +0200 marked best answer INDIRECT() won't work for other sheets in one .xlsx file I have a particular file in which the INDIRECT() function gives a #REF! error whenever it is pointed to another sheet. For example: I have a sheet called "a", and on the current sheet (not "a") I enter =INDIRECT("a.a1") and I get a #REF! error. When I enter =a.a1 it returns the expected value. Likewise all other formula throughout the spreadsheet still work as expected when dealing with references to other sheets (eg, MATCH(), HLOOKUP(), etc). Only INDIRECT() fails. But when I create a new file, INDIRECT() works as expected. The spreadsheet is saved as an .xlsx, and moves back and forth between a Mac with MS-Excel and my own Win7 box with Libreoffice (v.5.3.7.2). Are there any known bugs that could cause a spreadsheet to develop such a weird quirk? If so, is there a fix? -- [I discovered this while trying to create a formula that worked with INDIRECT(). When it wouldn't work I stripped the components back to individual formula, and discovered the culprit. I thought I was going nuts. I literally created a sheet called "a" just to eliminate the possibility of typos.] 2018-02-17 03:31:54 +0200 received badge ● Scholar (source) 2018-02-17 03:31:32 +0200 edited answer INDIRECT() won't work for other sheets in one .xlsx file For future reference: The formula works (at least in Calc) if I change the syntax to... =INDIRECT("'Sheet1'!A1") Or, 2018-02-17 03:30:42 +0200 answered a question INDIRECT() won't work for other sheets in one .xlsx file For future reference: The formula works (at least in Calc) if I change the syntax to... =INDIRECT("'Sheet1'!A1") Or, 2018-02-17 03:28:09 +0200 commented answer INDIRECT() won't work for other sheets in one .xlsx file Calc A1. So dot-type. And as I said, it works in new files. ...But playing with that idea. It turns out it was the synt 2018-02-16 11:55:31 +0200 edited answer Is there a way to enter numbers with suffixes? If you only care that they are displayed with the units, but not entered as such, then you can define the cell format ty 2018-02-16 11:55:31 +0200 received badge ● Editor (source) 2018-02-16 11:54:14 +0200 answered a question Is there a way to enter numbers with suffixes? If you only care that they are displayed with the units, but not entered as such, then you can define the cell format ty 2018-02-16 11:37:06 +0200 edited question INDIRECT() won't work for other sheets in one .xlsx file INDIRECT() won't work for other sheets in one .xlsx file I have a particular file in which the INDIRECT() function gives 2018-02-16 11:35:20 +0200 asked a question INDIRECT() won't work for other sheets in one .xlsx file INDIRECT() won't work for other sheets in one .xlsx file I have a particular file in which the INDIRECT() function gives 2017-07-30 06:14:56 +0200 received badge ● Enthusiast 2017-07-29 10:25:01 +0200 received badge ● Supporter (source) 2017-07-29 10:08:21 +0200 answered a question Calc, Copy a certain value from one sheet to another If you just want a quick way to see which sets are complete, or which sets have tradable cards, you can just use an auto 2017-07-29 09:41:13 +0200 answered a question A way to prefent autofocusing on a cell in Calc? In general no. But if you only care about those two columns, you could freeze the first column. (Menu/View/Freeze Cells 2017-07-29 09:19:14 +0200 answered a question Text to Columns Problem That's normal behaviour. T2C only works on the current data, it isn't going to change any new data you enter. Question: 2017-07-29 09:13:00 +0200 answered a question Is it possible to add a number of rows to an offset? What's your current OFFSET() formula? Because "rows" is the second term. 2017-07-29 09:00:47 +0200 answered a question Not all of my grid lines show A quick and dirty "sanity check"... Press CRTL-A to highlight the entire sheet, then CRTL-M to remove formatting. If th 2015-07-06 12:30:51 +0200 received badge ● Good Question (source) 2013-09-15 11:56:02 +0200 received badge ● Famous Question (source) 2013-09-15 11:56:02 +0200 received badge ● Notable Question (source) 2013-09-15 11:54:20 +0200 received badge ● Nice Question (source) 2013-04-17 20:20:53 +0200 received badge ● Taxonomist 2013-02-16 04:50:43 +0200 received badge ● Student (source) 2013-01-26 18:10:03 +0200 received badge ● Popular Question (source) 2013-01-20 06:46:22 +0200 received badge ● Notable Question (source) 2013-01-20 06:46:22 +0200 received badge ● Famous Question (source) 2012-06-07 03:42:50 +0200 received badge ● Popular Question (source) 2012-04-09 06:28:02 +0200 asked a question Calc: How do you check an array of cells against a single value? A1="" returns TRUE.A2="" returns TRUE.A3="" returns TRUE.Even (A1="")*(A2="") and AND(A1="";A2="";A3="") return TRUE. But A1:A3="" returns a #VALUE error. How do you test all the cells in an array/range against a single value? I can't be the first person in spreadsheet history to want to check an array/range against another value? There must be some way to do it. 2012-04-09 06:13:25 +0200 commented answer Calc: Checking whether a range of cells are blank via a formula I can't be the first person in spreadsheet history to want to check all the cells in an array/range against a single value? There must be some way to do it. 2012-04-09 06:03:16 +0200 commented answer Calc: Checking whether a range of cells are blank via a formula Mariosv, you can't test a range against a conditional (like >= ). You can't use a range with ISBLANK(). So H21="" returns TRUE. H20="" returns TRUE. Even (H20="")*(H21="") returns TRUE. But H20:H21="" returns #VALUE error. How do you test a range/array against another value? 2012-04-01 05:46:19 +0200 commented answer Calc: Checking whether a range of cells are blank via a formula Doesn't work with the range/array in isblank. =IF(ISBLANK(H10);"True";"False") shows True. =IF(ISBlank(H11);"True";"False") also shows true. But =IF(ISBLANK(H10:H11);"True";"False") shows False.