MODE FORMULA FOR MULTIPLE CONDITIONS??

[michellesssme]

Based on the Data column,
May I know the formula for both conditions (1. & 2.) by using MODE & IF Formula?
1. mode value for condition <650
2. mode value for condition >=650

3. May I know how to insert condition (<650) in the formula (=TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")?
4. How to write the formula to count how many data points fall on the specific range like from 600 to 700?

Data
666
702
741
678
673
707
737
729
797
731
799
729
710
655
608
628
658
643
646
666
628
636
641
677
626
646

 

[michellesssme]

I'm not sure what you want to do. Do you want a formula to return the value in the [No] column if the value in the [readings] column is less than 2? What do you want to see if multiple values in the [readings] column are less than 2? A formula will return the results automatically, so no further user interaction would be necessary. What does Ki

Kindly ignore the question above.
I have another question about the formula in power query .
May I know is there any mistake for the formula in power query?
because it appeared error for the Month>= December

 

[KRice]

I have no context for your question. If your [Month] field contains text names for the months, then you'll need quotation marks around December.

 

[michellesssme]

I have no context for your question. If your [Month] field contains text names for the months, then you'll need quotation marks around December.

But the outcome included the data below 2021 Dec (2021 May, June, Sept)

 

[michellesssme]

I have no context for your question. If your [Month] field contains text names for the months, then you'll need quotation marks around December.

I have second question above this situation in the diagram below
May I know what formula can fulfill the nine combination of A & B ? and the yellow cell will occur correct overall status based on the combination A&B.

 

[KRice]

Your questions are really off topic...the last several have had nothing to do with "mode" or multiple conditions. You should probably begin a new thread with a more appropriate title since it appears you are trying to build out a worksheet with other features that are not related to the original purpose behind this thread.

To answer your question about the combinations...I believe earlier you mentioned that you were using Excel 2019 (if so, you should change your account profile so that can be easily seen). This matters because later versions of Excel have functionality to make this easier. In Excel 2019, I would use some helper columns to construct a two-column table whose columns are populated with different sequences of base 3 values...and then map "P", "F", and "-" to 0,1, and 2 in the helper table...as shown below. You'll need to enter the helper formula with Ctrl-Shift-Enter to ensure that it is treated as an array formula (you should see curly brackets surround the formula in the formula bar).

I'm not sure what rule you are applying to produce the "Overall Status" results. I've taken a guess in the mini-sheet below. I don't know what rule should be applied for the yellow cell...are you counting P's, looking for a total count of P's and F's only, or something else? Better explanations are needed.

MrExcel_20220803.xlsx
	A	B	C	D	E	F	G	H
1	A	B	Overall Status
2	P	P	P		Overall		0	0
3	F	P	F				1	0
4	-	P	P				2	0
5	P	F	F				0	1
6	F	F	F				1	1
7	-	F	F				2	1
8	P	-	P				0	2
9	F	-	F				1	2
10	-	-	-				2	2
Sheet10

Cell Formulas
Range	Formula
A2:B10	A2	=CHOOSE(G2+1,"P","F","-")
C2:C10	C2	=IF(COUNTIF(A2:B2,"-")=2,"-",IF(AND(COUNTIF(A2:B2,"P")>0,COUNTIF(A2:B2,"F")=0),"P","F"))
G2:H10	G2	=MOD(INT((ROW(INDIRECT("1:"&3^ROWS($A$3:$A$4)))-1 )/3^(TRANSPOSE(ROW(INDIRECT("1:"&ROWS($A$3:$A$4))))-1 )),3)
Dynamic array formulas.