3-D formula to calculate highest temp from 3 cities

dcalovi · Oct 25, 2012

Hi,
I'm not exactly sure what i'm doing. I need to make a 3-D formula to calculate the highest temp in the 3 different cities.. I'm completely lost when it comes to having to do more than 1 thing in a formula. Each of the cities are one in each of its own worksheet. I have to do a 3-D formula on summary page to show what city had the highest temp. One more thing I can't figure out is another nested formula. I need to nest a MATCH function within a INDEX function to identify the date for the highest temperature. This is what I have for that =INDEX(A6:B35,B30,1+MATCH(B30,$B$6:$B$35,0)). What am I doing wrong or not un standing. I have pasted all 4 worksheets on here in hopes it'll be easier to have a visual on what im talking about.

OKC - June Temperatures

OKC - June Temperatures

June Temperature Summary
In °F


Date	High	High-City	Low	Low-City
6/1	89	Tulsa	66
6/2	82		64
6/3	72		58
6/4	80		53
6/5	84		56
6/6	93		65
6/7	93		70
6/8	90		66
6/9	93		70
6/10	90		62
6/11	87		62
6/12	91		63
6/13	90		68
6/14	90		69
6/15	94		68
6/16	94		70
6/17	94		71
6/18	94		73
6/19	94		74
6/20	94		72
6/21	96		76
6/22	99		72
6/23	100		70
6/24	101		70
6/25	101		71
6/26	101		69
6/27	102		72
6/28	94		70
6/29	96		67
6/30	99		65


Monthly Records
High/Low
Date
City

OKC - June Temperatures
In °F
Lawton-Fort Sill

Date	High	Low
6/1	88	69
6/2	82	64
6/3	71	62
6/4	79	55
6/5	84	59
6/6	93	65
6/7	92	74
6/8	90	68
6/9	93	70
6/10	79	63
6/11	84	63
6/12	91	70
6/13	90	71
6/14	90	69
6/15	93	68
6/16	93	74
6/17	93	73
6/18	94	73
6/19	90	74
6/20	91	72
6/21	95	76
6/22	98	73
6/23	98	70
6/24	98	74
6/25	99	72
6/26	99	69
6/27	102	74
6/28	90	73
6/29	87	71
6/30	96	68


Monthly Records
High/Low	102	55
Date	#REF!	#REF!

In °F

Oklahoma City

Date

High

Low

6/1

87

66

6/2

82

66

6/3

72

64

6/4

80

55

6/5

83

56

6/6

88

66

6/7

88

70

6/8

88

66

6/9

93

70

6/10

85

62

6/11

87

62

6/12

91

71

6/13

88

74

6/14

89

70

6/15

94

71

6/16

94

76

6/17

94

71

6/18

93

73

6/19

93

76

6/20

92

75

6/21

96

78

6/22

99

72

6/23

99

72

6/24

99

70

6/25

101

71

6/26

99

73

6/27

101

72

6/28

93

74

6/29

91

67

6/30

98

65

Monthly Records

High/Low

101

55

Date

#REF!

In °F

Tulsa

Date

High

Low

6/1

89

70

6/2

82

67

6/3

72

58

6/4

80

53

6/5

84

56

6/6

87

69

6/7

93

73

6/8

87

67

6/9

91

71

6/10

90

66

6/11

86

64

6/12

85

63

6/13

89

68

6/14

83

70

6/15

93

75

6/16

94

70

6/17

94

73

6/18

94

78

6/19

94

80

6/20

94

77

6/21

96

80

6/22

99

79

6/23

100

78

6/24

101

76

6/25

101

75

6/26

101

76

6/27

101

75

6/28

94

70

6/29

96

67

6/30

99

75

Monthly Records

High/Low

101

53

Date

#REF!

3-D formula to calculate highest temp from 3 cities

dcalovi

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

3-D formula to calculate highest temp from 3 cities

dcalovi

New Member

Excel Facts

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