I have several columns each with numbers and blank spaces I like that I could sum this columns horizontally and make a total column and that the result of blanks sum still blank, that because each rows refers to a code, so I need to keep blanks and just sum horizontally.
So I made a conditional, it works fine, however I like to go by with contrl+down so I can stop at each existence, but since there is conditional it take me from beggining to end of column without stoping at numbers.
I ctrl+c ctrl+v the hole column and just pasted values, the conditional is gone, the blank cells look blank but excel recognizes them as constants, meaning ctrl+down stiil take me from begining to end.
Sorry for my eanglish, I already posted this same question in spanish, just hoping to recibe a faster answer.
thx
So I made a conditional, it works fine, however I like to go by with contrl+down so I can stop at each existence, but since there is conditional it take me from beggining to end of column without stoping at numbers.
I ctrl+c ctrl+v the hole column and just pasted values, the conditional is gone, the blank cells look blank but excel recognizes them as constants, meaning ctrl+down stiil take me from begining to end.
Sorry for my eanglish, I already posted this same question in spanish, just hoping to recibe a faster answer.
thx
