Dec 13 2021 12:26 AM
Hello,
I need to use a SharePoint list instead of an excel and I can't find a way to write the following formula. In the excel I use VBA. The case is:
Each user will import the following data: Column A: Month/Year Column B: Location (text) Column C: Category (text)
Column D: unique code (formula):
For example, the result of the unique code (col D) should be:
Month | Location | Category | The unique code should be |
Jul-21 | Loc1 | Cat2 | Loc1/Cat2/0701/A |
Jul-21 | Loc1 | Cat2 | Loc1/Cat2/0701/B |
Jul-21 | Loc1 | Cat2 | Loc1/Cat2/0701/C |
Jul-21 | Loc1 | Cat2 | Loc1/Cat2/0701/D |
Jul-21 | Loc1 | Cat3 | Loc1/Cat3/0701/A |
Jul-21 | Loc2 | Cat2 | Loc2/Cat2/0701/A |
Aug-21 | Loc1 | Cat2 | Loc1/Cat2/0801/A |
Your help will be much appreciated!
Thank you!