Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel Easy Formula help

Posted on 2014-11-20
2
Medium Priority
?
117 Views
Last Modified: 2014-11-20
please see the attached file. there are two tables, table1 which is what i have current. Table2 is what i need.

might be very easy, but i could not figure it out.
EE.xlsx
0
Comment
Question by:Flora
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40455591
Cell C5 should have:

=IF(A5=A4,SUM(B5,C4),B5)

Then copy that down through to C24.
0
 
LVL 6

Author Comment

by:Flora
ID: 40455608
This is brilliant Philip

wouldn't it be possible to do this via the original formula? with INDEX and ROW?

if this is too much trouble, then i can live with =IF(A5=A4,SUM(B5,C4),B5)

thanks very much.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question