Jump to content
Everywhere

Excel query

Alan Medic

By Alan Medic
in The Lounge

 Share

Recommended Posts

Alan Medic

Alan Medic

Posted
Posted

Wonder if anyone can tell me if there is a way of doing this? I have a series of values (which could be either negative or positive) that will add up to Zero. However I don?t know which are positive or which are negative.


Is there a way of calculating how these numbers being one way or the other will add up to Zero and if there is more than one way of doing it?


I?m being lazy here as I should be able to deduce which is a negative or a positive and am just looking for a quicker option.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/
Share on other sites
miga

miga

Posted
Posted

ed_pete: (2 x (2^(n-1)) a.k.a 2^n, and not sure where - 2 comes from, are you maybe forgetting all/no - or all/no +?


With no further restrictions, reckon Jeremy's right.


There are some vaguely similar counting/summing problems which you can do in order of n steps, but these tend to have a kind of "ordering" implicit in them, such as finding the point in a set which gives two parts, the sums of each respective part giving minimal absolute difference.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/#findComment-927552
Share on other sites
Alan Medic

Alan Medic

Posted
  • Author
Posted

Jeremy Wrote:

-------------------------------------------------------

> Are you talking about methodically assigning

> +ve/-ve signs to each number until you reach a

> solution?

>

> Easy to code in VBA.. but if your data set is

> large, you might find it surpisingly slow to

> compute.


We're talking about less than 40 values which already have a plus or minus assigned to them as a result of a reconciliation. However these add up to over ?4,000 in value. By a process of deduction, a plus or a minus can be reversed depending of the reason it is what it is in the first place. With the correct alterations the sum of the numbers will be zero.


May be easy to code in VBA if you know how.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/#findComment-927556
Share on other sites
Alan Medic

Alan Medic

Posted
  • Author
Posted

Jeremy Wrote:

-------------------------------------------------------

> You can do it using Excel "Solver"

>

> Example here - very similar to what you need to

> do

> http://www.k2e.com/tech-update/tips/147-using-exce

> l-to-identify-entries-that-add-to-a-specific-value


Thanks Jeremy. Will try that after eating my rice cakes with peanut butter and banana.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/#findComment-927578
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
  • Advertise Here

  • Latest Discussions

    • Hen123
      Yet another burst main... major leak on Lordship Lane nr junction with Barry Rd

      By Hen123 · Posted

      I was talking to my brother in the law last weekend who works for a different water company. He said he and his colleagues watch TW’s woes with a mixed of horror, disbelief and then relief that they work for a different water company. Worth a watch. https://www.bbc.co.uk/iplayer/episode/m00284vt
    • Sue
      Yet another burst main... major leak on Lordship Lane nr junction with Barry Rd

      By Sue · Posted

      But Thatcher is dead. Nobody since has brought the utilities back under public ownership (if that's the right term). So there are many people who could be blamed. Meanwhile the shareholders get richer and everyone else gets increasing bills and a poorer service. Plus as said above, a massive waste of a limited resource like water. Not to mention the polluted rivers and seas. At least the privatisation of the railways is being reversed. Hopefully water may be on the list somewhere.
    • Sue
      Noticeboard on Northcross Road

      By Sue · Posted

      That's really helpful. Do the Community Councils still exist? It sounds to me that whoever the contact is on the council who has sorted out the North Cross Road notice board and put the new list of councillors in it must at least have access to the key for that one? Unless it was one of the unlocked ones. And of course if somebody knows where the keys are, they may have no idea that people are looking for them or that this forum thread exists. Which are the notice boards which are not locked?  The very helpful locksmith near the station (?Callows?)  might be able to provide keys for them, or if not, new locks, in return for some local publicity? In fact, they may be able to advise in general, rather than keep trying unresponsive people at the council. But then of course there is still the question of who is going to take responsibility for putting appropriate East Dulwich community information into them and updating it as necessary.
    • Pugwash
      Noticeboard on Northcross Road

      By Pugwash · Posted

      Our residents' association used to have keys many moons ago, but when locks were changed, we tried everyone (including ward councillors) to get keys to no avail. A couple of boards are not locked. The Community Councils originally paid for all the notice boards in Dulwich. May have come under the Cleaner Greener budget.

East Dulwich Forum

Established in 2006, we are an online community discussion forum for people who live, work in and visit SE22.

Home
Events
Sign In

Sign In



Or sign in with one of these services

Search
×
    Search In
×
×
  • Create New...