Sorting, finding dulicates, moving one data element up, deleting original data

Please can you post an Excel file?

I only have excel 2003 for mac.. sorry. This gives me such tired head syndrome...

One more question: if a given value in A has the same value repeated in B do you only want it shown once?

yes. The numbers in B are actually page numbers, so exact duplicates would be eliminated

maybe what I am wanting can't be done in a macro?

No, it can be done. I will try to look later today if nobody else has in the meantime.

Thanks. I really appreciate it. I can pay some via paypal also.

Ok,try this. Thanks for the offer, but it's a free forum.

Please Login or Register  to view this content.

Excel does not like the "Sub x()" says "compile error: can't assign to array"

Which line?

The top line has a yellow arrow to the left and "Sub x() is highlighted in yellow, but it also highlights the beginning of the fourth line "vinput" in blue.

It worked for me on your sample, have you tried it on that?

Actually, I couldn't figure out on the newer version of excel that saved the sample in how to get the macro to run, I tried on my older mac and excel... maybe that's the issue.

In excel 2001 for mac the visual basic window is accessible under "customize", can't figure out how to save the code into a Macro under Excel 2008 for mac... I'm an idiot obviously

Seems Microsoft disabled VBA macros ability after 2004 for mac users. I'm screwed, Not a PC in sight. The entire file is 700k... I could email it... (I'm asking sheepishly, hate to impose)

Ah, I didn't realise you were using a Mac. What do you want me to do, run the code on a file as a one-off? I can do that, and you can post a file that size on the forum (and remove later I think if you want). Not sure what you can do in future though.

I'm pretty sure this is a one time catalog for this client, so nothing in the future (they are so short sighted and prices so high compared to competitors).

Not sure this attachment will post or not...?

Had to zip it but seems ok. Output on 1st sheet, original data on second.

Wow. That's so close, I should have mentioned that once the page numbers are moved up and gathered together that should be in low-high order, i.e. 105, 49 should be 49, 105... any chance this is an easy fix?

Quickest way is to sort the data first.

Wunderbar and Eureka! If you ever need a logo designed, it's on me.

Please don't hate me, client requested I add a satellite catalog to the TOC, it all needs be sorted again - together.. can you do this one more time? And please, if you need anything graphically designed, don't be afraid to ask. You probably don't get paid back enough for what you do. Rick