I am looking for a help.
Having a database of 20000 employees data, from the main data i want to extract data in new file according their room numbers.
Example room no.(A-1) 5 people are occupied, i want to see these 5 people in new file by typing their room number.
Vl lokup can display only one record matching the room numbers, multiple record not getting.
Any one can help, please
Justin
Bookmarks