Column down question

bullcreel

Board Regular
Joined
Aug 25, 2016
Messages
87
1578165922848.png

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
    1578165772330.png
    4.9 KB · Views: 2
  • 1578165843128.png
    1578165843128.png
    5.7 KB · Views: 2

Some videos you may like

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
Joined
Aug 25, 2016
Messages
87

ADVERTISEMENT

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,448
Office Version
  1. 365
Platform
  1. Windows

bullcreel

Board Regular
Joined
Aug 25, 2016
Messages
87

ADVERTISEMENT

Thank You so much
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,448
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
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","")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,513
Messages
5,548,492
Members
410,840
Latest member
Kar3ousse
Top