Any recommendations or ideas for a “spreadsheet control” to make sure in a forecast file the numbers rolled over (which get hard coded by a macro) all are correct, as in the sums all sum correctly etc? Project for work and I’m not sure where to start.

like
Posting as :
works at
You are currently posting as works at

First of all kudos to implement good practices like transversal control. This is a good step towards sustainable spreadsheets.

To implementing such controls can simply be done with control cells doing some aggregations of values.

To be able to help you please post or PM more specifics like a detailed working of your system with a screenshot.

Related Posts

Anyone live in east harlem in New York around 104th street? Thinking of leasing near there. Is the neighborhood fairly safe?

like

How much value do organizations give to managers/principals/partners who are great at developing internal talent? Does it make it easier to move up?

funnylikehelpful

29, Currently a Deli Manager with over 3 years experience. I am completely burned out. I need a immediate career change we’re I can continue to support my self. I have experience in Banking, Real Estate, Shipping, caregiving, and the obvious retail experience. I do unfortunately have a deferred adjudication for theft it was dismissed a year ago, so I have 4 more years to seal the record. I would appreciate any recommendations. Background check anxiety holds me back .

Any agencies need a freelance AD?

like

How the market right now? Is it a good time to make a move?

funnylike

Any SAP PP job opening in Pune, please ping and refer, looking an apportunity for my husband who's holding 6 years of total exp. And 3 years into SAP PP Infosys Wipro Deloitte Tata Consultancy Accenture SAP

like

Hi all, I’m gonna join pwc ac Bangalore next month. I need your help In knowing the holiday calendar or holidays available in last week of December I.e in between Dec 25th to Dec 31st. To plan my vacation. Please help

like

Need a letter of recommendation from someone outside my network.

Anyone in the world of willing to help me out?

like

Does PHR certification help in India, as this is globally recognised how much valuable is this currently in indian job market.

Do we got some good offers or its another certificate just to add to CV after so much of investment & time I don't want to get this wasted !!

Need suggestions ??

First time home buyer and I have no idea what I can afford. Excellent credit. I know to get a preauthorization before looking but want to skim homes the meantime. Any good rule of thumb when searching?

like

I’m a manager in PwC’s human capital practice. I’m getting recruiting messages from the other Big 4, as I imagine most of us are. I’m interested in hearing about human capital consultants who went from PwC to one of the other firms, as well as people who came from one of the other firms to PwC. Happily ever afters as welcome as horror stories here. Thanks!

like

How much can we salary can we Optum ask for a Senior data analyst at optum?

like

Hii fishes
I had applied for consultant role in Societe generale. The application status is under status "Under Consideration".If you could please help me out as there has been no update and it is going to be 1 month since I applied.

S&P Global I am starting my new job tomorrow at S&P Global
Any tips and tricks to remember in order to do better at my new work place.

like

Should I follow up with Capgemini HR after two days of document uploading. There's no update yet. Capgemini

like

HCL or Infosys compare to TCS in terms of job security?

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Additional Posts in Excel Genius

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Would anyone be willing to teach me vlookup?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Still don't have xlookup. #fomo

like

Any book recommendations on excel modeling for real world business applications?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal