estatefinds
07-15-2016, 01:24 PM
I have data in columns AB the contain dates in order from top row 20 to bottom of worksheet. in column AC it just numbers them in how many dates I have entered into column AB. In column AA this will be the result after the macro is run.
So I need a macro that will look at the date for example: in column AB row 20 is 04/17/2015 there is only one of these in column AB so a number one placed to the left in column AA row 20 1. the macro will keep running ac ount as in the excel sheet and the macro will see that the 04/28/2015 is entered twice the macro will recognize this and skip to the second 04/28/2015 and continue counting and place a 9 to the second 04/28//2015 down in the column and so on. if you have any questions please ask, also I will be adding data to the column AB so the macro needs to be AS LONG
Thank you in advance for your Help!
So I need a macro that will look at the date for example: in column AB row 20 is 04/17/2015 there is only one of these in column AB so a number one placed to the left in column AA row 20 1. the macro will keep running ac ount as in the excel sheet and the macro will see that the 04/28/2015 is entered twice the macro will recognize this and skip to the second 04/28/2015 and continue counting and place a 9 to the second 04/28//2015 down in the column and so on. if you have any questions please ask, also I will be adding data to the column AB so the macro needs to be AS LONG
Thank you in advance for your Help!