Search results

Hello, I have a number in a cell A1 say 100 I want to populate the next 17 cells upto A18 so that the 17 increments will eventually arrive in cell A18 with a value of 200 in other words the value in A1 has doubled in 18 steps I'm currently doing this with a simple percentage increase but I'm...

Further to my post above, and please excuse my lack of knowledge but this is all new to me. I have a query with the offset function too. Again, in experimenting to try and return a range of rows/columns I have used the offset as follows and don't understand why I get '0' returned...

Hi, I'm using a dropdown validation/list function and wondered if it's possible to use the MATCH & INDEX functions to return multiple rows/columns of data. I'm currently using INDEX [ =index((a1:b12,c1:d12,e1:f12,g1:h12),2,2,4) ] to return a single value from those four tables but I'd like to...

Thanks Stemelliott This will show my level of knowledge, all the data tables are on one sheet so I thought it would be nice and easy but I just have not got my head around the concepts yet. Having said that, I am going to push on again but this time using the indirect function as well. Thanks...

Hello, I have been trying to create a graph that will allow me to graph any particular table from upto ten tables. I have really nice individual line graphs but would love to be able to know how I can automate this. So, I have; [1] 10 data tables [2] each table has 2 columns and 36...