Description: while specifying contiguous ranges works, documentation suggests that I should be able to use a discrete range, (e.g. MATCH((E4~J4~N4~R4~V4~Z4), MAX(E4~J4~N4~R4~V4~Z4),1) should work; in real life it is returning an Err:504 Steps to Reproduce: 1.create a discrete (e.g. non-contiguous) range, horizontal or vertical. 2. use a constant or a function with a non-sorted array specified Actual Results: Match fails with an Err:504 error Expected Results: expecting a numerical value (position of the matching constant) Match() performs as expected with the discrete cells copied to a contiguous range (both horizontal & vertical) but fails (h & V) if the range is not contiguous. Reproducible: Always User Profile Reset: No Additional Info: Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 22; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Please where it is suggested in documentation. I don't think MATCH's help will do it. https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3158407
I stand corrected. LibraOffice Calc does not specify that non-contiguous ranges are supported. This is my first use and it is supported in MS-Office / Excel https://support.microsoft.com/en-us/office/select-specific-cells-or-ranges-3a0c91c5-8a64-4cd2-8625-7f5b7f1eed87 It never occurred to me that non-contiguous ranges would NOT be supported.
Please attach an Excel file that works for you in Excel.