View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135
 
Posts: n/a
Default offsetting values of multiple cells!


hi Pete!

no problem!
actually i have to reconcile more than 1000s of entries on weekly
basis!
outof which nearly 75% will be of one to one type which i can easily
eliminate from the list!

for the remaining 25% i need some solution for reconciliation!

there may be atleast 2 or more credits which equals a single debit
entry and vice versa.!!

if you want more expl i am ready to provide!

regds!

-via135


Pete_UK Wrote:
Hello via,

I'm sorry - I've only just noticed that you have been repeatedly
asking
for help.

I know from other similar postings that this can be very difficult to
achieve, and the fact that nobody else has picked up your pleas for
help is indicative of this. However, I like a challenge, so I will
look
into this. First a few questions:

How representative is your example data? Are you likely to have only
10
payments, or could there be many more to reconcile?

How frequently would you want to carry out the reconciliation?

Are you likely to have only one debit and one credit unmatched, as in
your example, or could there in reality be many of each that are
unmatched?

I can't do anything more at the moment - it's 3am here now and I need
some sleep. Also, I rarely check the newsgroups at weekends, so it may
be next week before I check for your response.

Hope this helps for the moment.

Pete

via135 wrote:
is it so tough???

-via135


via135 Wrote:
reminding again & again for help???!!!

-via135



--
via135

------------------------------------------------------------------------
via135's Profile:

http://www.excelforum.com/member.php...o&userid=26725
View this thread:

http://www.excelforum.com/showthread...hreadid=548681



--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=548681