Forum Discussion
kerry590
Jan 19, 2022Copper Contributor
Filtering out account codes based on other data
In my spreadsheet tab 1 "Codes" shows a list of "INT" & "MIN" codes with their corresponding name for each item. Beside them I have ten columns for account codes 1-10. On tab 2 "Codes Used" is a list...
mtarler
Silver Contributor
kerry590 here is the formula and fill down:
=TRANSPOSE(UNIQUE(FILTER('Codes Used'!C:C,(A2='Codes Used'!A:A)*(B2='Codes Used'!B:B),"")))
see attached
kerry590
Jan 19, 2022Copper Contributor
Interesting, is the transpose function how you get it into the other fields without having a formula? I have never seen something like this before.
- mtarlerJan 19, 2022Silver Contributorin response to how both Sergei's and my formula works is basically filtering the list for only rows that have both the INT and MIN values that are the same as the INT and MIN values on the corresponding line. The UNIQUE then filters out duplicates and the TRANSPOSE changes it from rows to columns.