1. Select a cell where you want to display the maximum value for each group.
2. Type the following formula: =MAXIFS(Value, Group, "group_name")
3. Replace "Value" with the column name where your values are located (in this case, it's "Value").
4. Replace "Group" with the column name where your group names are located (in this case, it's "Group").
5. Replace "group_name" with the name of the group you want to find the maximum value for (e.g. "A" or "B").
6. Press Enter to calculate the maximum value for that group.
7. Repeat steps 2-6 for each group name.

For example, if you want to find the maximum value for group A, your formula would be: =MAXIFS(Value, Group, "A"). If you want to find the maximum value for group B, your formula would be: =MAXIFS(Value, Group, "B").

This formula will automatically adjust to accommodate varying amounts of data in each group, so you don't need to worry about specifying a range of cells.