Excel-getting the extreme values of a data group

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
Nick's picture

here's my recommendation: 1.

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

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.