VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
Excel Fill Down IF - My Online Training Hub

Excel Fill Down IF - My Online Training Hub

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Excel Fill Down IF - My Online Training Hub Excel doesn't have a way to specify criterial in the Fill tool, but I have a clever workaround using Go To Special and an IF formula Sotirios: how can I fill down a value until a cell with a speciffic value? e.g. from A1 to A23. A1 contains a word & A23 contains a new word. I want to sto filling to A22. Between A1 & A23 THERE ARE BLUNK & NO BLUNK CELLS with deferent VALUES (words)
Date: 2022-04-08

Comments and reviews: 5


i need to fill the same number to the down until it reach to the the cell contain another number and so on and on... how i can do this by formula without doing ctrl+D to individual cell go to downward in more than 9000 rows..?
reply

Thank you for providing such information for a poblem of which i thought it didn't have a solution. My extra question is if this is also possible to do within Power Query, because that would save a lot of time as well.
reply

i had more than 2000 rows, that needed to fill manually, but, this video saved my FRIDAY!, thanks a lot for sharing your knowledge with us!
reply

I just started seriously watching your videos and I learn something new each time. It's like I'm the excel sorcerer's apprentice :)
reply

Thanks Mynda, your collective tips over the last several months have really improved my efficiency when working with excel!
reply
Add a review, comment






Other channel videos