Bobbybazza
New Member
- Joined
- Mar 7, 2013
- Messages
- 5
Hi, is possible for a little help please. I'm looking to sort a simple data table by Column D and then display that data in groups with the Options from D as headings for the data that corresponds to them. Would this equate to a pivot table of some kind or is there an easier way? The output will not need to be manipulated after just displayed against this criteria. Hopefully this makes sense.
Output:
Test.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Reference | Name First | Name Last | Team | ||
2 | 1018717 | Alexandra | SMITH | AFC Bournemouth | ||
3 | 1018782 | Alison | JONES | Arsenal | ||
4 | 1018781 | Amanda | WILLIAMS | Aston Villa | ||
5 | 1019774 | Amelia | TAYLOR | Brentford | ||
6 | 1019776 | Amy | BROWN | Brighton and Hove Albion | ||
7 | 1019775 | Andrea | DAVIES | Chelsea | ||
8 | 1018658 | Angela | EVANS | Brentford | ||
9 | 1018659 | Anna | WILSON | Brighton and Hove Albion | ||
10 | 1018730 | Anne | THOMAS | Chelsea | ||
11 | 1018730 | Audrey | JOHNSON | Aston Villa | ||
12 | 1018703 | Ava | ROBERTS | Brentford | ||
13 | 1018704 | Bella | ROBINSON | Brighton and Hove Albion | ||
14 | 1018704 | Bernadette | THOMPSON | Brighton and Hove Albion | ||
15 | 1018704 | Carol | WRIGHT | Chelsea | ||
16 | 1018704 | Caroline | WALKER | Brentford | ||
17 | 1018724 | Carolyn | WHITE | Brighton and Hove Albion | ||
18 | 1018741 | Chloe | EDWARDS | Chelsea | ||
19 | 1018705 | Claire | HUGHES | Brentford | ||
20 | 1018710 | Deirdre | GREEN | Brentford | ||
21 | 1018708 | Diana | HALL | Brighton and Hove Albion | ||
22 | 1019342 | Diane | LEWIS | Chelsea | ||
23 | 1018941 | Donna | HARRIS | Arsenal | ||
24 | 1019383 | Dorothy | CLARKE | Aston Villa | ||
25 | 1018709 | Elizabeth | PATEL | Brentford | ||
26 | 1018925 | Ella | JACKSON | Brighton and Hove Albion | ||
27 | 1018775 | Emily | WOOD | Chelsea | ||
28 | 1018773 | Emma | TURNER | Arsenal | ||
29 | 1018771 | Faith | MARTIN | Aston Villa | ||
30 | 1018766 | Felicity | COOPER | Aston Villa | ||
31 | 1018768 | Fiona | HILL | Brentford | ||
32 | 1019007 | Gabrielle | WARD | Arsenal | ||
33 | 1018715 | Grace | MORRIS | Aston Villa | ||
34 | 1018711 | Hannah | MOORE | Brighton and Hove Albion | ||
35 | 1019778 | Heather | CLARK | Chelsea | ||
36 | 1018738 | Irene | LEE | Aston Villa | ||
37 | 1019112 | Jan | KING | Brentford | ||
38 | 1019345 | Jane | BAKER | Arsenal | ||
39 | 1018767 | Jasmine | HARRISON | Aston Villa | ||
40 | 1019022 | Jennifer | MORGAN | Aston Villa | ||
41 | 1019875 | Jessica | ALLEN | Brentford | ||
42 | 1018740 | Joan | JAMES | Brighton and Hove Albion | ||
43 | 1018606 | Joanne | SCOTT | Chelsea | ||
44 | 1018605 | Julia | PHILLIPS | Arsenal | ||
45 | 1019015 | Karen | WATSON | Aston Villa | ||
46 | 1019014 | Katherine | DAVIS | Brighton and Hove Albion | ||
47 | 1018723 | Kimberly | PARKER | Chelsea | ||
48 | 1018608 | Kylie | PRICE | Arsenal | ||
49 | 1018720 | Lauren | BENNETT | Aston Villa | ||
50 | 1018860 | Leah | YOUNG | Brentford | ||
51 | 1019021 | Lillian | GRIFFITHS | Brighton and Hove Albion | ||
52 | 1018737 | Lily | MITCHELL | Brentford | ||
53 | 1018728 | Lisa | KELLY | Brighton and Hove Albion | ||
Data |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A26 | Cell Value | duplicates | text | NO |
A26 | Cell Value | duplicates | text | NO |
A26 | Cell Value | duplicates | text | NO |
A26 | Cell Value | duplicates | text | NO |
A53 | Cell Value | duplicates | text | NO |
A53 | Cell Value | duplicates | text | NO |
A53 | Cell Value | duplicates | text | NO |
A53 | Cell Value | duplicates | text | NO |
A52 | Cell Value | duplicates | text | NO |
A52 | Cell Value | duplicates | text | NO |
A52 | Cell Value | duplicates | text | NO |
A52 | Cell Value | duplicates | text | NO |
A23 | Cell Value | duplicates | text | NO |
A23 | Cell Value | duplicates | text | NO |
A23 | Cell Value | duplicates | text | NO |
A23 | Cell Value | duplicates | text | NO |
A25 | Cell Value | duplicates | text | NO |
A25 | Cell Value | duplicates | text | NO |
A25 | Cell Value | duplicates | text | NO |
A48:A51 | Cell Value | duplicates | text | NO |
A48:A51 | Cell Value | duplicates | text | NO |
A48:A51 | Cell Value | duplicates | text | NO |
Output:
Test.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Reference | Name First | Name Last | ||||
2 | AFC Bournemouth | ||||||
3 | 1018717 | Alexandra | SMITH | ||||
4 | Arsenal | ||||||
5 | 1018782 | Alison | JONES | ||||
6 | 1018941 | Donna | HARRIS | ||||
7 | 1018773 | Emma | TURNER | ||||
8 | 1019007 | Gabrielle | WARD | ||||
9 | 1019345 | Jane | BAKER | ||||
10 | 1018605 | Julia | PHILLIPS | ||||
11 | 1018608 | Kylie | PRICE | ||||
12 | Aston Villa | ||||||
13 | 1018781 | Amanda | WILLIAMS | ||||
14 | 1018730 | Audrey | JOHNSON | ||||
15 | 1019383 | Dorothy | CLARKE | ||||
16 | 1018771 | Faith | MARTIN | ||||
17 | 1018766 | Felicity | COOPER | ||||
18 | 1018715 | Grace | MORRIS | ||||
19 | 1018738 | Irene | LEE | ||||
20 | 1018767 | Jasmine | HARRISON | ||||
21 | 1019022 | Jennifer | MORGAN | ||||
22 | 1019015 | Karen | WATSON | ||||
23 | 1018720 | Lauren | BENNETT | ||||
24 | Brentford | ||||||
25 | 1019774 | Amelia | TAYLOR | ||||
26 | 1018658 | Angela | EVANS | ||||
27 | 1018703 | Ava | ROBERTS | ||||
28 | 1018704 | Caroline | WALKER | ||||
29 | 1018705 | Claire | HUGHES | ||||
30 | 1018710 | Deirdre | GREEN | ||||
31 | 1018709 | Elizabeth | PATEL | ||||
32 | 1018768 | Fiona | HILL | ||||
33 | 1019112 | Jan | KING | ||||
34 | 1019875 | Jessica | ALLEN | ||||
35 | 1018860 | Leah | YOUNG | ||||
36 | 1018737 | Lily | MITCHELL | ||||
37 | Brighton and Hove Albion | ||||||
38 | 1019776 | Amy | BROWN | ||||
39 | 1018659 | Anna | WILSON | ||||
40 | 1018704 | Bella | ROBINSON | ||||
41 | 1018704 | Bernadette | THOMPSON | ||||
42 | 1018724 | Carolyn | WHITE | ||||
43 | 1018708 | Diana | HALL | ||||
44 | 1018925 | Ella | JACKSON | ||||
45 | 1018711 | Hannah | MOORE | ||||
46 | 1018740 | Joan | JAMES | ||||
47 | 1019014 | Katherine | DAVIS | ||||
48 | 1019021 | Lillian | GRIFFITHS | ||||
49 | 1018728 | Lisa | KELLY | ||||
50 | Chelsea | ||||||
51 | 1019775 | Andrea | DAVIES | ||||
52 | 1018730 | Anne | THOMAS | ||||
53 | 1018704 | Carol | WRIGHT | ||||
54 | 1018741 | Chloe | EDWARDS | ||||
55 | 1019342 | Diane | LEWIS | ||||
56 | 1018775 | Emily | WOOD | ||||
57 | 1019778 | Heather | CLARK | ||||
58 | 1018606 | Joanne | SCOTT | ||||
59 | 1018723 | Kimberly | PARKER | ||||
60 | |||||||
Output |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A30 | Cell Value | duplicates | text | NO |
A30 | Cell Value | duplicates | text | NO |
A30 | Cell Value | duplicates | text | NO |
A30 | Cell Value | duplicates | text | NO |
A59 | Cell Value | duplicates | text | NO |
A59 | Cell Value | duplicates | text | NO |
A59 | Cell Value | duplicates | text | NO |
A59 | Cell Value | duplicates | text | NO |
A58 | Cell Value | duplicates | text | NO |
A58 | Cell Value | duplicates | text | NO |
A58 | Cell Value | duplicates | text | NO |
A58 | Cell Value | duplicates | text | NO |
A27 | Cell Value | duplicates | text | NO |
A27 | Cell Value | duplicates | text | NO |
A27 | Cell Value | duplicates | text | NO |
A27 | Cell Value | duplicates | text | NO |
A29 | Cell Value | duplicates | text | NO |
A29 | Cell Value | duplicates | text | NO |
A29 | Cell Value | duplicates | text | NO |
A54:A57 | Cell Value | duplicates | text | NO |
A54:A57 | Cell Value | duplicates | text | NO |
A54:A57 | Cell Value | duplicates | text | NO |
Last edited by a moderator: