Recent content by 6tel

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...

Thanks, dear Narayank991:)... I know it's been ages:eek: (I forgot about this pending topic I had here). :(

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?

Exactly like it!! Many thanks, Narayank991!!! :):):)

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.

Nice! Thank you very much, Narayan.

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...

Guess I found it: =SUB!$C$3:INDEX(SUB!$C:$C;MATCH(999999999999;SUB!$C:$C))

Tried this too, but didn't work: =SUB!$C$3:INDEX(SUB!$C:$C;999999999999;SUB!$C:$C)

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...