Hi Deb. Thank you very much... I just discovered the offset function too. It seems interesting, but I'm testing it... I'll run your proposal first and let you know, since this has taken me the whole day... :-( I'm tired...
Ok, maybe the question was too long. I'll reformulate it:
What I would like to do is use the formula below for unique distinct values that I posted, but I need ranges to be, like, I don't know, dynamic, since data growing is perpetual for the column "I" at the data-offsite-radian6 worksheet...
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...
Dios mío... I'm in love.
SirJB7, you truly are a ninja! A sorcerer, el brujo del Excel, bacanísimo, lo máximo (o como diríamos en Venezuela, "el chivo")...
I was really anxious. Don't know how to pay you this big favor you've done to me. In the meantime I'll return it to the others at the...
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...
Hola gente.
I'm Tzeitel, media analyst from Colombia. I learned about this site from about four years ago, I guess... From the start it seemed to me that it was a very good place to learn and that it had a great community (I was amazed when I received answers right after posting my first...