Conditional Filtering of ID Digits

There is an Excel file that teaches how to perform the Conditional Filtering of ID Digits operation.

Excel Format: Conditional Filtering of Id Digits

Extracting digits from ID codes and filtering them based on specific conditions is a frequently needed operation in data management. Additionally, this file applies mathematical conditions such as divisibility of the digit sum by 3 and the digit product by 4. Thus, two different solutions are provided using both the traditional INDEX/SMALL method and the dynamic FILTER function. However, the dynamic method combines LET, SEQUENCE, MMULT, and BYROW functions to create the shortest possible formula. Consequently, Excel 365 users can access all results with a single formula entered in one cell.

Hope it is useful.