質問する

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?