Hi Friends,
In worksheet column A contain Branch Code and column B contain Values
I need output initial value , Final value & missing values for each branch Code.
(Please find attached file for more clarification.)
https://www.dropbox.com/s/frjo4r0lixgjm7o/Intial%20%26%20Final.xls
I have lot off branch Codes and Values.
Please see below details.
<<Data sheet>>
Branch
Code Value
0283 1676651
0283 1676652
0283 1676654
0283 1676656
0283 1676657
0583 1617612
0583 1617613
0583 1617614
0583 1617615
0583 1617616
<<Output Sheet>>
(Required Output)
Branch
Code From To Missing
0283 1676651 1676657 1676655, 1676653
0583 1617612 1617616
Any Help May Appriciated....
Regards,
Nandkumar S.
Posted by: satputenandkumar0@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar