Home » Forums » Open Source Learning Center » Question and Answer

Excel-getting the extreme values of a data group

Submitted by A Kumarsreenivas on 17 October, 2012 - 02:11

Help me out in getting the beginning value and ending value for a given data set from a spread sheet containing multiple data sets.

I have Document numbers in column-A and Operators in Column-B.
I have allotted x no. of documents to each Operator.
Now each operator has unique range of documents to work with.
Please let me know if there is any way to get the beginning Document number and ending Document number (Document range)of each Operator.

Find the uploaded attachment with this scenario.

Thanks & Regards
Kumar

AttachmentSize
Allotment.xlsx8.94 KB
‹ Templates - not working Find text inside cells and sum their data ›
»
Nick's picture

here's my recommendation: 1.

Submitted by Nick on 17 October, 2012 - 12:35.

here's my recommendation:

1. Remove the text from col 1 (leaving the numbers)
2. Insert a pivot table
3. Pivot on the Name as the row field
4. Add Min and Max of file name as the data fields

»

Excel-getting the extreme values of a data group

Submitted by A Kumarsreenivas on 17 October, 2012 - 20:24.

Thank you for the response Nick.

I have tried the recommended steps by you and am now able to get the Min and Max values of a document range allotted to an operator.

Regards
Kumar.

»