HI
How do blanks cells against Date picking without duplication row to column for corresponding to the Branch
as requested Could you please explain me, how does this work?
File attached herewith. please help me.
HI
How do blanks cells against Date picking without duplication row to column for corresponding to the Branch
as requested Could you please explain me, how does this work?
File attached herewith. please help me.
Hi Vandini,
What do you wanted to have there in new format? Do you wanted to have the count or sum or transpose the format?
I assumed that you must be wanted to have sum against each City and respective date so i have attached a book for your reference.
Thanks,
Anil Dhawan
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
Data:
A B C D E
Branch Invoice No Invoice Date Value Dispatch Date
BHOPAL 4903714620 01.04.2015 2873.96 05.04.2015
BHOPAL 4903715258 02.04.2015 1907.08 05.04.2015
BHOPAL 4903717196 04.04.2015 1907.08
BHOPAL 4903718178 06.04.2015 9017.08
BHOPAL 4903718298 06.04.2015 9017.09
BHOPAL 4903718299 06.04.2015 1907.08 10.04.2015
BHOPAL 4903720880 08.04.2015 9915.9 10.04.2015
BHOPAL 4903722128 09.04.2015 12789.86
Req Format
H I
Branch Invoice Date
Bhopal: 04.04.2015,06.04.2015,09.04.2015
are
H I J K
Bhopal: 04.04.2015 06.04.2015 09.04.2015
I want blank cell(dispatch date blanks in column E) against Invoice date required(column C) corresponding to the Branch.
pl help me file attached herewith.
pl help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks