Date Formula

superfb

Board Regular
Joined
Oct 5, 2011
Messages
99
Hi


Can anyone help me think of a formula where if i have multiple dates in one column, the column next to it will differentiate it by putting - 2, -3,-4 for ex see below
col A Col B
2006070420060704
2006070420060704-2
2005122220051222
2005122220051222-2
2005120520051205
2005120520051205-2
2005120520051205-3

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
Try this:

=A1&IF(COUNTIF($A$1:A1,A1)>1,"-"&COUNTIF($A$1:A1,A1),"")
 

superfb

Board Regular
Joined
Oct 5, 2011
Messages
99
Thank you for the reply however this doesnt create the -1,-2,-3 if a date appears 3 times
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
If you have those values in column A and type the formula in B1 and drag it down then it does.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,906
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top