Macro to display list of unique data from spreadsheet

**paulcresswell** · 02-04-2009, 08:18 AM

Hi,

Im trying to get some info from a spreadsheet automatically using a macro but after 2 weeks i have to beg for help.

Im trying to display each unique reg number from col "reg" from cell t1 onwards. In cell t2 onwards i want to put the difference between the highest value in the "odo" column and the lowest for each reg.

any help or pointers would be a great help.

PC

**royUK** · 02-04-2009, 08:37 AM

Use Advanced Filter -> unique records only

**paulcresswell** · 02-04-2009, 08:53 AM

Originally Posted by royUK

Use Advanced Filter -> unique records only

Thanks roy, that has helped me with the unique reg value. Any idea how i can acheive the second part?

PC

**rasonline** · 03-08-2009, 05:10 AM

here's a solution for you.
1. use advanced filter to get unique reg nrs.
2. paste the reg nrs. to be column headers.
3. used if formula to pull odo readings relating only to those reg nrs.
4. used max and min formulas to work out the diff that you're looking for.