Jump to content

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

    • Sue
      Up date on Viet Flavour

      By Sue · Posted

      😮
    • NewWave
      Up date on Viet Flavour

      By NewWave · Posted

      was the price not displayed on the menu?
    • Lord Pencilton
      4+ Assessment Advice for Parents

      By Lord Pencilton · Posted

      It has come to this author’s attention that the world of 4+ admissions — that most enigmatic of educational rites — continues to bewilder even the most composed of parents. Fear not. For in a former life, I was not merely a humble observer, but a seasoned educator of over twenty years, and Head of Pre-Prep for a distinguished dozen. Now, with quill exchanged for touchscreen, I have taken to that most modern of salons — Instagram — to dispense guidance, answer frequently whispered questions, and illuminate the shadowy corners of school selection with clarity and calm. Each post bears my signature twist: a blend of insight, levity, and the occasional raised eyebrow. Should you find yourself adrift in the sea of admissions, I suggest you peruse my latest dispatch. It may well be the lifeline you seek. The Delicate Dilemma of the Summer-born 4+ Scholars Yours in solidarity and scholastic savvy, Lord Pencilton  🎩✏️
    • kiera
      GALA 2026

      By kiera · Posted

      Perhaps Gooseygreeny was not familiar with the wildlife before Gala was imposed on the park, since when its value to wildlife has deteriorated. The Park had never been disturbed before, as the council had respected it as a Site of Importance for Nature Conservation, so only the Common was licensed by them as a site for events. The first time Gala held their event, there was a tree with woodpeckers nesting in it right in the middle of the main field they used and thrushes, blackbirds and great tits nesting within the shrubs and trees immediately surrounding the field. The woodpeckers were thriving on ants from the anthills in the grass. To those of us who used to enjoy watching the wildlife, it was very obviously a Site of Importance for a variety of birds. Despite being accessed by the public and their dogs, it had been relatively undisturbed,  which was one of the main reasons why it was so special and why I have been opposed to the Gala festival being held during the bird nesting season.

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...