Function Problem

[krzysq]

hi, I have this spread sheet Download file example.xlsx . What I trying to is segregate each record from Personal Details into each sheet. For example Laura(a2) had Make up(b2), so she needs to land in Make Up sheet, or Kate(a3) had manicure(b3) and has to be in Manicure sheet. Does anyone know what formula should be used, so it works when I add more records in Personal Details sheet? I hope you can understand my question. Thank you

 

[Robert Mika]

hi, I have this spread sheet Download file example.xlsx . What I trying to is segregate each record from Personal Details into each sheet. For example Laura(a2) had Make up(b2), so she needs to land in Make Up sheet, or Kate(a3) had manicure(b3) and has to be in Manicure sheet. Does anyone know what formula should be used, so it works when I add more records in Personal Details sheet? I hope you can understand my question. Thank you

Rapidgator is not the best place to post your workbook.(malware)
Try Dropbox or Google Drive

 

[krzysq]

Rapidgator is not the best place to post your workbook.(malware)
Try Dropbox or Google Drive

Im sorry. This time is on Google Drive: </br> https://docs.google.com/a/daniellis.co.uk/file/d/0B3Ec0mZkGQl-TGFTdERLOUE0R1U/edit?usp=sharing

thank you

 

[Robert Mika]

In each Sheet
A1:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
B1:
=IFERROR(INDEX('Personal Details'!$A$1:$A$7,SMALL(IF('Personal Details'!$B$1:$B$7=$A$1,ROW('Personal Details'!$A$1:$A$7)-ROW('Personal Details'!$A$1)+1),ROWS($A$1:A1))),"")
Confirm Contrl+Shift+Enter

 

[krzysq]

In each Sheet
A1:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
B1:
=IFERROR(INDEX('Personal Details'!$A$1:$A$7,SMALL(IF('Personal Details'!$B$1:$B$7=$A$1,ROW('Personal Details'!$A$1:$A$7)-ROW('Personal Details'!$A$1)+1),ROWS($A$1:A1))),"")
Confirm Contrl+Shift+Enter

everything works nice and smooth
thank you again

 

[Robert Mika]

everything works nice and smooth
thank you again

You are welcome