Originally Posted by
mperrah
ok, So what if we run the script to combine all matching company numbers and remove the duplicates,
then start another pass that then checks for duplicate addresses
where would this account number get moved too?
add a new column at the end of the row?
or insert a new one next to the pricing type (Normal/Discount/Gov)
If you know in advance how many duplicates there will be we can format the sheet prior to running the script and have the pricing data adjacent,
If you wont know how many duplicate address' may occur we can add a new column to the end of the row, regardless of how many.
I like being able to account for all possible situations, your RealSample is laid out different then I expected,
If you know what needs to go where we can help with the heavy lifting.