Search results

Thanks Somendra - will try wrap my head aroun this a little later! Much appreciated :) -

Thanks so much Nebu for your speedy reply - will look at this a little later. Much appreciated.

Hi All I am wanting to use one formula to keep the alphabetical character but add leading zeros if the digits are less than 8. For example A1234 must be converted to A0001234. Many thanks, Nikki

Thanks so much, Debraj! February 2012 is not actually text but I will test it anyway to see if it works. Your help is much appreciated, take care, Nikki

Hi Chandoo and Co! First of all thank you for this amazing forum - I have learnt so much as a result of your generosity - you are all awesome! I am struggling to combine two formulae - I want to determine the number of unigue personnel numbers using two criteria - are you able to help...

Thank you Narayan - you are an absolute WIZARD!! :) It works perfectly! Much appreciated, Nikki

Headcount January 2010 February 2010 March 2010 April 2010 May 2010 Perms 52 53 54 55 Temps 2 3 4 5 =OFFSET(Sheet1!$J$8,COUNTA(Sheet1!$J$8:$AG$8)*0,0,1,13) Thanks All - wasn't able to paste all the data, but the range is from I8:AG10. I would like the graphs to reflect the latest 13...

Thanks Hui and for your help but I just can't get the formala to work. "On paper" it all looks fine but the formula doesn't seem to recognise the Offset function. The * was not a typing error - EXCEL returns an error without it? Our Dashboards have data from Jan 2010 to Dec 2011 going accross...

Hi! All the examples show that the data is in rows, but if the data is in columns, how does one get this to work? I have tried the below but it doesn't work Data in one row along columns =OFFSET(Sheet1!$J$8,COUNTA(Sheet1!$J$8:$AG$8)*0,0,1,13) This works well because the data is in one...