PDA

View Full Version : Compare the values in the column and display the results in another column



Tharabai
07-09-2015, 10:51 AM
Hi

Am new to macros and hope some one will help me with my requirement.

Below are the details of my requirement.

1. Two columns start date and end date (column H and I)
2. column with Type (column M)

Criteria 1 :

Same start date and end date in different rows with different type
eg. 12.13.2015 to 12.16.2015 with type "Credit1"
12.13.2015 to 12.16.2015 with type "Credit2"
12.13.2015 to 12.16.2015 with type "Credit3"
12.13.2015 to 12.16.2015 with type "Credit4"

For all these the criteria should be "same date with different type" in Column P


Criteria 2 :


Different dates with same type, then the criteria should be "Different date with same type" in column Q


Can this be done using VBA.
Immediate response for this is highly appreciated.

Thanks,
Tharabai

excelliot
07-10-2015, 06:36 AM
can you share all this in excel file for better understanding..

Tharabai
07-13-2015, 03:11 PM
Hi, Attached is the file for the reference..

Aussiebear
07-13-2015, 03:51 PM
Have you considered using filters to find this data?

Tharabai
07-13-2015, 10:10 PM
As of now I use filter in ID, Dates and Type to manually enter the comments. The ID column also should be considered.

For the particular ID, Same dates with different type and different dates with same type in column Q.