Identifying Range of Different Duplicate Values
An example workbook is attached.
Background: I have four columns of data (a,b,c,d) of very long row length. The data in column A starts with letters, is continous and has numbers and is organized alphabetically. There are many different, duplicated values in column A. All duplicated data appears together, in order. Columns b,c,d have only text data.
Need:I need a macro to identify the row range for each distinct duplicate value in A. Using that range, the macro needs to then look at column D and count the number of times that each text value appears, then paste that data into a separate sheet "Step 2"
Last edited by stonegwene; 10-07-2011 at 10:27 PM.
Re: Identifying Range of Different Duplicate Values
A quick way is via a pivot table. Add a header row, put col A in the row field, D in the column field and (count of) D in the data field.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1