Search results

as for second question:- go to Page Layout > Print Titles > Header Footer Tab > Custom Header > click on folder icon (to inser path) and insert "/" and then click on icon next to folder icon (for file name). Regards Yogesh

Glad to know that you got what you wanted!!!

Welcome to the forum trumpetbird If you use the google Custom Search bar with the title of your post, you will get several posts for the same issue. One of the article is here: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

OMG!!! what an effort Hui!!! you are awesome. just one improvement: the formula is resulting in one character less than common characters. I think we need to place -1 instead of -2 at the last segment of formula.

OK Boss!!!! my mistake. BTW the sharing of copyrighted material is infringement not address of where it is stored and I did not produce any part of the copyrighted material in any form. ;)

best or not but I am reading this book now a days and find it interesting: OP referring to Excel for Dummies Vba Programming.(Bobhc)

select all unused columns and rows and press delete only if you are sure that there is nothing on sheet which is hidden and can be useful. See if this works. if not then this link may help you: http://support.microsoft.com/kb/211769

@Nairnin The formula (the one in my previous post) works only on unique Text values not on numbers.

welcome to the Forma Ajay Gupta Press Ctrl+ down arrow u will reach last row. See if there is any value there. try to accommodate it in some previous rows.

gmelchor I think the chart is right. the first value in the series is plotted in left bottom and then go up in order. to get first value in upper corner you need to reverse the order of the series right click on left axis>Format Axis > Axis Options > Categories in reverse order...

another variant of the formula to make output look presentable: =CHOOSE(ROUNDUP(DAY(C2)/7,0),"First","Second","Third","Fourth","Fifth")&TEXT(C2," dddd") Sirjb7 and Montrey Thank you.

No SirJB7, not at all My intention was only to help to reduce duplication of your efforts so that you can enjoy your saved time with your favorite beer and......... :)

Is there any way that if a member has no. Of posts less than 2 or 3 and when he / she starts a new topic a message is flashed before starting topic guiding the member to sticky posts and prompting them to use search bar first for their qurstion. This way they may get what they want and...

Copy this formula in your result column row 1 and press Ctrl Shift Enter all together. copy down the formula as required and then sum the values in the end. =IF(COUNTIF($A$1:A1,A1)>1*(h1>0),0,1)

Welcome to the forum TheBeerHunter suppose your date is in cell G8 =ROUNDUP(DAY(G8)/7,0)&TEXT(G8," dddd") Hope it helps

Aviator see following links. http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/ http://chandoo.org/wp/tag/offset/ http://chandoo.org/wp/2011/10/04/offset-function-to-calculate-irr-for-dynamic-range/...

Google it. You will find many ways to unprotect your password protected worksheet.

Here is the chart as you wanted: https://www.box.com/s/c4ed4cdff8e12c92c43f How it works: First i Created Cell A1 as linked cell for radio buttons. This shows the value of the radio button selected. you can give the font color white to hide it. Second I aligned all the charts at same...

visit the link to see how to upload a sample file: http://chandoo.org/forums/topic/posting-a-sample-workbook

That's Good!!!! congratulations!!! There is not better feeling than "Aha!!!!" moment.

Please upload a sample file to understand the data?

Supriya You can use Camera tool for that. Follow this link. go to page 126. It explains the way to show picture by selecting it's name. Same logic you can apply for your charts. http://books.google.co.in/books?id=-i4RTOdO_fYC&printsec=frontcover#v=onepage&q&f=false or you can also upload...

Ashokraju If your are using Excel 2010 Select the output Cell >> Home Tab >> Cell Styles >> select Normal This will make the cell content/ hyperlink look like any other normal cell but hyperlink will remain intact. EDIT: alternatively you can also do this...

Narayan There is not doubt about Native Date Format and I am in Full agreement with you about the fact. By default the Excel has General Format for all cells in all worksheets. So If we enter the no. 41117 as suggested by you it will give the same result as you mentioned. But If the cell is...

1Q- If a cell is already text formatted and you enter date either in format 13/7/2012 or 7/13/2012 depending upon your native format, it will take both of them as text strings. you need to apply either the general format or date format to enable Excel to recognize that you are entering date...