11-13-2019 03:28 PM
11-13-2019 03:28 PM
11-13-2019 03:44 PM
12-05-2019 02:21 AM
@Celia_AlvesThankyou for this
12-05-2019 02:55 AM
First of all, unmerge the columns F and G if they are merged and then try the following Array Formula (which requires confirmation with Ctrl+Shift+Enter instead of Enter alone) in F2 and copy it down as per your requirement.
Confirm the above formula with Ctrl+Shift+Enter. When you confirm a formula as an Array Formula, you will notice in the formula bar that your formula gets surrounded by curly braces.
So as per the formula if you input 1 in F1, you will get all the names where column D has 1 and if you input 2, you will get all the names where column D has 2.
Adjust the range reference in the formula as per your requirement.
Note: Please consider uploading an Excel file instead of an image as images are difficult to work with. The advantage of an Excel file is, we can implement the working solution in your file and send back to you.
12-05-2019 04:32 AM
@Subodh_Tiwari_sktneerHiya, thankyou for this.
I'm still struggling with it, I really need to brush up! I have attached the document if you are able to implement the working solution in the file please that would be fantastic?! I literally just need the first and last name to appear under the table number headings when a corresponding number is typed in D2.
There are still names to go on the sheet so I have extended the range.
Many Thanks in advance
12-05-2019 05:25 AMSolution
Please find the attached with the formulas in place. You only need to enter the table number in column D and the names will be populated in the relevant table automatically as per the entered number.
Also, note that I have added a custom number formatting for all the table headers (green cells) so that they contain only a number but a prefix of Table is added to all of them. e.g. if you look at the cell F1, it contains a number 1 but the cell shows you the text "Table 1" where the "Table" prefix is added through the custom number formatting whereas the actual cell content is only 1.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.