Image sample
I have to subtract the smallest value from the greatest value of about a thousand groups of values like the ones in the screenshot. For example, for group 58 I have to subtract the first value (the smallest) from the last (the greatest). And do this a thousand times. Is there an automated way of doing this?
I played with the pivot table but I couldn’t get it to find the smallest and the greatest values for 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