This question is likely one someone has asked, but I couldn't find it easily. Therefore, if the answer already exists, please direct me to it.
In short, I have a sheet cataloguing individuals who sign up for an event based on first come, first served. However, due to limitations of the system we use, each individual is limited to one entry, but we want to ensure family members are included in the final tally. To determine family members, we ask families to use the same email. We have been using manual sorting functions, but there should be a means to automate this.
I used sortby to organize the arrays by date/time, but I want to ensure all the same email addresses are "nested" either vertically or horizontally for each email. For example, in the attached image, you can see that aridy@mbx.c (J2 and J4) have a value between them. I don't want to ignore that value, I just want to move J4 between them. Worse yet, take Laura@mbx.c (J18, J24, and J26). Now, I have to keep the rows together, because in the end I want to determine each member with that email (column "First").
To further clarify, I want to sortby the column not alphabetically but by each email in order grouping them together. In the attached, all aridy@mbx.c would go first (Mason and Ariana in E2 and E3 respectively), followed by all Ohora@mbx.c (Jennifer in E4 and Charles K. in E5), followed by Zende@mbx.c (Saul in E6), etc.
I cannot use pivot tables or VBA due to system limitations.
(In the attached columns are hidden and mock data is used to preserve privacy only.)
I appreciate any help you can provide.
In short, I have a sheet cataloguing individuals who sign up for an event based on first come, first served. However, due to limitations of the system we use, each individual is limited to one entry, but we want to ensure family members are included in the final tally. To determine family members, we ask families to use the same email. We have been using manual sorting functions, but there should be a means to automate this.
I used sortby to organize the arrays by date/time, but I want to ensure all the same email addresses are "nested" either vertically or horizontally for each email. For example, in the attached image, you can see that aridy@mbx.c (J2 and J4) have a value between them. I don't want to ignore that value, I just want to move J4 between them. Worse yet, take Laura@mbx.c (J18, J24, and J26). Now, I have to keep the rows together, because in the end I want to determine each member with that email (column "First").
To further clarify, I want to sortby the column not alphabetically but by each email in order grouping them together. In the attached, all aridy@mbx.c would go first (Mason and Ariana in E2 and E3 respectively), followed by all Ohora@mbx.c (Jennifer in E4 and Charles K. in E5), followed by Zende@mbx.c (Saul in E6), etc.
I cannot use pivot tables or VBA due to system limitations.
(In the attached columns are hidden and mock data is used to preserve privacy only.)
I appreciate any help you can provide.
