Search results

Ok, I did split the sheet into to views. However, what should I do now to apply different orientation to those two views? I would like to make sure that once I click print of this one sheet I will get two pages - one landscape, second - horizontal. Thanks, K

Hi! Could you tell me if there is any chance to split one sheet into two pages - one set to landscape and another to portrait orientation. I know I could just move some data into separate sheet and it would solve my problem, however I can't do it and would like to see if there is any chance to...

Hello! I would like to ask about XIRR calculation, which is included in the attachment. I have two questions: 1. Why XIRR is calculating for one Cash Flows and for slightly different ones (no material change) there is NUM error displayed. (Please see example in the file). 2. Why when we just...

Hi All, I have a really weird issue. Basically, I have two excel files opened and I would like to link cell from one file to another one (sth like. '='Second file!A1") but just using my mouse not typing the formula with the path to the second file. I can't do that. When I typed "=" and...

Hi again, now I received some totally different format by using _-* #.##0,00_-;-* #.##0,00_-;_-* "-"??_-;_-@_-"" as SirJB7 posted. That's weird:)

Hi! I've found custom format which enables me to convert values into millions like below: _-* #.##0000_-;-* #.##0,00_-;_-* "-"??_-;_-@_-"" The only problem is that let's say instead of 111,111,222 I get 111.111222 and I would like to have only 2 decimal points like that 111.11 Thanks for help!

I have an answer. I checked the very last functions which were then aggreagated and driving the final result. It turned out that those functions are calculated wrongly as well as this abovementioned example with 108 mln. So simple sum functions were adding numbers and providing the wrong result...

Ok guys, so this is really weird. The problem is caused by a wrong sum calculation in one cell. I will try to describe the issue as specific as possible, but please excuse my english. Since the document is huge I tried to move and copy the broken tab to new blank document to present you the...

Hi! I have a really weird problem with simple function. I want to divide result of one function by another function's result. Let's say cell: A1's value is 2 A2's value is 3 Below I have a function "=A1/A2" and it gives wrong result instead of simply 2/3. What's more interesting, if I type...

Thank you! That's very helpful. You have just decreased my time spending on doing that exercise by 25% ;)

Hi! I have this little macro as below: Sub CopyValue() ActiveCell.Value = ActiveCell.Value ActiveCell.NumberFormat = ActiveCell.NumberFormat End Sub It works for only one active cell. What if I want to select mutliple cells (e.g. A1, A13, A34, A130) and use a macro which converts...

Hi all! Hope you can help me improve presented macro. Below you can see code which firstly unhides rows and then hides the blank ones. My question is, how can I run it automatically whenever let's say cell A1 changes? Sub ShowAndHide () Range("A5:A10").EntireRow.Hidden = False Dim cell As...

http://www.speedyshare.com/2QD4Y/pivot.xlsx I changed the dates and apply date format. Pivot table reads the data as a text string obviously. Why? And I found that there is such an option as 'date filter' instead of 'label filter' in pivot tables options (as in this video in 1:40...

Hi! I have a problem with label filter in Pivot table. I want to create such a filter for date formatted cells and it's not working fine. I want to filter all dates that are between two dates and it does not work. Please find the link to file attached...

Hi All! I have quick question. In one column we have cells in which are functions as follows: =C1 =C2 =C3 =C4 ... =C1000 So one column with cells showing values from other cells. How we can add to all those cells indirect function to get: =indirect("C1") =indirect("C2")...

I am not sure about this pivot table, since it needs to be automated, I have to just generate the numbers and have this summary. But, I have some general idea which you can find in here http://www.speedyshare.com/ezkja/market.xlsx I got the most common duration and now I think it'll be...

Hello! I have one excercise which I am approaching for couple of hours unsuccessfully. Please see the picture attached - http://postimg.org/image/ia4erts5l/ We have units and every each unit has it's specific duration. There is a huge number of units and I need to prepare the summary...

You guys are amazing! Quick and helpful! Thanks

Hello! I have one question regarding Sumif function. Please see the image attached - http://postimg.org/image/atnrv2bk3/ Assume we have a column of cells in which are numbers and letters together. I extracted the numbers (col. D) and want to sum numbers applying criteria as in the picture...

Hello! I have problem with Sumif function. If the criteria is 'equal to' there is no problem as you can see here: http://postimg.org/image/wugze7ast/ But if I change the criteria to 'higher than' the result is just 0, which is wrong. You can see it here http://postimg.org/image/rckapk5yd/...

Hi, We have two functions: 1) =VLOOKUP(A4;Sheet2!A3:C21;3;FALSE) - it gives the result: 6 2) =VLOOKUP(B1;Sheet2!A3:B21;2;FALSE) - also gives result: Sheet2!A3:C21 so if both functions are working why in this function: =VLOOKUP(A4;VLOOKUP(B1;Sheet2!A3:B21;2;FALSE);3;FALSE) which is...