Search results

Hi All, On the Target tab I need to count the number of times dates occur within a week on the Actual tab. Should be a straight forward COUNTIF but I can't seem to get it right so your help would be appreciated. Thanks

Thanks very much for your help. Much appreciated.

Hi Hiu, Sorry, took a while to get everything set up to share the file. The link is: http://db.tt/QtiltPYd Thanks SKS

Hi Hui, Apologies but having trouble with adjusting colums to suit. The extension data is in the same Telephony tab and in column C in the same range C10:C145. What would the formula be in that case? Regards, SKS

Hi, I have 2 columns, one with the Ext number (e.g 3201) and another with type of telephone. At the moment I had a formula =SUMPRODUCT((Telephony!H10:H145={"Analogue Phones"})+0)to just count the telephones but now some people have put the ext as "broken" instead of putting their ext number in...

Thanks for your help. Will try the suggestions listed. Much appreciated.

Sorry, should have mentioned that these are data validation drop downs

This is driving me up the wall so any help would be appreciated. Created multiple tabs in Excel 2010 with all drop down lists on one tab. Works fine in 2010 which is used internally. When I e-mailed it externally people using 2007 started complaining that drop downs can't be viewed. I...

Thanks guys for the quick reponse. Much appreciated. Only started scratching the surface of the amount of data on here. The tutorials are fantastic and amazing that they are free.

Hi, Newbie here having the discovered the site today. Brilliant site and thus have registered and added to favourites and told colleagues about it. The query that made me find the site is: I have a large row of dates in Column C. In column B I want excel to autopopulate the day of the week...