# Column down question

#### bullcreel

##### Board Regular

Here is my question.
1. Cells K1 and Q1 value can change.
2. I need the "tc", "tc" in column 'O' to move to cells 'O5 and O6' so that it falls after the HRs in column 'J', they cannot be in the same row.
3. If column 'J' HR changes to only 2 then the "tc" would then have to go into cells O4 and O5.

I hope this makes sense.
Thank You in advance for the help

#### Attachments

• 1578165772330.png
4.9 KB · Views: 2
• 1578165843128.png
5.7 KB · Views: 2

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### bullcreel

##### Board Regular
Thank You so much...now I need to apply this to the next column moving right.

#### bullcreel

##### Board Regular

So lets say I wanted to do the same thing for column V, how do I add in another countif.

#### bullcreel

##### Board Regular

Thank You so much

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback

#### DanteAmor

##### Well-known Member
So lets say I wanted to do the same thing for column V, how do I add in another countif.
Here my approach

Book1
AIJKLMNOPQRSTUVWX
1HR303B23C4
21HR1 1
32HR2 2
43HR3 3
54 4tc4
65 5tc5
76 6 6other
87 7 7other
98 8 8other
109 9 9other
1110 10 10
1211 11 11
1312 12 12
1413 13 13
1514 14 14
1615 15 15
1716 16 16
sheet
Cell Formulas
RangeFormula
J2:J17J2=IF(I2<=\$K\$1,\$J\$1,"")
O2:O17O2=IF(AND(COUNTIF(\$O\$1:O1,"tc")<\$Q\$1,J2=""),"tc","")
V2:V17V2=IF(AND(COUNTIF(\$V\$1:V1,"other")<\$X\$1,O2="",J2=""),"other","")

Replies
7
Views
153
Replies
11
Views
221
Replies
0
Views
212
Replies
1
Views
44
Replies
4
Views
74