Ask Your Question

Find Array Function Issue [Bug]

asked 2020-04-17 07:07:46 +0200

flywire gravatar image

updated 2020-08-05 11:25:46 +0200

Alex Kemp gravatar image

The wizard result is not given in the cell:

=FIND({"A";"B";"C"},"SAMPLE TEXT")

Getting #NAME? expecting {2;#VALUE!;#VALUE!}

image description

Then click OK

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-04-17 08:14:43 +0200

This is not a function issue, this is function wizard issue. Entering the formula in formula bar, and using Shift+Ctrl+Enter to complete it, makes it work as expected. You are welcome to file a bug report.

edit flag offensive delete link more



Could someone confirm that bug?

flywire gravatar imageflywire ( 2020-05-02 05:55:42 +0200 )edit

Fixed for 6.4.5

erAck gravatar imageerAck ( 2020-05-13 13:15:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-17 07:07:46 +0200

Seen: 82 times

Last updated: Apr 18 '20