ExceLoki
Well-known Member
- Joined
- Dec 13, 2021
- Messages
- 542
- Office Version
- 365
- Platform
- Windows
i'm using google sheets for this.
the yes values are pulled in from another table to return if AA/Stainless has the corresponding gauge available.
what i'd like to do is using the drop downs in b12 & b13 return a list of row 1 that has a yes for the drop down values to show in B14. i would like to use unique and sort for the results. (hope that makes sense)
examples:
b12=18g & b13=AA , b14 would = 0 17/64, 0 1/4, 0 5/32, 0 1/8, 0 9/64, 0 5/16, 0 3/16, 0 9/32
b12=18g & b13= Stainless , b14 would = 0 1/4, 0 5/32
b12=16g & b13=AA , b14 would = 0 25/64, 0 3/8
Current formulas in use:
the yes values are pulled in from another table to return if AA/Stainless has the corresponding gauge available.
what i'd like to do is using the drop downs in b12 & b13 return a list of row 1 that has a yes for the drop down values to show in B14. i would like to use unique and sort for the results. (hope that makes sense)
examples:
b12=18g & b13=AA , b14 would = 0 17/64, 0 1/4, 0 5/32, 0 1/8, 0 9/64, 0 5/16, 0 3/16, 0 9/32
b12=18g & b13= Stainless , b14 would = 0 1/4, 0 5/32
b12=16g & b13=AA , b14 would = 0 25/64, 0 3/8
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |
1 | 0 25/64 | 0 17/64 | 0 1/4 | 0 5/32 | 0.106 | 0 1/4 | 0 5/32 | 0 1/8 | 0 9/64 | 0 5/16 | 0 3/4 | 0 3/8 | 0 3/8 | 0 1/4 | 0 5/32 | 0 3/16 | 0 3/16 | 0 9/32 | 0 5/32 | 0 7/64 | 0 3/32 | |
2 | Gauge | AA | AA | Stainless | Stainless | Stainless | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA | AA |
3 | 12g | yes | ||||||||||||||||||||
4 | 16g | yes | yes | yes | ||||||||||||||||||
5 | 18g | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | |||||||
6 | 19g | yes | ||||||||||||||||||||
7 | 20g | yes | yes | yes | yes | yes | ||||||||||||||||
8 | ||||||||||||||||||||||
9 | ||||||||||||||||||||||
10 | ||||||||||||||||||||||
11 | ||||||||||||||||||||||
12 | Gauge | 18g | ||||||||||||||||||||
13 | Material | AA | ||||||||||||||||||||
14 | Available ID | |||||||||||||||||||||
15 | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | ||||||||
16 | 0 17/64 | 0 1/4 | 0 5/32 | 0 1/4 | 0 5/32 | 0 1/8 | 0 9/64 | 0 5/16 | 0 1/4 | 0 5/32 | 0 3/16 | 0 3/16 | 0 9/32 | 0 5/32 | ||||||||
17 | 0 17/64 | 0 1/4 | 0 5/32 | 0 1/8 | 0 9/64 | 0 5/16 | 0 3/16 | 0 9/32 |
Current formulas in use:
b15 | =FILTER(B3:V7,A3:A7=B12) |
b16 | =if(B15="yes",B1,"") |
b17 | =unique(filter(B16:V16,B16:V16<>""),1,0) |