• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by 6tel

  1. 6

    Display value on cell according to values on other table/array (Reloaded)

    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. :)
  2. 6

    Display value on cell according to values on other table/array (Reloaded)

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

    Display value on cell according to values on other table/array (Reloaded)

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

    Display value on cell according to values on other table/array

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

    Display value on cell according to values on other table/array

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

    Display value on cell according to values on other table/array

    Exactly like it!! Many thanks, Narayank991!!! :):):)
  7. 6

    Display value on cell according to values on other table/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...
  8. 6

    Congrats to SirJB7 - 6000 posts

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

    Highlight cell when equal to zero value but not empty [SOLVED]

    Nice! Thank you very much, Narayan.
  10. 6

    Highlight cell when equal to zero value but not empty [SOLVED]

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

    Dynamic range not working [SOLVED]

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

    Dynamic range not working [SOLVED]

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

    Dynamic range not working [SOLVED]

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

    Dynamic range not working [SOLVED]

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

    SirJB7's birthday, Excel pal at Chandoo...

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