質問する

# Paul451's profile - activity

 2019-10-16 11:09:20 +0200 バッジを受け取った ● 素晴らしい回答 (source) 2018-05-23 10:47:01 +0200 バッジを受け取った ● 卓越した質問 (source) 2018-03-10 19:08:31 +0200 バッジを受け取った ● 教師 (source) 2018-02-17 21:31:31 +0200 バッジを受け取った ● 人気の質問 (source) 2018-02-17 07:44:18 +0200 コメント付き質問 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 コメント付き回答 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 コメント付き回答 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 コメント付き回答 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 コメント付き回答 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 コメント付き回答 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 コメント付き回答 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 コメント付き質問 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 コメント付き回答 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 ベストアンサーマーク 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 バッジを受け取った ● 学者 (source) 2018-02-17 03:31:32 +0200 編集された回答 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 質問に回答する 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 コメント付き回答 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 編集された回答 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 バッジを受け取った ● 編集者 (source) 2018-02-16 11:54:14 +0200 質問に回答する 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 編集された質問 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 質問をする 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 バッジを受け取った ● 熱心な人 2017-07-29 10:25:01 +0200 バッジを受け取った ● サポーター (source) 2017-07-29 10:08:21 +0200 質問に回答する 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 質問に回答する 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 質問に回答する 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 質問に回答する 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 質問に回答する 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 バッジを受け取った ● 良い質問 (source) 2013-09-15 11:56:02 +0200 バッジを受け取った ● 有名な質問 (source) 2013-09-15 11:56:02 +0200 バッジを受け取った ● 卓越した質問 (source) 2013-09-15 11:54:20 +0200 バッジを受け取った ● ナイス質問 (source) 2013-04-17 20:20:53 +0200 バッジを受け取った ● 体系学者 2013-02-16 04:50:43 +0200 バッジを受け取った ● 生徒 (source) 2013-01-26 18:10:03 +0200 バッジを受け取った ● 人気の質問 (source) 2013-01-20 06:46:22 +0200 バッジを受け取った ● 有名な質問 (source) 2013-01-20 06:46:22 +0200 バッジを受け取った ● 卓越した質問 (source) 2012-06-07 03:42:50 +0200 バッジを受け取った ● 人気の質問 (source) 2012-04-09 06:28:02 +0200 質問をする 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 コメント付き回答 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 コメント付き回答 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?