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:
