Search results

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

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

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

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

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

Hello. Just wanted to share one concern for a calculation worksheet (named "calcula") that I'm setting. The question seems too long to explain, but actually is very simple: At the "calcula" worksheet, I'm using a unique distinct formula (array formula) to get a list of unique distinct values...

Hello. I'm trying to figure out a formula to get a list of dates between two dates. I want these dates to list automatically in just one column when I insert two dates (start date and end date) in two separate cells that I have in another worksheet. Description of the situation as follows...