Search results

oh what the heck. I guess I was a little lazy in the description of torn edge technique. I have modified the instructions to tell you how to crop the image. See updated version here: http://img.chandoo.org/pers/second.png PS: Refresh it a few times if you see old instructions. Some times old...

The reference C$4 is a mixed style reference. It will refer to title in row number 4 and corresponding column. In other words, row 4 is locked. So no matter which cell is highlighted, we always check row 4 to find the year. For more on excel reference styles see -...

If values in Column J are already treated as dates by Excel, then use =text(J1,"MM/DD/YYYY") If values in column J are treated as text by excel, then use =mid(J1,4,2)&"/"&left(J1,2)&"/"&right(J1,4) Both formulas produce output in text format, which means you cannot use these values for...

@Katcyvon... unless you are in a crashing plane which requires correct formula to land safely, never post something as URGENT. We would appreciate, if you use in-flight flotation device than posting URGENT message even in such cases. Regarding your question, it seems like in urgency you may...

No problem. Follow below instructions. Select B1, go to data validation > list In the list area, write =IF($A1=$X$1,$X$2:$X$50,if($A1=$Y$1,$y$2:$y$50,if($A1=$z$1,$z$2:$z$50,false))) Click ok. This should work.

What do you mean by 3 instances? Do you need this validation in 3 rows? If so, just apply for one and then copy validations (copy, paste special > validations)

You can do this with custom data validation. See here for an example: http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/

You have applied conditional formatting to entire column A. In that case, the formula should be =WEEKDAY(A1)=1

You also sent an email to me. So I am posting the same reply here. Hi, Thanks for your email and joining VBA Classes. I am sorry to know that you think we are cheating you. You are the first one to say this in over 5000 satisfied customers, 50,000 members and more than half-a-million...

Congratulations Bobhc... Your enthusiasm for Excel & your sense of humor are truly something. :)

Hi Mike, Please accept my apologies. I misunderstood this as a question. As I said, "I am not sure about the context." but since a majority of threads are new questions, I assumed this too was a question. I feel embarrassed to hurt you.

Hi Mike. I am not sure what the context is. But your message sounds very rude and thankless. Please understand that Luke and all other members of this forum provide help on voluntary basis. Please restate your question and be kind to others. Read our forum rules and obey them all times to get...

Interesting question. Here is the configuration I can recommend: Intel I5 4-8 GB RAM Plenty of HDD space 500 GB Good keyboard & trackpad Windows 7 (or 8 if you wait) with MS Office 2010 (and eventually 2013) Choose 32 or 64bit install based on what you think is good idea. Excel & Office...

Hi Dparteka... See this: http://chandoo.org/wp/2012/05/22/highlight-due-dates-excel/

You can use INDEX + MATCH with * wild card to do this. In D2 write =INDEX($A$2:$A$13,MATCH("*"&C2&"*",$B$2:$B$13,0)) To know more about wildcard usage see - http://chandoo.org/wp/2010/11/01/using-wildcards-with-vlookup/

Hi Knitknotes, Welcome to Chandoo.org forums and thanks for the interesting question. You can use a simple VBA UDF to reverse text in a cell and then INDEX formula to flip it vertically. See this file with a solution. http://img.chandoo.org/playground/knitting-reverse.xlsm For more on...

@K... Replace the AVERAGEIF(D54:O54,"<>#N/A") with below SUMIF(D54:O54,"<>#N/A")/COUNTIF(D54:O54,"<>#N/A") It should work.

Hi Fluxtopia... Thanks for your question and welcome to Chandoo.org forums. Select the cells with dates and go to format cells > Number and select "Custom" and then type d as format code. This will display only date omitting the month and year part. For more on calendars refer to...

You can set up webquery to refresh every 1 minute or so. This way you will get latest data, although your Excel would remain busy most of the time. Another option is to use REST API thru VBA to fetch data in background. This way, you can control the refresh frequency better.

Jai.. Also check out http://chandoo.org/wp/excel-vba/ and http://chandoo.org/wp/vba-classes/ for some useful information on VBA.

@Oscar... sorry for the mishap. We send automatic email with download link as soon as your purchase is over. I think the email must have landed in your spam folder. I have sent you one more email with ebook as attachment. Happy reading.

@Ninjas.. We do have captcha at time of registration. It seems some low paid underlings are used to register and pass on credentials to spam bots so that they can automatically tag , post content. Which is very lame as all the links here are rel=nofollow and we do pretty good job of removing...

Congratulations Luke. Wow, three thousand...

Welcome to chandoo.org gdenison. thanks for your question. In column B, in first cell (lets say B1) manually enter the start date. In second cell, write=workday(B1,1) and then drag it down until you see end date. If you do not want formulas, just type starting date and next date in 2 cells...

Hi Jburchett, Welcome to Chandoo.org. Is there is a logic behind how much yearly value changes for change in monthly value. For example, if monthly expense is $x, what would yearly be? - 12x? if so, in column C, just write =12*B1 and this should do.