Search results

Hello all, I have a nasty problem which annoys me a lot. When I try to open hyperlinks in excel 2010 I get this message: The operation has been cancelled due to restrictions in effect on this computer >>> Has anyone got a solution for this problem, please?

Hi all, what formula to use to count the cells that are not empty in a row?

You can round 1.214 to 1 but 1.964 will be rounded to 2 beacause this is the nearest quarter. Try this formula =ROUND(D1/0.25;0)*0.25 where D1 contains the value to be rounded.

Hello everbody, I'd like to create rounded-corner headings in my worksheet because they are more eye attractors. Can any one help me do this?

Hi all, Is there a way to automatically copy every formula I put in my workbook into a seperate sheet in order to keep track of all formulas?

Hi all, any ideas

Hi all, Is it possible to display two worksheets from the same workbook at the same time so that we view the changes in one worksheet when we enter data in the other? How can this be done?

hi bobhc, I want the charts to represent data according to : class period teacher When I click (class) data is represented according to the success percentage of all periods When I click Period, data is represented according to the detailed marks withing each period for a specific class...

Hi Novice007 Why not change the name of the original file on your computer?

Thanks bobhc, Here is the link on dropbox https://www.dropbox.com/s/92guvb4qglmnike/My%20School%20data.xlsx

Hi all Have you seen Chandoo's interactive sales chart? It is fascinating. i want to make one, but I did not get it right. Here is the worksheet I want to make the interactive chart for. Can anyone help me, please? http://www.4shared.com/file/191HytlH/My_School_data.html

Hi all Sometimes we need to filter data according to different criteria. My question is how to have the number of the resulting data in a separate cell ( in the heading row for example )?

Hi Montrey This is easy when the workbook contains a limited number of worksheets. But, what to do when it contains about three hundred worksheets?

Hi, In a multi-worksheet workbook, is there any way to know the size of each worksheet in MB?

Thanks SirJB7 for your reply. I want this to be done automatically because I want to export the resulting list to new worksheets for further calculations

Hi all, I have a list from which I take some values using "If(and " formula. The values I get have empty rows between them (naturally). What formul can I use to eliminate these empty rows and have all the vlues in sequencce in a fresh list?

Thank you sir

Hi all, I have this spreadsheet: A1:U20 I want to conditionally format the cells in column A when the cells in column ( I ) OR the cells in column ( M ) OR the cells in column ( Q ) or the cells in column ( U ) are less than 60. Can you please help me write a suitable formula? Thanks

Thank you all.

Hi all, I have a large excel (.xlsx) file. It won't open . Can I save it to another format although it is closed and won't open so that it can be opened? It is 48 MB large. Thanks all.

OK, Thank you very much.

Thanks all, Luke M, the VLOOKUP formula is OK if I chose only one value in A15. Now How can we develop this if I have a list A15:A25 and I chose to put a value say in A17 and another value in A20 and yet another value in A23? All values are taken from A1:A10.

Hi all, I have a worksheet A1:F10 which contains data text and numerals. In A15 I may choose any value from A1 to A10 I want a formula that displays the values that are in the same raw as the value I choose from A I hope my explanation is understood. All help is highly appreciated

chandoo.org/wp

Hi Chandoo, The link for downloading the file attached with the lyke formula is not working. regards