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

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

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

Pages (2): 1 2 Next
S
sydneyyyyyy
Senior Member
396
02-21-2025, 05:16 PM
#1
Hello, I need to find the most frequent value in your dataset while ignoring zeros. The default mode is "0", but you want it to skip those. For your example, the correct result should be 2 since it appears more often than 0.
S
sydneyyyyyy
02-21-2025, 05:16 PM #1

Hello, I need to find the most frequent value in your dataset while ignoring zeros. The default mode is "0", but you want it to skip those. For your example, the correct result should be 2 since it appears more often than 0.

I
Infinity_PvPs
Member
205
03-01-2025, 04:29 AM
#2
5
I
Infinity_PvPs
03-01-2025, 04:29 AM #2

5

J
Julientigres59
Junior Member
12
03-01-2025, 12:56 PM
#3
Uncertain about providing a response or causing trouble, as I lack relevant knowledge in this case.
J
Julientigres59
03-01-2025, 12:56 PM #3

Uncertain about providing a response or causing trouble, as I lack relevant knowledge in this case.

S
Shocolag
Junior Member
11
03-02-2025, 11:16 AM
#4
I previously attempted that method and it failed. I also tried "Schnitzel", "1058" and "17". Now I'm testing "Egypt", though I'm unsure if it will work.
S
Shocolag
03-02-2025, 11:16 AM #4

I previously attempted that method and it failed. I also tried "Schnitzel", "1058" and "17". Now I'm testing "Egypt", though I'm unsure if it will work.

D
DantehIsGay
Posting Freak
902
03-02-2025, 12:53 PM
#5
It seems you're asking about avoiding posting something and referencing AVERAGEIF(). Clarify your intent so I can assist properly.
D
DantehIsGay
03-02-2025, 12:53 PM #5

It seems you're asking about avoiding posting something and referencing AVERAGEIF(). Clarify your intent so I can assist properly.

O
opticgunship
Posting Freak
815
03-02-2025, 05:40 PM
#6
Could you clarify what you mean by "D functions"? I'm here to help with whatever you need.
O
opticgunship
03-02-2025, 05:40 PM #6

Could you clarify what you mean by "D functions"? I'm here to help with whatever you need.

L
lillboman91
Member
164
03-03-2025, 12:20 AM
#7
Filter rows where values in column A are not equal to zero
L
lillboman91
03-03-2025, 12:20 AM #7

Filter rows where values in column A are not equal to zero

M
Meteor__YT
Member
81
03-03-2025, 03:00 AM
#8
Perhaps it's a bit of bait. I'm going with 'Car'—it tends to get results.
M
Meteor__YT
03-03-2025, 03:00 AM #8

Perhaps it's a bit of bait. I'm going with 'Car'—it tends to get results.

S
SlimeySkills
Member
52
03-03-2025, 04:19 AM
#9
I'm handling the average calculation for the array already, and I also require a modus.
S
SlimeySkills
03-03-2025, 04:19 AM #9

I'm handling the average calculation for the array already, and I also require a modus.

S
Some_Dunkus
Member
190
03-03-2025, 06:13 AM
#10
It seems you're confused about the current setting. Let me clarify what's happening.
S
Some_Dunkus
03-03-2025, 06:13 AM #10

It seems you're confused about the current setting. Let me clarify what's happening.

Pages (2): 1 2 Next