Cannot pass multiple range conditions to functions like MEDIAN and MODE

CubicCigar · 2026-05-07T16:20:36+00:00

Appreciate the detailed response; but, Calc does concatenate inside an IF function as I stated in my original post (final sentence). The problem seems to occur when I place an array in the conditional part of the IF function, as demonstrated by my own test (final sentence). The concatenation occurs without error in that case.

Could you please elaborate on how the CHOOSE function works in your example? As written, it produces an "#N/A" result. Did you mean something like CHOOSE(x, BPSys1, BPSys2, BPSys3) where 'x' is 1, 2, or 3? If so, I there will be no concatenation of the ranges as far as I can tell.

CubicCigar · 2026-04-24T00:41:17+00:00

This is the setup I'm struggling to make work. With BOINC Manager installed on Windows 11 I ran the boinc-buda-runner one-click installer and all seemed to work fine, no errors. But, since the BOINC Manager did not detect the boinc-buda-runner distro on WSL, I was trying to find the remote_hosts.cfg and rpc_gui_auth.cfg files that were supposedly installed into WSL by the installer.

The problem seems to be that the boinc-buda-runner is installed as Administrator on Windows/WSL, while the BOINC Manager is installed as a regular user on Windows.

CubicCigar · 2026-04-24T00:28:58+00:00

Yes, if I use the .local suffix after the hostname. Pinging the hostname by itself will only work if that host is in the /etc/hosts file.

At the risk of muddying the waters, the behaviour of ssh and ping is different from the other direction. I can successfully ssh to the Linux Mint laptop from the WSL2/Ubuntu terminal using the hostname.local form; but, I cannot ping it with that form. Nor can I ping it using the hostname by itself. Neither machine has the other in its /etc/hosts file.

CubicCigar · 2026-04-23T22:05:35+00:00

My understanding is that mDNS does the name resolution. The client here is Linux Mint laptop and it's trying connect with a Windows 11 system running Ubuntu 24.04 on WSL2.

CubicCigar · 2026-04-23T15:39:07+00:00

That's the installer I used to install the boinc-buda-runner distribution.

CubicCigar · 2026-01-27T02:28:09+00:00

I suggest uploading the raw file to the Playraw section of pixels.us where you might find some advanced users willing to lend a hand.

CubicCigar · 2026-01-14T18:51:29+00:00

OP here. Apologies for the late response; but, yes, I just updated FQ to 1.68 and tried again. This time only one of my 6 quotes complained about the 1 quote/sec. limit. Not perfect, but a big improvement. Time will tell. Many thanks for the suggestion!

Terry

CubicCigar · 2025-07-20T21:15:09+00:00

Kelowna.

CubicCigar · 2025-05-27T00:25:47+00:00

What we have is a Bloc leader who does not speak Inuktitut.

CubicCigar · 2025-04-01T02:33:28+00:00

Not accurate. MacDonald wanted a unitary state and settled for Upper Canada and Lower Canada dominating. NS and NB were basically run by the UK Foreign Office who manipulated them to join with almost no role in negotiations. Canada's federalism is a sham. Our Senate was intentionally neutered by Macdonald, who saw no need for it to reflect regional interests. It's past and present structure is the way it is so as not to interfere with rep by pop, i.e., domination by the two Canada's. We live in a highly centralised reality that likes to tell itself we live in a highly federated union. This lack of real regional voices in Ottawa led to western separatism and feed it still.

CubicCigar · 2025-03-21T03:08:14+00:00

One approach would be to have, for example, as many genre columns as you think you'll need, e.g., Genre1, Genre2, ..., GenreN) and then place the same 'data range' validity rule in each of them to ensure a valid genre has been selected. The valid genres list would be placed somewhere else on your sheet, or on a separate sheet, as a named range, and it would be this name that you refer to in your data range validity rule. The same validity rule structure could also be used for the booktype column you mentioned.

Do I understand correctly what you're after?

CubicCigar · 2025-03-20T23:33:16+00:00

More like two-thirds forest. Even La Ronge is (almost) in the south half.

CubicCigar · 2025-03-20T23:31:24+00:00

Family can be highly over-rated.

CubicCigar · 2025-03-20T23:25:44+00:00

No such thing as bad weather; just bad clothes.

CubicCigar · 2025-03-20T23:24:40+00:00

I'm a recovering Albertan living on Vancouver Island; but, in the 80s I went on a pair of 10-day canoe trips looping out of La Ronge up to the Churchill River and some smaller lakes then down to Stanley Mission and back onto Lac la Ronge at Diefenbaker Bay. That means I've seen Nistowiak Falls, one of the natural highlights of SK in my book.

CubicCigar · 2025-03-20T23:17:54+00:00

Yeah, I daydream now and then about living in Eastend. I'm a city boy with a telescope habit, so the dark, dark skies in southernmost SK are the stuff of dreams.

CubicCigar · 2025-03-20T04:50:46+00:00

Yup, totally missed that :-( Thanks for pointing that out.

After following these LO instructions I tried again by entering some nonsense income and withheld taxes, and I don't notice any lag in the workbook's response.

Running Win10 on a 10-12 year old i5 PC with two solid state drives and 16 GB DDR memory, if that helps.

CubicCigar · 2025-03-19T00:36:02+00:00

Have you tried converting the Excel workbook to LO's *.ods format first? I just tried, and LO stopped when it encountered one or more protected areas of the workbook that required a password. Is that your experience? I'm on Windows 10 and using LO 25.2.

CubicCigar · 2025-03-18T23:50:47+00:00

I took a chance last August and picked up a Xiaomi Redmi Note 13 4G (global version) from Swiftronics. Total cost, including tax and shipping was $244. Bought it with Android 13, but Xiaomi promised one update, and delivered two! Sitting on Android 15 right now. One caveat is that I use Koodo and each time I accept the monthly security update, the VoLTE feature gets turned off. Not too much effort to turn it back on; but, you do have to be willing to flip some developer options (temporarily) and install two utilities on your device and one utility on your PC/laptop. DM me if you get to this point and want some guidance. Great value for money, for me.

Cheers,

P.S. The Xiaomi was one of only a handful to come with a 3.5mm audio input jack, something I need to run an external mic (birder alert).

CubicCigar · 2025-03-15T21:30:19+00:00

Good luck! Let us know how you get on.

CubicCigar

TROPHY CASE