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
Attachment | Size |
---|---|
Allotment.xlsx | 8.94 KB |
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.