Search results

Please, delete this post. I dont know why but now its working perfectly. I think when adding the range of the name without $, it all got messed up. Thanks for the forum, great help always!

Hello, I have the following set of data: 1 AGENCIES 2 German Agency 1 3 German Agency 2 4 German Agency 3 .. 10 Total Germany 11 Swiss Agency 1 12 Swiss Agency 2 ... 15 Total Switzerland ETC In order to create a list in another sheet that allows me to choose any from the German...

I have the output in a sheet: No. Country Amount 1 2 3 ... 20 Here I must find first the largest amount year to date (this case jan + feb), in column C for the largest (no.1) to the 20th largest (no.20). Then in column B I must find the correspondent country for that...

Im trying to get the n largest value after a sum. For example, I have: Jan Feb Mar Apr Jun Jul ... Country 1 23 31 11 43 18 9 Country 2 40 55 21 18 7 24 Country 3 14 31 45 6 29 14 ... Before I have always used lookup first and then a combination of Sum and Offset to find...

Thanks so much Narayan, it worked perfectly!!!

I have a series of countries in cells A1:A100, each country has production for each month in columns B:M. I need a formula which sums production for a certain country (cell AA1) acumulated year to date, according to current month (1 to 12 in cell AA2). How can I do it?

Hello, Im trying to create a dynamic named range avoiding $, but it doesnt work. The range is in another sheet, how can I make it so that when I add a row it includes it in the range making it 1 row bigger? Thank you!

Oh! I managed to get a peak at Windows 2007 and indeed, this option is only available there, not in 2003. So much for nothing..., 2003 is what I have at work :-( Anyway, thanks all for your help! Always learning.

Hi there! Thank you for the post, really helpful. Only where you say that workbook is there by default and than you can change it into worksheet so you can apply the same name to the same range in different sheets (what I would need), I dont see that option in Excel 2003... There are only 2...

Hi SirJB7 This is what I found: Crear un nombre para una referencia 3D En el grupo Nombres definidos de la ficha Fórmulas, haga clic en Definir nombre. En el cuadro de diálogo Nombre nuevo, en el cuadro Nombre, escriba el nombre que desea utilizar para la referencia. Los nombres...

I think I have exposed this the wrong way from the beginning. I know there are lots of ways around so I dont need to name the range: insert rows before copying so the range changes automatically, replace the old range for the new one in the whole sheet... I just wondered if there was a way of...

Hi Narayank991, I have a document 12 diferent tables in 12 different sheets, each for 1 month. I also have a extra sheet with 12 graphs that get the info from this sheets. In each sheet the data is pasted in range A2:AF12, the same range for each month, and then rearrange (with subtotals...

Hello! I've been subscribed to your newsletter for a few months now and I think is awesome! thank you so much for your wisdom :-) It has really helped me impress some bosses around here... I need to define the same name for the same range (A2:AF12) in 5 diferent sheets. How can I do that? Im...