Home

Creating ID based on numerous cell content

%3CLINGO-SUB%20id%3D%22lingo-sub-469333%22%20slang%3D%22en-US%22%3ECreating%20ID%20based%20on%20numerous%20cell%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-469333%22%20slang%3D%22en-US%22%3E%3CP%3EHiya%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20generate%20a%20running%20ID%20(being%201%2C%202%2C%203%20etc)%20based%20on%20column%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20ID1%20to%20read%201%20for%20the%20first%20Shot%20%23%20read%20according%20to%20the%20date%20(01%2F04%2F2019).%20Then%202%20for%20the%20next%20unique%20shot%20%23%20read.%20Every%20shot%20%23%20on%20any%20given%20date%20will%20have%20the%20same%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20then%20needs%20to%20apply%20to%20ID2%20but%20based%20on%20the%20Product%20adjacent%20to%20the%20shot%2Fdate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20below%20table%20is%20how%20I%20would%20like%20to%20ID's%20to%20read%2C%20I%20just%20need%20the%20ID's%20to%20generate%20themselves%20rather%20than%20be%20populated%20by%20manual%20input...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDate%3C%2FTD%3E%3CTD%3EID1%3C%2FTD%3E%3CTD%3EShot%20%23%3C%2FTD%3E%3CTD%3EID2%3C%2FTD%3E%3CTD%3EProduct%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F04%2F2019%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E100200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F04%2F2019%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E100200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F04%2F2019%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EDEF%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E100200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F04%2F2019%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EDEF%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E300400%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F04%2F2019%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E200100%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F04%2F2019%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E200200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F04%2F2019%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EGHI%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E200200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F04%2F2019%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EGHI%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E400500%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F04%2F2019%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EDEF%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E200200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F04%2F2019%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E300400%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-469333%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
El1-_321
Occasional Contributor

Hiya,

 

Does anyone know how to generate a running ID (being 1, 2, 3 etc) based on column information?

 

I need ID1 to read 1 for the first Shot # read according to the date (01/04/2019). Then 2 for the next unique shot # read. Every shot # on any given date will have the same ID.

 

This then needs to apply to ID2 but based on the Product adjacent to the shot/date.

 

The below table is how I would like to ID's to read, I just need the ID's to generate themselves rather than be populated by manual input...

 

DateID1Shot #ID2Product
1/04/20191ABC1100200
1/04/20191ABC1100200
1/04/20192DEF1100200
1/04/20192DEF2300400
1/04/20191ABC2200100
2/04/20191ABC1200200
2/04/20192GHI1200200
2/04/20192GHI2400500
2/04/20193DEF1200200
2/04/20191ABC2300400

 

Thank you :)

 

@Twifoo

@Sergei Baklan 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies