Hi,
I need a formula to create a reference number from the above value (reference number). I have to generate this number everyday for minimum of 10 records. I have written formula to get the reference number, but i have problem in copying to all the rows.
Based on the value of Column C the reference number should be generated in the Column E / F / G respectively.
Or
Is there any other formula to generate 03 types of reference number in one column, based on the value in Column C?
Note: I have attached an excel sheet for reference.
Bookmarks