Hi All,
May i have your advise on the following scenario ?
I have a payment file that requries me to put the payment date to all transactions records in a respective account.
As the payment file is generated monthly, it is tedious to put the payment date to each record in a respective account.
Please enlighten me on the following problem.
Many thanks in advance.
A sample file is attached for your reference.
Where do you wish the date to appear and what date do you wish to appear. Your description of what you want is very vague.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Apologies for the vague description.
Basically what i need is to have the payment date to appear at Column N (New column)
to all transaction records of the account code before the payment record.
Kindly refer to screenshot for a clear picture.
Many thanks.
http://imgur.com/LDRG5nP
Best Regards,
Diego
Last edited by diegomagnum; 10-02-2014 at 01:45 AM.
In N2 apply the below array formula (to be enter with ctrl+shift+enter) and drag it down
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Refer the attachment
Does that help ?
Hi Boopathiraja,
Many thanks, it works .
Appreciate your help. Have a good weekend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks