Hey all,
Title says it all! Here's what I'm trying to do! Let me know if this can be done! TIA!!
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
If G3:K3 is blue count it. If qty is 3, G11=a number, 4=another number…
OR if P3 and G3:K3 is blue and qty is >=2, G11=this number
<tbody>
</tbody>
Title says it all! Here's what I'm trying to do! Let me know if this can be done! TIA!!
G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|
4 | Blue or not |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
OR if P3 and G3:K3 is blue and qty is >=2, G11=this number
G | |
---|---|
11 | Some Num |
<tbody>
</tbody>
Sheet2
Last edited: