MODE FORMULA FOR MULTIPLE CONDITIONS??

michellesssme · Aug 5, 2022

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

KRice · Aug 8, 2022

That makes a big difference, as some functions used are not available in 2019. Have a look at the green cells for formulas that should work in 2019. In some cases, you'll need to enter the formulas with Ctrl-Shift-Enter (sometimes abbreviated CSE). If you enter the formula normally, confirming it with Enter, you won't see the correct answer. When that happens, click in the formula bar, hit F2 to enter editing mode, and then hit Ctrl-Shift-Enter simultaneously. You should see curly brackets automatically surround the formula indicating it is now an array formula. Also, please update your profile to show Excel 2019 to avoid confusion.

MrExcel_20220803.xlsx

N

O

P

Q

R

S

T

1

Data

Excel 365

Excel 2019

2

666

Mode data <

650

628

confirm with CSE

3

702

Mode data >=

650

666

confirm with CSE

4

741

Min~Max

608~799

5

678

Min~Max of data < 650

608~646

6

673

min~max like (608~646)

7

707

Lower endpoint of range

600

8

737

Upper endpoint of range

700

9

729

Count of points in range

16

10

797

Count of points

26

11

731

12

799

13

729

14

710

15

655

16

608

17

628

18

658

19

643

20

646

21

666

22

628

23

636

24

641

25

677

26

626

27

646

Sheet9

Cell Formulas
Range	Formula
R2	R2	=MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27<Q2))
R3	R3	=MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27>=Q3))
R4:S4	R4	=TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")
R5	R5	=TEXT(MIN(FILTER(N:N,N:N<650)),"0")&"~"&TEXT(MAX(FILTER(N:N,N:N<650)),"0")
S2	S2	=MODE(IF($N$2:$N$27<Q2,$N$2:$N$27))
S3	S3	=MODE(IF($N$2:$N$27>=Q3,$N$2:$N$27))
S5	S5	=TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")
S6	S6	="min~max like (" & TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0") &")"
R9	R9	=COUNTIFS(N:N,">="&Q7,N:N,"<="&Q8)
S9	S9	=COUNTIFS(N:N,">="&Q7,N:N,"<="&Q8)
R10	R10	=COUNT(N:N)
S10	S10	=COUNT(N:N)

michellesssme · Aug 9, 2022

KRice said:
That makes a big difference, as some functions used are not available in 2019. Have a look at the green cells for formulas that should work in 2019. In some cases, you'll need to enter the formulas with Ctrl-Shift-Enter (sometimes abbreviated CSE). If you enter the formula normally, confirming it with Enter, you won't see the correct answer. When that happens, click in the formula bar, hit F2 to enter editing mode, and then hit Ctrl-Shift-Enter simultaneously. You should see curly brackets automatically surround the formula indicating it is now an array formula. Also, please update your profile to show Excel 2019 to avoid confusion.

MrExcel_20220803.xlsx
N O P Q R S T
1 Data Excel 365 Excel 2019
2 666 Mode data < 650 628 628 confirm with CSE
3 702 Mode data >= 650 666 666 confirm with CSE
4 741 Min~Max 608~799 608~799
5 678 Min~Max of data < 650 608~646 608~646
6 673 min~max like (608~646)
7 707 Lower endpoint of range 600
8 737 Upper endpoint of range 700
9 729 Count of points in range 16 16
10 797 Count of points 26 26
11 731
12 799
13 729
14 710
15 655
16 608
17 628
18 658
19 643
20 646
21 666
22 628
23 636
24 641
25 677
26 626
27 646
Sheet9
Cell Formulas
Range Formula
R2 R2 =MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27<Q2))
R3 R3 =MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27>=Q3))
R4:S4 R4 =TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")
R5 R5 =TEXT(MIN(FILTER(N:N,N:N<650)),"0")&"~"&TEXT(MAX(FILTER(N:N,N:N<650)),"0")
S2 S2 =MODE(IF($N$2:$N$27<Q2,$N$2:$N$27))
S3 S3 =MODE(IF($N$2:$N$27>=Q3,$N$2:$N$27))
S5 S5 =TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")
S6 S6 ="min~max like (" & TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0") &")"
R9 R9 =COUNTIFS(N:N,">="&Q7,N:N,"<="&Q8)
S9 S9 =COUNTIFS(N:N,">="&Q7,N:N,"<="&Q8)
R10 R10 =COUNT(N:N)
S10 S10 =COUNT(N:N)

Thanks a lot KRice, May I know what is the meaning for 15,6 and 14,6 in this formula(=TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0"))?

KRice · Aug 9, 2022

I'm happy to help. See my explanation in post #9 of this thread and let me know if it answers your question about the use of AGGREGATE functions:

Index match including a date range with one criteria. For Excel.

I'm updating this question to an EXCEL FORMAT. I'm currently trying to pull data from the Workers column into a new sheet via Index Match, printing the workers' names each time they show up in a particular date range. Workers Company Start Date End Date Jane Smith Microsoft 02/03/2022...

www.mrexcel.com

michellesssme · Aug 9, 2022

KRice said:
I'm happy to help. See my explanation in post #9 of this thread and let me know if it answers your question about the use of AGGREGATE functions:

Index match including a date range with one criteria. For Excel.

I'm updating this question to an EXCEL FORMAT. I'm currently trying to pull data from the Workers column into a new sheet via Index Match, printing the workers' names each time they show up in a particular date range. Workers Company Start Date End Date Jane Smith Microsoft 02/03/2022...

www.mrexcel.com

thank you very much from the provided information. I have another problem. May I know the formula to find out the mode value between the range 600~700?

KRice · Aug 9, 2022

You'll need a variation of the MODE formula. See the block added (orange cells):

MrExcel_20220803.xlsx

N

O

P

Q

R

S

T

1

Data

Excel 365

Excel 2019

2

666

Mode data <

650

628

confirm with CSE

3

702

Mode data >=

650

666

confirm with CSE

4

741

Range lower limit x>=LL

600

5

678

Range upper limit x<=UL

700

6

673

Mode LL<=x<=UL

666

confirm with CSE

7

707

Min~Max

608~799

8

737

Min~Max of data < 650

608~646

9

729

min~max like (608~646)

10

797

Lower endpoint of range

600

11

731

Upper endpoint of range

700

12

799

Count of points in range

16

13

729

Count of points

26

14

710

15

655

16

608

17

628

18

658

19

643

20

646

21

666

22

628

23

636

24

641

25

677

26

626

27

646

Sheet9

Cell Formulas
Range	Formula
R2	R2	=MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27<Q2))
S2	S2	=MODE(IF($N$2:$N$27<Q2,$N$2:$N$27))
R3	R3	=MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27>=Q3))
S3	S3	=MODE(IF($N$2:$N$27>=Q3,$N$2:$N$27))
R7:S7	R7	=TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")
R8	R8	=TEXT(MIN(FILTER(N:N,N:N<650)),"0")&"~"&TEXT(MAX(FILTER(N:N,N:N<650)),"0")
S6	S6	=MODE(IF(($N$2:$N$27>=Q4)*($N$2:$N$27<=Q5),$N$2:$N$27))
S8	S8	=TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")
S9	S9	="min~max like (" & TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0") &")"
R12	R12	=COUNTIFS(N:N,">="&Q10,N:N,"<="&Q11)
S12	S12	=COUNTIFS(N:N,">="&Q10,N:N,"<="&Q11)
R13	R13	=COUNT(N:N)
S13	S13	=COUNT(N:N)

michellesssme · Aug 9, 2022

KRice said:
You'll need a variation of the MODE formula. See the block added (orange cells):

MrExcel_20220803.xlsx
N O P Q R S T
1 Data Excel 365 Excel 2019
2 666 Mode data < 650 628 628 confirm with CSE
3 702 Mode data >= 650 666 666 confirm with CSE
4 741 Range lower limit x>=LL 600
5 678 Range upper limit x<=UL 700
6 673 Mode LL<=x<=UL 666 confirm with CSE
7 707 Min~Max 608~799 608~799
8 737 Min~Max of data < 650 608~646 608~646
9 729 min~max like (608~646)
10 797 Lower endpoint of range 600
11 731 Upper endpoint of range 700
12 799 Count of points in range 16 16
13 729 Count of points 26 26
14 710
15 655
16 608
17 628
18 658
19 643
20 646
21 666
22 628
23 636
24 641
25 677
26 626
27 646
Sheet9
Cell Formulas
Range Formula
R2 R2 =MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27<Q2))
S2 S2 =MODE(IF($N$2:$N$27<Q2,$N$2:$N$27))
R3 R3 =MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27>=Q3))
S3 S3 =MODE(IF($N$2:$N$27>=Q3,$N$2:$N$27))
R7:S7 R7 =TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")
R8 R8 =TEXT(MIN(FILTER(N:N,N:N<650)),"0")&"~"&TEXT(MAX(FILTER(N:N,N:N<650)),"0")
S6 S6 =MODE(IF(($N$2:$N$27>=Q4)*($N$2:$N$27<=Q5),$N$2:$N$27))
S8 S8 =TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")
S9 S9 ="min~max like (" & TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0") &")"
R12 R12 =COUNTIFS(N:N,">="&Q10,N:N,"<="&Q11)
S12 S12 =COUNTIFS(N:N,">="&Q10,N:N,"<="&Q11)
R13 R13 =COUNT(N:N)
S13 S13 =COUNT(N:N)

Actually the situation is like this , Every time I select a specific product from the slicer, table below will show how many data points are lie between 650 to 700 and range for pass or fail is the min and max value from the 19 data points. Do u have any ideas for setting the mode formula for this situation which link to the cell in range for pass/fail?

Range	Data points	Range for Pass/fail	Mode value
650~700	19	652~700

KRice · Aug 9, 2022

See the peach/purple cells. I'm relying on the input cell under "Range" (cell P10 here) rather than "pass/fail" since the slicer is using that same input. Formulas can return the same information, but generally it's a bad idea to rely on text strings (like 650-700 or 655~678) to perform numeric calculations because you have to extract values from the text strings. Then you have two choices: 1) either stash those values somewhere in helper cells so they can be referenced in other formulas, or 2) carry along the awkward formula components necessary for extracting the values and insert those components every time the values are needed. I used the latter approach to illustrate how the single input in the dark purple cell (P10) is used to return the number of data points, the actual range of data falling within the input limits, the mode, and the average.

MrExcel_20220803.xlsx

N

O

P

Q

R

S

T

1

Data

Excel 365

Excel 2019

2

666

Mode data <

650

628

confirm with CSE

3

702

Mode data >=

650

666

confirm with CSE

4

741

Range lower limit x>=LL

600

5

678

Range upper limit x<=UL

700

6

673

Mode LL<=x<=UL

666

confirm with CSE

7

707

8

737

Range

Data Points

Range for Pass/fail

Mode value

Average value

9

729

650-700

19

652~700

10

797

650-700

11

731

12

799

Min~Max

608~799

13

729

Min~Max of data < 650

608~646

14

710

min~max like (608~646)

15

655

Lower endpoint of range

600

16

608

Upper endpoint of range

700

17

628

Count of points in range

16

18

658

Count of points

26

19

643

20

646

21

666

22

628

23

636

24

641

25

677

26

626

27

646

Sheet9

Cell Formulas
Range	Formula
R2	R2	=MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27<Q2))
S2	S2	=MODE(IF($N$2:$N$27<Q2,$N$2:$N$27))
R3	R3	=MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27>=Q3))
S3	S3	=MODE(IF($N$2:$N$27>=Q3,$N$2:$N$27))
S6	S6	=MODE(IF(($N$2:$N$27>=Q4)*($N$2:$N$27<=Q5),$N$2:$N$27))
Q10	Q10	=SUM(IF(($N$2:$N$27>=1LEFT(P10,SEARCH("-",P10)-1))($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),1))
R10	R10	=MIN(IF(($N$2:$N$27>=1LEFT(P10,SEARCH("-",P10)-1))($N$2:$N$27<=1RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))&"~"&MAX(IF(($N$2:$N$27>=1LEFT(P10,SEARCH("-",P10)-1))($N$2:$N$27<=1RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
S10	S10	=MODE(IF(($N$2:$N$27>=1LEFT(P10,SEARCH("-",P10)-1))($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
T10	T10	=AVERAGE(IF(($N$2:$N$27>=1LEFT(P10,SEARCH("-",P10)-1))($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
R12:S12	R12	=TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")
R13	R13	=TEXT(MIN(FILTER(N:N,N:N<650)),"0")&"~"&TEXT(MAX(FILTER(N:N,N:N<650)),"0")
S13	S13	=TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")
S14	S14	="min~max like (" & TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)(N2:N100<>"")),1),"0") &")"
R17	R17	=COUNTIFS(N:N,">="&Q15,N:N,"<="&Q16)
S17	S17	=COUNTIFS(N:N,">="&Q15,N:N,"<="&Q16)
R18	R18	=COUNT(N:N)
S18	S18	=COUNT(N:N)

michellesssme · Aug 10, 2022

KRice said:
See the peach/purple cells. I'm relying on the input cell under "Range" (cell P10 here) rather than "pass/fail" since the slicer is using that same input. Formulas can return the same information, but generally it's a bad idea to rely on text strings (like 650-700 or 655~678) to perform numeric calculations because you have to extract values from the text strings. Then you have two choices: 1) either stash those values somewhere in helper cells so they can be referenced in other formulas, or 2) carry along the awkward formula components necessary for extracting the values and insert those components every time the values are needed. I used the latter approach to illustrate how the single input in the dark purple cell (P10) is used to return the number of data points, the actual range of data falling within the input limits, the mode, and the average.

MrExcel_20220803.xlsx
N O P Q R S T
1 Data Excel 365 Excel 2019
2 666 Mode data < 650 628 628 confirm with CSE
3 702 Mode data >= 650 666 666 confirm with CSE
4 741 Range lower limit x>=LL 600
5 678 Range upper limit x<=UL 700
6 673 Mode LL<=x<=UL 666 confirm with CSE
7 707
8 737 Range Data Points Range for Pass/fail Mode value Average value
9 729 650-700 19 652~700
10 797 650-700 7 655~678 666 667.6
11 731
12 799 Min~Max 608~799 608~799
13 729 Min~Max of data < 650 608~646 608~646
14 710 min~max like (608~646)
15 655 Lower endpoint of range 600
16 608 Upper endpoint of range 700
17 628 Count of points in range 16 16
18 658 Count of points 26 26
19 643
20 646
21 666
22 628
23 636
24 641
25 677
26 626
27 646
Sheet9
Cell Formulas
Range Formula
R2 R2 =MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27<Q2))
S2 S2 =MODE(IF($N$2:$N$27<Q2,$N$2:$N$27))
R3 R3 =MODE.SNGL(FILTER($N$2:$N$27,$N$2:$N$27>=Q3))
S3 S3 =MODE(IF($N$2:$N$27>=Q3,$N$2:$N$27))
S6 S6 =MODE(IF(($N$2:$N$27>=Q4)*($N$2:$N$27<=Q5),$N$2:$N$27))
Q10 Q10 =SUM(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),1))
R10 R10 =MIN(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))&"~"&MAX(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
S10 S10 =MODE(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
T10 T10 =AVERAGE(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
R12:S12 R12 =TEXT(MIN($N:$N),"0")&"~"&TEXT(MAX($N:$N),"0")
R13 R13 =TEXT(MIN(FILTER(N:N,N:N<650)),"0")&"~"&TEXT(MAX(FILTER(N:N,N:N<650)),"0")
S13 S13 =TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")
S14 S14 ="min~max like (" & TEXT(AGGREGATE(15,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0")&"~"&TEXT(AGGREGATE(14,6,(N2:N100)/((N2:N100<650)*(N2:N100<>"")),1),"0") &")"
R17 R17 =COUNTIFS(N:N,">="&Q15,N:N,"<="&Q16)
S17 S17 =COUNTIFS(N:N,">="&Q15,N:N,"<="&Q16)
R18 R18 =COUNT(N:N)
S18 S18 =COUNT(N:N)

May I know how to get the P10 (650~700) as I noticed there is no 650 and 700 appear in this formula (=SUM(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),1)))?

KRice · Aug 10, 2022

P10 is the input text. The formula extracts the two numbers shown in P10.

KRice · Aug 10, 2022

I hope my last post was clear. My understanding is that you are getting summary information from a slicer and it is displayed as shown in your post #16. If that is the case, then to obtain numbers like 650 and 700, you have to do extra work to extract those values from the text string under the "Range" label. That is why I commented:

KRice said:
Formulas can return the same information, but generally it's a bad idea to rely on text strings (like 650-700 or 655~678) to perform numeric calculations because you have to extract values from the text strings.

In this case, extra steps are needed to identify where the hyphen (-) is in the text string, as that separates the two numbers:
SEARCH("-",P10)
Then based on the position of the hyphen, we can take the text to the left of it:
LEFT(P10,SEARCH("-",P10)-1)
...where the -1 means to stop just before reaching the hyphen's position. This results in the text "650".
Then we need to convert this text to an actual value, so I've multiplied by 1, which coerces text that looks like a number to an actual number.
So 1*LEFT(P10,SEARCH("-",P10)-1) delivers the number 650 (or whatever number appears before the hyphen in P10).

The story is similar, but a little more complicated, for extracting 700, or whatever number appears after the hyphen in P10. That's what this part of the formula does:
1*RIGHT(P10,LEN(P10)-SEARCH("-",P10))

Back to my comment about using text strings...the formula for mode shown in post #16 is this:
MODE(IF(($N$2:$N$27>=1*LEFT(P10,SEARCH("-",P10)-1))*($N$2:$N$27<=1*RIGHT(P10,LEN(P10)-SEARCH("-",P10)) ),$N$2:$N$27))
If you hardwired the numbers directly into the formula or simply referred to individual cells where the range limits are found (say Q4 and Q5), the formula would look something like:
MODE(IF(($N$2:$N$27>=650)*($N$2:$N$27<=700),$N$2:$N$27))
or
MODE(IF(($N$2:$N$27>=Q4)*($N$2:$N$27<=Q5),$N$2:$N$27))
So approximately half of the formula is consumed by operations doing nothing more than extracting values from text...values that you may already have somewhere else.

MODE FORMULA FOR MULTIPLE CONDITIONS??

michellesssme

New Member

KRice

Well-known Member

Excel Facts

michellesssme

New Member

KRice

Well-known Member

Index match including a date range with one criteria. For Excel.

michellesssme

New Member

Index match including a date range with one criteria. For Excel.

KRice

Well-known Member

michellesssme

New Member

KRice

Well-known Member

michellesssme

New Member

KRice

Well-known Member

KRice

Well-known Member

Similar threads

Forum statistics

Share this page

MODE FORMULA FOR MULTIPLE CONDITIONS??

New Member

Well-known Member

Excel Facts

New Member

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock