Get instant live expert help on I need help with group excel columns

to help complete the dependent drop-downs for all the list in prices tab for the 4 columns - Group, Sub-group, Test and method.

Hi - I have two columns - one is group and the other is user which looks something like this: Group A - User X Group A - User Y Group B - User Z I need to convert this to show all groups as a column and all users under the respective group like this: Group A GroupB User X User Z User Y

I performed autosum on a group of columns and got the answer. When i copied the command to another group of columns it gave me the same answer as the first command.

I want to group pivot table columns into sets

Hi, I have a table that shows a list of groups (group a, group b etc) and displays that there are 2 people in group 'a', 5 people in group 'b', 2 people in group 'c', 6 people in group 'd' etc... I would like to format/display the list show so it only shows the groups that have 2 or less people in each group... I am a complete excel novice.... Thanks you!