Hi,
I have a data of employee data base of different months in one table i have to get the unique employee list of mentioned month using formula
Example Column Sheet1 A,B,C,D have the employee data base and E have the month when my value of Sheet2 A1 is Any of month an year i have to show the unique record of that month data from in sheet2 A2 of mentioned all column data
Thanks
Liju
Lack of answer is probably a result of problems with writing down in excel how it shall work. so:
Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).
3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!
To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
Best Regards,
Kaper
Hi,
Thanks for your reply i have attached the sample data which you required and i have to get the records which
i have selected on mentioned column.
thanks
Liju
Hello.
Here's what you need:
In "A3" type a following formula:
In "B3" type:
Please Login or Register to view this content.
In "C3" type:Please Login or Register to view this content.
In "D3" type:Please Login or Register to view this content.
= IF (A3 = ""; "" $ A $ 1)
Remember that the first three should be closed with CTRL + SHIFT + ENTER because they are matrix formulas.
Hi,
Thanks for your reply but i had checked the data is showing the employee list on that specific month but other fields are not matching against the employee
please lets me know where i need to be do the changes for accurate mapping
Regards
liju
This proposed solution turns the data range on sheet 1 (A1:E21) into a table, which enables the data to be easily sorted by employee name.
The formula that populates D3:D16 on sheet 2 is:Formula:
Please Login or Register to view this content.
The array entered formula* that populates A3:C16 on sheet 2 is:Formula:Please Login or Register to view this content.
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks