Got my last problem figured out, thanks all, now i realize there is another issue.
as stated in a previous post, say i have a list of a lot of different purchase order numbers.
now say i may have 6 lines with the same purchase order.
now say each purchase order has 3 columns next to it. Sometimes there is a number in A, Sometimes B, and sometimes C. sometimes that number is Negative. C is the best choice (most accurate) B is my second pref, and A last choice.
now, when i import this list, i can make the macro to auto sort, no prob. I can also get it to find duplicates.
But to get it to run through the duplicates, and do something like =if(c1=0,"repeat for b, then a" else return value in c) obviously not with that exact text, but my mind is fried.
ID A B C
xxxyyyaaa 121.3 00 00
xxxyyybbb 000 22 00
xxxyyyaaa -121.3 00 000
xxxyyyccc 000 10 0
xxxyyyaaa 120.5
is a rough picture of what im looking at, out of that i would want to see
xxxyyyaaa 120.5
xxxyyybbb 22
xxxyyyyccc 10
im going to work on this at home, but im a little lost on where to start on this one, i know its going to be a macro that runs a string of if then statements, but how to make that cycle only through matching ID's, then repeat for the next matching id, in a specified range (i can do that manually) yeah i dont know.
Any help would be great.
Thanks
Bookmarks