PDA

View Full Version : similar dates for same value for same period, write in same cell, and remove dups



ertan
03-30-2006, 03:39 AM
Hello all,

I desperately need help:

On worksheet

Product: dates, periods and values written as column wise.

I would like to find out that if there are same dates for same periods and same values

Then

Put them in same row (same cell) and remove the duplicate ones.
(With many product and many dates list gets longer and longer and unreadable.)

I cannot use pivot tables, because at the end I have to mail these sheets with certain format.

Just for the example I remove the columns after column C. (in real there are columns goes up to column O)


Thank you for your help


PS : Column A dates are not real dates they are text values. (But if help can be changed)

Bob Phillips
03-30-2006, 04:27 AM
Try this

ertan
03-30-2006, 04:50 AM
Thank you for fast reply..

It works as perfect as it is.(as usual:) )

But I think I misguide you by how I asked my question.
(I am sorry it is just a language problem)

I would like to do this for each Product section.. Current code checks entire column A and produce the results. Unfortunately every Product title
Have its own dates - periods and values.

What I mean is it should do this in each change of the product name..

Product Something
(Process...)

Product something else
(Process..)

Perhaps blank rows can be use for separator marks?

I really glad for your help , if you could looked it the way I try to describe I appreciated.

Regards
Ertan

ertan
04-01-2006, 08:42 AM
Is there a way to modify XLD's code to work with only selected rows?

Process and copy to Results to "Results sheet" column "A" lafter last filled row?

Thank you

Bob Phillips
04-01-2006, 10:05 AM
Lost track of this one. Do you want to process blocks as per the original requirement, or selected rows as now stated? If the latter, how are they selected?

ertan
04-02-2006, 11:14 PM
Thanks for the replay,

I like to process blocks as my first request, but with the code provided
I am not able to achieve the desirable result.

Works perfect if there is a only one product...
But I have several products on same sheet (given example file they indicated red colored titles and each product there is a 1 blank row)

I cannot mix-match one product values to one each other .. It should be done for each product seperatly ..

Basic Requirement:

For each product if there are same values (colum C ) and those values
are same periods (column B) , dates (column A) should be written as:

example: 24.04,27.04,04.05 etc..

and matching rocord rows should be deleted..


Attached small example Current and Results

Thanks

Bob Phillips
04-03-2006, 02:06 AM
New attempt

ertan
04-03-2006, 04:01 AM
Thank you Xld,

I test (limited) the code with real data , it worked all product on test sheet ,except one product. (didnt worked as intended)

Very strange ..now I have to test for all product sheets if results are ok.

Thank you very much for your time and effort..


Regards


Attached : failed product , if you have time please have a look at it
perhaps something is right in front of my eyes but I cannot see.
I marked failed sections.

Bob Phillips
04-03-2006, 04:19 AM
I only matched on one column, the DBL, not the days as well, that is why.

I will need to look at this later, no time now.

ertan
04-03-2006, 04:54 AM
Understand , thank you..


Regards