I can assist with your Excel formula. Just let me know what you need help with!

F5F Stay Refreshed Software Operating Systems I can assist with your Excel formula. Just let me know what you need help with!

Pages (2): Previous 1 2

Rafessor
Junior Member

03-03-2025, 12:50 PM

#11

=MODE.SNGL(IF(A1:A110<>0;A1:A110)) Press CTRL+SHIFT+ENTER to apply it. It should display the expected result. I’m not sure if the English function names are correct.

Rafessor

03-03-2025, 12:50 PM #11

=MODE.SNGL(IF(A1:A110<>0;A1:A110)) Press CTRL+SHIFT+ENTER to apply it. It should display the expected result. I’m not sure if the English function names are correct.

Maliwan99
Senior Member

346

03-03-2025, 09:38 PM

#12

Check if any values in A1:A17 are not zero

Maliwan99

03-03-2025, 09:38 PM #12

Check if any values in A1:A17 are not zero

Kyonae
Member

03-04-2025, 01:20 AM

#13

I'm still awake.

Kyonae

03-04-2025, 01:20 AM #13

I'm still awake.

ManicFG
Member

03-19-2025, 04:07 PM

#14

Only functions operate as arrays, so input the formula using CTRL + SHIFT ENTER.

ManicFG

03-19-2025, 04:07 PM #14

Only functions operate as arrays, so input the formula using CTRL + SHIFT ENTER.

SkogsMulle420
Junior Member

03-19-2025, 07:40 PM

#15

Did the operation succeed? Thanks a lot!

SkogsMulle420

03-19-2025, 07:40 PM #15

Did the operation succeed? Thanks a lot!

RoyalBubble
Junior Member

03-20-2025, 08:53 PM

#16

I realize

RoyalBubble

03-20-2025, 08:53 PM #16

I realize

Pages (2): Previous 1 2