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):
- Combine the columns A,B,C: "Location/Category/Month"
- Read the whole table, count how many items have already been imported for the specific month, location & category, give me the right letter in alphabetical order. First read the month, then the location and last is the category.
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!
