Formulas on Spread sheet

Posted on 2014-12-01
Last Modified: 2014-12-04
I have a spread sheet that has 4 TABS
1.      Main Sheet
2.      Open
3.      Closed
4.      On Hold
On the Open Tab worksheet, I fill in the row and the STATUS selected in Column I determines where the row gets moved to
The same applies for the Closed and On Hold work sheets whe using the status in column I
The problem I have is on the main sheet with:
1.      Values in Column C and Column D
2.      The graph shows the data negatively
3.      F2 shows me the last number used for any row been added, so if I add a new row, at look at F2 and select the next number for my new record
4.      I am just trying to tidy up the formulas  D9:R11
Any suggestions much appreciated
Question by:propolis
  • 5
  • 3
LVL 24

Expert Comment

by:Phillip Burton
ID: 40473695
Unfortunately, your spreadsheet did not upload properly.

Author Comment

ID: 40473710
I will upload again - its a excel macro enabled workbook
LVL 24

Expert Comment

by:Phillip Burton
ID: 40473742
Your formula is wrong - the answers do not reflect the data. For example, the "On Hold" looks like it is in October, whereas it is in December. Your Closed value is similarly wrong.

The graph also has the wrong data source - it goes from C to R for the values, and E to R for the labels.

Please find attached a corrected version. It also does away with the need for row 7.
LVL 24

Expert Comment

by:Phillip Burton
ID: 40473743
Looks like you need to rename my version with .xlsm at the end - it has the same problems as your upload did.
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.


Author Comment

ID: 40473771
Hi Phillip,

Can you send me an uncompressed version if possible

LVL 24

Expert Comment

by:Phillip Burton
ID: 40473777
It is uncompressed.

Look at your uploads - they didn't have .xlsm in the file name. Well, it's the same here. It's not compressed - just the name is changed when uploading.

But I've removed the . in "edward.aldridge" in this version - maybe that will upload more properly.
LVL 24

Accepted Solution

Phillip Burton earned 500 total points
ID: 40473778
Nope - just rename the file and put .xlsm at the end, then open it in Excel.

Author Closing Comment

ID: 40481537
Thank you very much

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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 …
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

762 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

21 Experts available now in Live!

Get 1:1 Help Now