Search results for query: *

Hello, Very new to Microsoft Sharepoint. How do I add a document as a hyperlink to Sharepoint? Thanks so much, Elf a

Hello I have over 15000 lines of data that I have sorted into a pivot table consisting of two columns: Traveller / Count of traveller There is over 5000 lines within the Pivot table and I require to view the complete data of the first 153 lines. (ie when you double click on one name it...

Dear Sir or Madam, From cell A1 to cell A1000 the cells contain various names of men and ladies in the following format: Cell A1 Smith, Andrew Mr Cell A2 Hatcher, Melissa Mrs Cell A3 Mitchell, Geoff Mr I need to write a formula so that in column B I have the surname only with no comma...

Hello, I have the following to solve and have been unable to get the right formula to make it work. Hope you can help. Cell A1 has a code say it is 4-1120 Column D had a list of codes from line 1 to 100 and one of them is 4-1120. Say this is on line 50 Column E next to all of the codes has...

a b c d e f g 1 2 4 5 6 2 3 5 2 3 2 3 5 4 We have above data on a much larger scale. In column G we need a formula that returns the last record in the row even though the records end in different columns. The data number in the columns is high so we can't use an "if formula" (300...

Hello, I have data as follows: Column A Column B Row 1 YTD Spend Annualised Spend Row 2 2,000,000 3,000,000 I have put this into a basic column graph. It has the $ values on the left axis and the titles at the bottom axis with two columns. If the client had...

If I am doing a standard column graph and wish to have a line going across at say 2,000,000 on the Y axis how do I do it? I was hoping to link to a cell and have the line come up automatically based on the number entered. Previously I have been drawing a line accross the graph. Thanks Elfa

Hello, I have the following formula =IF(M40-$J40>0,M40-$J40,"") I was wondering how to type this so the iserror function is inserted. I tried =if(iserror(M40-$J40>0,M40-$J40,""),"",M40-$J40>0,M40-$J40) but it did not work. The reason I am asking is because I have to drag the fomula to the...

Hello, I have three columns a b and c. Contents is as follows: a is Car Make. b is Year Make and c is model. I used the following formula =concatenate(a1,b1,c1) to bring the contents together. I want to have it all int he same cell but leave spaces between each of the data. I have tried...

Hello, I have two sheets in the file. Sheet One contains a list of numbers from cells A3 to A80. Sheet Two has a number in cell A1 A3 A5 A7 going down the sheet. Does the individual number in sheet two equal any of the numbers in the range from sheet 1? "Yes" "No" I tried to write a formula...

Hello thanks Maudedo. Needs to be different lines. Is there a line anywhere in table two that matches table one. Like a one to many. Regards Elfa.

Hello, If I have two colums of data such as the below: (assume they are in column A and B) Table 1 Table 2 1 12 2 13 3 3 5 4 5 5 How could I get a yes or no to display in...

Cheers Doc. Spot on. Regards Elfa.

Hello, If I have seven numbers with probability percentages (see below) can I get excel to show me what would what numbers would be displayed after a number of instances. ie. after 10 instances excel would return 1213467743 Obviously the more instances that are chosen the closer you get to...

Hello, If the following numbers are in the following cells the average is as follows: a1=2 a2=2 a3=2 a4=2 =Average(a1:a4) =2 What if cells a3 and a4 are blank? the formula returns an average of 1. Is there a formula I can use that will only calculate the average based on populated cells...

Cheers Ken, Spot on. Regards Elfa.

Hello, Cell C82 contains the number 4. This represents a number of a month. ie. Jan 1 feb 2 etc etc. I need to be able to go from 1 to 12. The formula below does not let me get past 7. Do you know another way? Thanks...

Thanks very much Steve - worked a treat. I would never have got there. Regards Elfa.

Hello, cell a1 will contain a number from 1 to 12. This is determined by the month ie January will be 1. Feb 2 etc. the sum calculation required depends on the number in a1 I wrote the formula below but I can only get to 7 not to 12. Is there another formula I can use...