Silverhorne
New Member
- Joined
- Feb 21, 2015
- Messages
- 42
- Office Version
- 365
- 2019
- Platform
- Windows
Good day all,
I have been watching a lot of videos from Mr. Excel himself and have learned a lot of good stuff. I am wondering if it is possible to use the Unique Choose formula if a cell on the same row contains a constant value.
I have extracted the unique values based on columns A and C combined in the example below, what I would like to do is only extract these unique values if column E="BW".
Columns B and D are columns with data that is not required and are placeholders, the results I am looking for are in G4:N5.
Maybe I am trying to use the incorrect approach?
I have been watching a lot of videos from Mr. Excel himself and have learned a lot of good stuff. I am wondering if it is possible to use the Unique Choose formula if a cell on the same row contains a constant value.
I have extracted the unique values based on columns A and C combined in the example below, what I would like to do is only extract these unique values if column E="BW".
Columns B and D are columns with data that is not required and are placeholders, the results I am looking for are in G4:N5.
Maybe I am trying to use the incorrect approach?
Mr Excel Help.xlsm | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | 20 | XXX | 11.9 | XXX | BW | 10 | 10 | 12 | 16 | 18 | 20 | 20 | 30 | |||
2 | 20 | XXX | 11.9 | XXX | BW | 12.7 | 15.9 | 9.3 | 12.7 | 15.9 | 11.9 | 12.7 | 15.9 | |||
3 | 16 | XXX | 12.7 | XXX | BW | |||||||||||
4 | 12 | XXX | 9.3 | XXX | SW | 10 | 16 | 18 | 20 | |||||||
5 | 16 | XXX | 12.7 | XXX | SW | 15.9 | 12.7 | 15.9 | 11.9 | |||||||
6 | 18 | XXX | 15.9 | XXX | BW | |||||||||||
7 | 20 | XXX | 12.7 | XXX | SW | |||||||||||
8 | 30 | XXX | 15.9 | XXX | FW | |||||||||||
9 | 30 | XXX | 15.9 | XXX | FW | |||||||||||
10 | 10 | XXX | 12.7 | XXX | FW | |||||||||||
11 | 10 | XXX | 15.9 | XXX | BW | |||||||||||
12 | 16 | XXX | 12.7 | XXX | BW | |||||||||||
Unique Choose |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G1:N2 | G1 | =TRANSPOSE(SORT(UNIQUE(CHOOSE({1,2},A1:A12,C1:C12)))) |
Dynamic array formulas. |