Search results

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! 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!

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...

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...

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")...

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...

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...