Image sample
I have to subtract the smallest value of the biggest value of about a thousand groups of values like the ones in the picture. For example, on group 58 I have to subtract the last value (biggest) from the smallest (the first one). An do th is a thousand times. Is there an automated way of doing this?
I played with the pivot table but I can’t get it to find the smallest and the biggest values of each group.
New contributor
Virginia Noel Fernandez Cano is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2