From a roster of individuals, auto-populate other sheets from that roster based on their qualifications.
'Roster' is a consolidated list of individuals with name, vehicle qualification and birthmonth. Based on the vehicle qualification in column B, I want the information to auto populate to the like named sheet (M or L).
Hi
In Roster!D2 use the auxiliar formulaand copy to E2 and downFormula:
=IF($B2="L",D1+1,D1)
In the sheet L!A3 use the formulaFormula:=IFERROR(INDEX(Roster!$A$2:$C$27,MATCH(ROW(A1),Roster!$D$2:$D$27,0),1),"")
See the file qUESTION.xlsx
Best regards
I've attached a solution for you. There is one major constraint with this solution method.
*** It requires unique names. If there are any duplicate names this solution will not work. ***
Let me know if your original dataset is formatted in such a way that it'll be impossible to work without having some duplicates.
Hope this helps!
edit: José has the better solution if you don't mind adding an extra column of data beside your original dataset.
Last edited by ThirdFret; 08-19-2015 at 03:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks