Help needed from an Excel expert

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

LisaContractorUmbrella replied

26 March 2015, 15:55
Originally posted by JRCT View Post

Ok, leave it with me. This sounds like a Friday job.

Thank you
Leave a comment:
JRCT replied

26 March 2015, 15:43
Ok, leave it with me. This sounds like a Friday job.
Leave a comment:
LisaContractorUmbrella replied

26 March 2015, 15:02
Originally posted by JRCT View Post

I understand you want this

1000 950
600 1000

And this:

310 950
600 850
350 430

What about this?

310 950
430 1000
200 600
100 900
120 1200
60 1100
40 1650

Is there a limit to how many entries could make up a single corresponding entry?

sorry no what I want it to return is the total of the numbers that make up the total of the target number if you see what I mean so that both columns of figures match
Leave a comment:
JRCT replied

26 March 2015, 14:22
I understand you want this

1000 950
600 1000

And this:

310 950
600 850
350 430

What about this?

310 950
430 1000
200 600
100 900
120 1200
60 1100
40 1650

Is there a limit to how many entries could make up a single corresponding entry?
Leave a comment:
LisaContractorUmbrella replied

26 March 2015, 13:30
Originally posted by JRCT View Post

NOTHING is impossible in Excel.

What are you really trying to achieve though?

What if you have more than one match/ combination?

What if you have 20, 30 or 50 entries that match only 1 other entry - is there a limit?

The 'nothing is impossible' is encouraging It's unlikely that there would be any combination of entries that would exactly match others
Leave a comment:
JRCT replied

26 March 2015, 12:10
NOTHING is impossible in Excel.

What are you really trying to achieve though?

What if you have more than one match/ combination?

What if you have 20, 30 or 50 entries that match only 1 other entry - is there a limit?
Leave a comment:
LisaContractorUmbrella started a topic Help needed from an Excel expert

26 March 2015, 12:02
Help needed from an Excel expert

Morning chaps

Can someone tell me whether or not it's possible to compare two columns of figures and determine which combination of numbers would, when totalled, equal another number. I have 2 worksheets which each have 100+ rows - 2 columns of data have been compared using Index/Match which works well but, in some cases, a number on worksheet 2 will have been entered on worksheet 1 as several different entries:

Worksheet 2 Worksheet 1

1000.00 1000.00
2000.00 1200.00
1500.00 800.00
1200.00 1500.00
1800.00 600.00
600.00
1800.00

The highlighted entries match exactly but those that are not highlighted match but only as a combination.

I have looked at the Solver Addin but as far as I can see the number to be checked must be entered and I will need to apply any formula you come up with to variable numbers across 100+rows. I have also looked at VBA code but it looks as though the volume of data would make that option unworkable.

Any help/advice, even if it's "that's impossible" would be gratefully received
Tags: None