Nov 02 2022 12:46 AM
blr | egla | 5F | A | 1 |
blr | egla | 5F | A | 2 |
blr | egla | 5F | A | 5 |
blr | egla | 5F | B | 6 |
blr | egla | 5F | B | 7 |
blr | egla | 5F | B | 11 |
blr | egla | 5F | B | 12 |
blr | egla | 5F | B | 13 |
blr | egla | 5F | 234 | |
blr | egla | 5F | 254 |
in Excel, want to get the min and max result as below
blr | egla | 5F | A | 1 | 2 |
blr | egla | 5F | A | 5 | 5 |
blr | egla | 5F | B | 6 | 7 |
blr | egla | 5F | B | 11 | 13 |
blr | egla | 5F | 234 | 234 | |
blr | egla | 5F | 254 | 254 |
how to do it in excel summarize like above
Nov 02 2022 02:16 AM
Nov 02 2022 02:25 AM - edited Nov 02 2022 02:28 AM
@Jan Karel Pieterseit works for continues seat no. not for the discreet seat numbers
Nov 02 2022 02:33 AM