Search results

Just in case anyone is interested, I opened all the data files then edit links the reports, worked like a charm

Hello all, I have a data spreadhsheet which was 2003, until I converted it to 2010 last night. I now have gone to one of my reports and tried to edit links to link to the new xlsm version of the file and it is taking ages to update. The report file links to 2000 rows, 6 columns of data...

Sure that's just genius, works a treat, saves me loads of time and makes the model scalable. Note to self must learn about INDEX, Cheers Luke

yeah was looking at that centre across section, but its a big file and may cause more hassle changing! Basically i have 10 product names every 6 columns, then further over i have 10 columns with the same 10 product names. So for examples, A8, G8, M8, S8, then I want AA8=A8, AB8=G8...

Hi All, odd one here. I have a Product Name in a merged cell I:N8, as I have multiple column of information underneath. But on the hand side I have the list of product in one column each. Ideally I'd like an easy way to link cell DT8 to I:N8, then simple drag across, but as the first...

Cheers Luke, you had me thinking with that little typo in the INDEX $Z$6$18362:$Z range but got there. Thanks again ;)

Hi, I have a large dataset with products and promotions info which I have filter to only show certain products (which I want in the promo). In another sheet I have a list of all products and I simply want to state whether or not the product is filtered on the other sheet, a summary if you...

for clarity, without the dot =HYPERLINK(A1&B1) :)

Hi Fudog, Type your URL in cell A1 and ID is cell B1, then in C1 type =HYPERLINK(A1&B1). Should work a treat. Paul

Hi, When i have a column of data, say A1:A10 and i add a formaula to B!, I double click the bottom right hand corner to fill this down to B10, very useful. I found myself working with a lot of horizontal info and was wondering if there was a quick way to do this too? Cheers

Actually if i remove the indent and right align it works, not what i want but it works. Obviously a problem with indenting and printing. Doesn't answer the first problem?

Evening all, I created a dashboard recently, for a heading I merged cells A1:K2 and added an outer border, then aligned three charts underneath, all look great on screen, but when i print preview or print the charts border are a good inch past the bordered heading cell? Then tonight, I...

Ah ha! Brilliant Luke, appreciate your help

Hi, I am looking to pull back a reference number (using large) from a list where the department column = "Marketing" and Status column = "Active" I am using the following array. {=LARGE(IF(AND(Tracker!$C$11:$C$1500="Active",Tracker!$P$11:$P$1500="Marketing"),Tracker!$H$11:$H$1500),1)} For...

Cheers Narayan, managed to figure out from that post. Paul

Hi, Hopefully an easy one for you. I have a list of requests by department, then a column calculating the number of days each request is open. Using the Max function I can find out how long the longest request is open. But I need to do this by department. So what's the maximum open days...

Thanks Luke, works a treat. I used isColor in a few year back, not sure where I dug it out from, but it has just saved 4 hours a week for a member of my team! :)

Hi all, I am using the follwoing formula to indicate wether cell A1 is shaded or not. =IF(iscolor(A1)=TRUE,0,1) - althoguh it seems tad backward this formula it does work. It works fine if the cell is shaded when you type the forula, but if you remove the shading, the result does not...

Hi all, I've been trying to produce a bubble graph for the last hour, I've read the help files and post on this site, but still not getting where I want to be. I am reviewing our indivual keyword PPC spend versus it's natural ranking, the aim is help identify which keywords we're ranking...

Evening all, I've been tasked with producing a fairly detailed budget plan and sales pipeline model. Whilst I have a few ideas, I thought I'd have a look on here for any examples of pipeline reports. Doesn't seem to be much on here, anyone know of any example or have any to share ideas? thanks

Cheers for this, works a treat (then I recall doing the same on a model last year!) Thanks again

Hi, I have a list of people responsbile for specific tasks, defined in a range of 10 cells, but for some project I may have more or less people involved, but maximum 10. If I only put 6 names in the list, when I use data validation I get 6 names and 4 blanks in the dropdown, is there anyway...

Cheers Hui, spot on! Appreciate your help

Hi, one simple way is too change the font to WEBDINGS and use the following 5=up 6=down 34= left and right example formula =IF(A1<0,6,IF(A1>0,5,34)) So if A1 is less than 0 then down arrow, greater than 0 then up arrow, equal to 0 left and right. Hope this helps

Hello all, hoping you can help with this query. I have a project plan which has 30 odd tasks, for each task the user only needs to enter task, responsible, start date and duration (as in working days). Some tasks are 2 days, some are 10, 25, one is even 40. My isse is calcuating the...