hi, Apologies if this is in the wrong place. I am new here and to excel
i have a faculty list in sheet 1. i want to make employees information form using ID CNIC to fill the data in 2nd sheet please guide.
hi, Apologies if this is in the wrong place. I am new here and to excel
i have a faculty list in sheet 1. i want to make employees information form using ID CNIC to fill the data in 2nd sheet please guide.
Last edited by AbidBahawalpur1986; 03-15-2024 at 01:25 PM.
Please mock up expected results. Don't give us an empty sheet - fill it in manually to show what you want.
Has this data been desensitised, or are these real people? If the latter, then we have data protection issues - please edit the workbook to desensitise the data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe this:
=CHOOSECOLS(FILTER('Numbers of Teachers Complete'!$A$5:$S$22,'Numbers of Teachers Complete'!$S$5:$S$22=$B$9),8)
changing the red 8 to correspond to the correct column. Done for Name and DoB. If there are data Protection laws in PK, you DO need to anonymise the sample sheet.
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
Thank you "Glenn Kennedy"for understanding my query and helping. It has helped me to get the results!
Do we need to remove your attachment? Please read and respond to our concerns.
That is not original data or any one personal data so it doesn't matter if it remains on the forum but if yours rules do not allow then you can remove
It's only important if there are data protection laws in YOUR country. In the EU publishing a sheet like this, with real names DoB, etc of EU citizens would be illegal.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks