Need help with data sorting

excelisfun Posts 1 Registration date Wednesday September 9, 2015 Status Member Last seen September 9, 2015 - Sep 9, 2015 at 09:15 AM
 Blocked Profile - Sep 9, 2015 at 06:36 PM
I have 2 columns , one which contains values ( the invoice amount) i send.. The other column will have another list of values ( funds credited to me). The sum of both will normally be the same.
The problem is the individual values will not tally,
eg. Column A has : 80,28.50,125,52,55.50,400,44.50,62.50
Column B has : 205.50,444.50,80,118
I need to identify which values of column A are included in the value of column B. eg 28.50+125+52=205.50.
Can someone please suggest a way to identify the corresponding values.

1 response

Blocked Profile
Sep 9, 2015 at 06:36 PM
OK, so you need help with a spreadsheet, and what type of work do you do? What you are asking is more of a coding problem, and not an invoice or credit problem. Now, with that, we do not offer turn key solutions for problems, but we help when stuck.

Besides, do the two lines need to match, or does the code have to figure out that 80 is in index 3 of the list, and in the master index it is number 9? See what I am asking? We can author wrong code for you all day, and do not wish to do this. Your scope of the "program" is lacking logic to fulfill the requirements stated within the problem.

What is to happen when we have two 80 invoices are found? Just wash it, or do we qualify the selection and drill down to another range of qualifiers?

I am certain that someone will come along and help out, we just need to make certain that we understand the scope clearly.

I have said it once, I will say it again. IT!