Hi
using excel XP...
am trying to use a macro to exclude duplicate cases, as can't seem to permanently do so with adv filter>exclude duplicates etc despite copying to another data sheet etc.
Data example:
ID Age INR blood result
2 83 2.4
2 83 2.9
2 83 1.9
2 83 5
3 70 3.8
3 70 4
3 70 8
3 70 3
I...