Question #1 Fill up in a column

[Alphazulu]

I have data in column J, but have some blank cells that need to be filled in with data from the cell or multiple cells below the blank.

For example J6 contains "Open", J8 is blank, J7 is empty, J6 is empty, J5 Contains "closed".

I need to have "Open" fill in the blank cells J7 and J6 and then stop at J5 because the cell contains a value.

This type of scenario may occur several different times, with fewer or more blank cells between cells that contain a value. In all cases I need the cell with the value filling up until a cell contains a value.

Ideas?

Question #2 is how to reverse this situation (column C) Fill down with the value above a blank until a cell with a value.

 

[jbeaucaire]

Check your question and ask it again. It appears you have jumbled your cell references.

 

[Alphazulu]

--------------------------------------------------------------------------------
Reworded....it might actually make a little sense now.

I have data in column J, but have some blank cells that need to be filled in with data from the cell or multiple cells below the blank.

For example J9 contains the word "Open", J8 is empty, J7 is empty, J6 is empty, J5 Contains the word "closed".

I need to have the word "Open" fill in the empty cells J8, J7 and J6 and then stop at J5 because the cell contains the value "closed".

This type of scenario may occur several different times within Column J, with fewer or more blank cells between cells that contain a value. In all cases I need the cell with the value filling up until reaching a cell contains a value.

Ideas?

Question #2 is how to reverse this situation (column C) Fill down with the value above a blank until a cell with a value.

 

[Benjaminmin]

--------------------------------------------------------------------------------
Reworded....it might actually make a little sense now.

I have data in column J, but have some blank cells that need to be filled in with data from the cell or multiple cells below the blank.

For example J9 contains the word "Open", J8 is empty, J7 is empty, J6 is empty, J5 Contains the word "closed".

I need to have the word "Open" fill in the empty cells J8, J7 and J6 and then stop at J5 because the cell contains the value "closed".

This type of scenario may occur several different times within Column J, with fewer or more blank cells between cells that contain a value. In all cases I need the cell with the value filling up until reaching a cell contains a value.

Ideas?

Question #2 is how to reverse this situation (column C) Fill down with the value above a blank until a cell with a value.

If you make a new column next to it (column I), you can just fill it in like this
E.g. I8 would be: =if(J8="","Open",J8). -and then drag this up/down the whole column.

That should do the trick for you (and you can just hide column J afterwards)

 

[Alphazulu]

Ok...maybe my rewording was a little more accurate but I still missed a twist.

Down Column J were there are empty cells eventually followed by a cell with a value (in my first example; J9 contains the word "Open", J8 is empty, J7 is empty, J6 is empty, J5 Contains the word "closed") The values in "non-empty" cells is not always the same word.

Extending my original example
1. J9 contains the word "Open", J8 is empty, J7 is empty, J6 is empty, J5 Contains the word "closed")

2. J30 contains the word "Monday" J29 is empty, J28 is empty, J27 is empty, J26 is empty and J25 contains a value.

I need to fill empty cells above the cells with values throughout Column J where the cells with Values change throughout Column J......

Yikes.

 

[Jonmo1]

Highlight column J
Press CTRL + G
Special
Blanks
OK
Press =
Press DOWN Arrow (press down to fill from below, press up to fill from above)
Press CTRL + Enter

Hope that helps.

 

[Benjaminmin]

Ok...maybe my rewording was a little more accurate but I still missed a twist.

Down Column J were there are empty cells eventually followed by a cell with a value (in my first example; J9 contains the word "Open", J8 is empty, J7 is empty, J6 is empty, J5 Contains the word "closed") The values in "non-empty" cells is not always the same word.

Extending my original example
1. J9 contains the word "Open", J8 is empty, J7 is empty, J6 is empty, J5 Contains the word "closed")

2. J30 contains the word "Monday" J29 is empty, J28 is empty, J27 is empty, J26 is empty and J25 contains a value.

I need to fill empty cells above the cells with values throughout Column J where the cells with Values change throughout Column J......

Yikes.

In that case you could just change the formula i wrote above to:

(in column I)
I8: =if(J8="*",J8,"Open"). -and then drag this up/down the whole column.

That means that if there is any text in J8, it will keep that text, if its blank it will write Open

 

[Alphazulu]

Solved!!!! and with style I might add.....

Highlight column J
Press CTRL + G
Special
Blanks
OK
Press =
Press DOWN Arrow (press down to fill from below, press up to fill from above)
Press CTRL + Enter

 

[Jonmo1]

Glad to help, thanks for the feedback