Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello from Steved
Below I've Columns A,B,C, What I would like please is a formula the would find the Duplicates, if none found the put the number 1 in Column D, If Dupicates found then goto the first put in 1 then the second Duplicate put in 2, if a third found then put in 3, if a fourth is found then put in 4 and so on. for example if There is 8 duplicates found then I will see 1,2,3,4,5,6,7,8 in D1, I will see 1 D2, I will see 2 in D3 I will see 3 and so on. 30/07/2007 1004 15:30 31/07/2007 1004 15:30 1/08/2007 1004 15:30 2/08/2007 1004 15:30 30/07/2007 1005 15:30 31/07/2007 1005 15:30 2/08/2007 1005 15:30 3/08/2007 1005 15:30 30/07/2007 1007 15:20 30/07/2007 1007 15:20 31/07/2007 1007 15:20 31/07/2007 1007 15:20 1/08/2007 1007 15:20 2/08/2007 1007 15:20 2/08/2007 1007 15:20 3/08/2007 1007 15:20 Thankyou. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
filler | New Users to Excel | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) | |||
Excel cell filler for word merge document | Excel Discussion (Misc queries) |