Josue Barocio
Board Regular
- Joined
- Mar 8, 2002
- Messages
- 101
I adapted the following array formula from this post from Juan Pablo Gonzáles: http://www.mrexcel.com/board2/viewtopic.php?t=50304&highlight=maxif
{=MAX(IF(A$3:A$13=A18,C$3:C$13))}
How can I modify the formula to exclude all items TYPE "1" in the following example?
Thanks in advance.
Joe
{=MAX(IF(A$3:A$13=A18,C$3:C$13))}
How can I modify the formula to exclude all items TYPE "1" in the following example?
Thanks in advance.
Joe
Book4 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | INPUTFILE | |||||
2 | LEVEL | TYPE | LEADTIME | |||
3 | 1 | 1 | 30 | |||
4 | 2 | 4 | 15 | |||
5 | 2 | 4 | 25 | |||
6 | 2 | 1 | 30 | |||
7 | 3 | 4 | 60 | |||
8 | 3 | 4 | 15 | |||
9 | 3 | 9 | 26 | |||
10 | 4 | 4 | 30 | |||
11 | 4 | 4 | 30 | |||
12 | 2 | 4 | 95 | |||
13 | 2 | 4 | 15 | |||
Sheet1 |