SharePoint List - Advanced Formula - 3 Criteria

Occasional Visitor

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  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:

MonthLocationCategoryThe unique code should be
Jul-21Loc1Cat2Loc1/Cat2/0701/A
Jul-21Loc1Cat2Loc1/Cat2/0701/B
Jul-21Loc1Cat2Loc1/Cat2/0701/C
Jul-21Loc1Cat2Loc1/Cat2/0701/D
Jul-21Loc1Cat3Loc1/Cat3/0701/A
Jul-21Loc2Cat2Loc2/Cat2/0701/A
Aug-21Loc1Cat2Loc1/Cat2/0801/A

 

Your help will be much appreciated!

 

Thank you!

0 Replies