Search results

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

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

Hey, you've done it! Wow! Well, looking at it just on the surface, I guess it is better to use the BY8 cell formula from the "calcula (2)" worksheet... I'll let you know after testing if this method pushes too much calculation processes in the file...

Hi SirJB7. Thank you very much for the freddy.vs.jason worksheet. It has been very helpful and illustrative. So my sincere thanks. As for the other thing, I'm very sorry for my mistake on the formula. Yes, I pointed it at the wrong place. Sorry. :-( Hmm... You know what?, I've been...

Hey! Sorry. Ok, I'm checking...

Hi SirJB7. Thanks for stepping in. You really are very kind. Well, I don’t want to sound neither whiny nor ungrateful regarding this solution of yours… Let’s see how I explain myself: At first, I’m noticing your formula at the “BY” column (in the “calcula” worksheet) is not listing the “I”...

@kaushik03 Thanks for your help. Unfortunately, your formula is not working the way I expect. It is listing values (author names) out of date range I need. I guess it must be the "+3" you added to the formula... :-( @narayank991 Thank you very much for your keen observation. You were...

Now I'm strongly suspecting my array formula is not working because of some needed limits in the following highlighted ranges which, considering the perpetual growing of data at the "data-offsite-radian6" worksheet, will have to be dynamic (dynamic ranges)...

Hi. Back again, sorry. :-S At the following Excel ‘10 document: https://www.dropbox.com/s/663lapi607iw3uu/exercise_to_chandoo_3.xlsx I'm trying to list the values on the "I" column (at the "calcula" worksheet) between two dates (at the "data-offsite-radian6" worksheet). The dates that...

Voting for Debraj Roy, unconditionally. :-) As for the other candidates, I really don't know them, but if they are being proposed it must be because of something good. Congrats to Faseeh on his recently gained badge, by the way. Cheers.

Wow, wow, wow, Deb! This new named range formula of your beats mr. Karivardhan and mr. Karthikeyan all together! Sadly, mines still are a bit like my folk F1 driver, mr. Maldonado, which I don't like and never will (and I'm talking about Maldonado, not my mediocre but still decent formulas...

Hi Debraj. Sorry to bother again with this... :-( Just wanted to tell you that I tested your formula and seems it is very close to what I expect. It really works as a Ferrari on calculations, so thanks for that! But sadly for me it stills lacks the ability to dynamically expand the range on...