Thank you so much, dear. I guess it was bullet #1, as it worked completely after correcting it. ;)
And I Ioved the alternate options! :eek:o_O:oops::cool::p
Many-many thanks. :)
Yes dear. Exactly like that! But I don't understand if there is some formatting issue not helping me.
At first I copy-pasted the whole range from your file (E5:AI5) to my Excel in OneDrive where I am working this calendar, but it seems doing this brought your local configuration to my file, I...
Hi.
This is another version of a question I made too long ago...
I am building a calendar in the attached file.
You will find two (2) sheets in there:
1) One called "Matriz Nuevo Calendario" (where I will be feeding events from this year to the end of 2026)
2) And the other one titled...
Hola once again, Narayan.
Sorry for something else... Is there a way to make the formula return just a blank cell in B2 if the value in A2 is zero or different to those listed in column E at the D1:E20 array?
Hi guys. It's been a long time...
I recently heard from my hero, the very own mr. SirJB7 (our virtual Martín Fierro), that he has abdicated his way to the throne at Chandoo 2 or 3 years ago... I hope any of you in the line of succession can help me here with a very simple task, because it...
This is what happens to those who get to the 6000 posts milestone:
Watch out, guys... Any resemblance is not a coincidence...
At least there's evidence SirJB7 can dance like an urban-white-suited-bad-ass-ninja too.
Hi once more.
Using conditional formatting, how would you write a formula to highlight cells with values equaling zero (0) but not empty?
In the document at the following link, what I need is to highlight those cells filled with the value zero "0" (excluding empty cells and those cells...
Thanks, Narayan... Ok, sorry, but I still don't get it... I tried these, but none is still working:
=SUB!$C$3:INDEX(SUB!$C:$C;MATCH(REP("z";999999999999);SUB!$C:$C))
=SUB!$C$3:INDEX(SUB!$C:$C;MATCH(999999999999);SUB!$C:$C)
=SUB!$C$3:INDEX(SUB!$C:$C;SUB!$C999999999999;SUB!$C:$C)
Excel...
Hello.
I am unsuccessfully trying to set a dynamic range at the "C" column of the "SUB" worksheet in the document attached:
https://dl.dropboxusercontent.com/u/43577856/20130819_indicadores_part_chandoo.xlsx
This is the formula I used...
Yesterday was SirJB7's birthday... I'm a little worried he's been dissapeared all these days...To those of you who have been helped by this big hearted Excel Ninja, post your wishes here.
Feliz cumpleaños atrasado, panita, from Medellín. :-)
Hugs.
(And sorry, Chandoo. Just wanted to make...