Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Table

Status
Not open for further replies.

xsubzeroz

Technical User
Oct 15, 2002
39
CA
My question would be a little long. I have from cell A2 to A50 numbers. In cell B2 to B50 I have formula that calculates SUM of some cells. In Cell C1 to N1 I have January to February. Now in C2 I have formula that says if A2=1 (1 for January) then type B2(SUM formula result in B2), in C3 if A3=1 then B3. Same thing for column D. In D2 if A2=2 (2 for February) then type B2. After I finished putting numbers in column A, under January to December the numbers all over the place according to number in column A. Now what I need to know If I can type lets say in A100 to L100 "January to December" and underneath each month pick number from previous table in line them up.

(example what I have in table)
A B
1 Jan Febr Mar Apr May
1 2 2.5 2.5
2 3 3.5 3.5
3 2 6.5 6.5
4 1 8.5 8.5
5 2 4.5 4.5
6 3 2.4 2.4

(example what I want after)

Jan Febr Mar Apr May
100 8.5 2.5 3.5
101 6.5 2.4
102 4.5
103
104
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top