Solved

Excel Easy Formula help

Posted on 2014-11-20
2
99 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 500 total points
ID: 40455591
Cell C5 should have:

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

Then copy that down through to C24.
0
 
LVL 5

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now