I have added an attachment now. sorry I can't describe my issue in title.
I have added an attachment now. sorry I can't describe my issue in title.
Last edited by Pepe Le Mokko; 12-04-2019 at 03:55 AM. Reason: Changed title
It would help if you attach that data as an Excel workbook - see the yellow banner at the top of the screen for details on how to do this.
Pete
1. this is posted in the Access forum, should it be moved to the Excel forum?
2. please explain exactly what you are trying to do here...so we can change your title to something that actually describes your problem.
3. Follow Pete's suggestion
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Using Power Query, here is the Mcode and a file showing your results as expected.
EDIT: Just noticed you are running Excel 2007. This solution will not work for you unless you are running 2010 or later. Apologies.
Please Login or Register to view this content.
v A B C D E F G H I J K L M N O P Q 1 Emp. ID Name 16-09-2019 17-09-2019 18-09-2019 19-09-2019 20-09-2019 21-09-2019 22-09-2019 23-09-2019 24-09-2019 25-09-2019 26-09-2019 27-09-2019 28-09-2019 29-09-2019 30-09-2019 2 23235719 Abdul Imran P P P P P P WO P P P P P P WO P 3 23237559 Abhijat Sarang P P P P P WO WO P P P P P WO WO P
Last edited by alansidman; 12-04-2019 at 01:38 AM.
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
thank you for your help but i am using office 2007. so there is any possibility for office 2007 also ? now i have attached an excel file also in my post.
Thanks for kind help, yesterday i can't find a way to attached the workbook but now i have attached it. please go through it and help me. i am using office 2007
Sorry for inconvenience, now i realized i have posted it in wrong forum, it should in Excel forum.
As a admin you can move it. or else please help in a process how to move it on excel forum. i am just new here.
Please read post #3 line #2
I have list of attendance details of all the employees and details are in vertical formate. i need to provide them register for which is in horizontal way carrying all the attendance details.
Here, the issue is the data they provide where name and employee is are multiple time for each and every date with here attendance status. so i can't use transpose function.
Apologies if I can't explain in issue properly please find an workbook which I attached in the post for reference.
In G2, copied across and down:
=IFERROR(INDEX(A$2:A$31,MATCH(0,INDEX(COUNTIF(G$1:G1,A$2:A$31),0),0)),"")
In I2, copied across and down:
=IF($G2="","",INDEX($D$2:$D$31,MATCH(1,INDEX(($A$2:$A$31=$G2)*($C$2:$C$31=I$1),0),0)))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks