Hi,
Please help on the below issue.
I have a data from cells A2:GF6 by date wise. Now I need to format these data into similar type by date wise.
Data:
Data.jpg
Result to be required:
Result.jpg
Thank u
Hi,
Please help on the below issue.
I have a data from cells A2:GF6 by date wise. Now I need to format these data into similar type by date wise.
Data:
Data.jpg
Result to be required:
Result.jpg
Thank u
Last edited by roven.aravind; 05-30-2018 at 02:46 AM. Reason: resource column not included
In the attached file I put your dates in column A from A22 downwards, and this formula in B22:
=VLOOKUP(COUNTIF(A$22:A22,A22),$A$4:$B$6,2,0)
In C22 I used this formula:
=INDEX($C$4:$GF$6,MATCH($B22,$B$4:$B$6,0),MATCH($A22,$C$2:$GF$2,0)+COLUMNS($C:C)-1)&""
which can be copied across into D22:H22. Then those formulae on row 22 can be copied down as far as you need.
Hope this helps.
Pete
Thank u very much.
It is working.
Can you please please explain the detailing about +COLUMNS($C:C)-1)&""
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks