unique code

Sir, I'm looking for a formula that generates the Date ID from Date value like below in mini sheet, I found a pattern using CountIF on A1&B1 that is 1/1/1900, I don't know how to use this pattern for 05.09.21(todays date) to get a Date like in the below cells. Thanks in advance Date ID...

Hi, I'm trying to sort unique entries in a list of data. Currently I know how to find what I want, which can be done by the following formula: (INT(MID(F8,SEARCH(", ",A2)+2,LEN(A2)-SEARCH(", ",A2)-4) However I want to configure it to find the value in column A and paste it in column C, but...

I need help to design a formula in excel to develop a unique random code, for example I have "Received" word in A1 cell then I want to get a unique Code in B1 cell, code should capture “R” from A1 cell then contain today’s current date like 011019 (01 day, 10 month, 19 year) then capture any...

I needhelp to design a formula in excel to develop a unique random code, forexample I have "Received" word in A1 cell then I want to get acode in B1 cell, code should capture “R” from A1 cell then contain today’s currentdate 011019 (01 day, 10 month, 19 year) then capture any random numerical...

I am trying to have the spreadsheet to Auto Generated an ID for me. I need this ID to Reference together 3 different Products into a Single Project. At the bottom I have included a link to a Sample Workbook & Picture. ENTERPRISE PROJECT A: (Composed of three different Products) MIL Site |...

I need to generate a CODE with the data from two cells for a project tracker, for instance: A1 = 24-10-2016, B1 = Adam Smith, My code in cell C1 should be "AS-1024", I have created this, But, If there are duplicate values in column C like, Consider Adam Smith and Aaron Swartz both got task on...