The formula has to be input on cell A2. The logic should be that the formula would result in the following cell (from cell A3 downwards) outputting a no. in a reversed numbered list format in column 1. And for those who are "Resigned" or "Dismissed" in column 3, the formula would skip them and the next numbering would be a follow-up from the previous no. instead.
We're using in-house software that's similar to Google Sheets and Microsoft Excel so certain functions/formulas like REGEX and custom functions are not supported.
| No. | Name | Employment status |
|---|---|---|
| (insert formula here | Sample Name | Type of Employment |
| 5 | John | Full-time |
| Mary | Resigned | |
| 4 | Jack | Part-time |
| 3 | Tim | Contract |
| Jane | Dismissed | |
| 2 | Jonathan | Full-time |
| 1 | Larry | Part-time |
This post is a repost from this 
CodePudding user response：
Paste this formula in A2
= {"Count" ; ArrayFormula(IFNA(IF(B3:B="",,VLOOKUP(B3:B, FILTER({ B3:C, SEQUENCE(ROWS(B3:B),1,COUNTA(B3:B),-1) }, C3:C<>"Resigned",C3:C<>"Dismissed"),3,0)),""))}
