I have a spreadsheet that I need to pull certain information from. This spreadsheet has thousands of rows.
I want to make a seperate sheet for each candidate. So for example, I have created a sheet for Farah Noor.
I want to be able to pull off each Contract reference number from my main spreadsheet and list them all here, I also would like it if there were no duplicates.
Can someone tell me the formula I would need to use to pull this data?
Thanks.
![Capture1.jpg](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2FmnKWcR%2FCapture1.jpg&hash=d12a85855dd34ee8e7c37df76214a910)
I want to make a seperate sheet for each candidate. So for example, I have created a sheet for Farah Noor.
![Capture2.jpg](/board/proxy.php?image=https%3A%2F%2Fimage.ibb.co%2FeJnsHR%2FCapture2.jpg&hash=8417a512f6b0d404748ac88c5d0a5daa)
I want to be able to pull off each Contract reference number from my main spreadsheet and list them all here, I also would like it if there were no duplicates.
Can someone tell me the formula I would need to use to pull this data?
Thanks.