Search results for query: *

Just had another look and if you are trying to get the percentage mark for each student the formula will be =SUM(B7:AN8)/SUM(B$2:AN$2) In cell AO7 Impossible is Nothing

Hi Sandy I have had a look at your spreadsheet and it looks like a count function would do nicely =COUNT(B4:B41)/COUNTA($A7:$A41) This is assuming that you want to automatically calculate th percentages. If you put that formula into cell B48 on your mathematics sheet this will calculate the...

If there is only one occurence of your unique ID in your manytable then there should be no issue with returning values from columns 2 3 and 4. If you want them individually you would have to write 3 different formulas: =VLOOKUP(B3,manytable,2,FALSE) =VLOOKUP(B3,manytable,3,FALSE)...

I created a word document with 6 pages each with a number on it and it worked fine. saved 6 new documents with each page. Impossible is Nothing

Sorry formula is wrong, Should be: =IF(A2="",C1,A2) You will have to manually enter the first site code into cell C1 Impossible is Nothing

Actually After thinking about it, If you dont like using VBA then you could use this formula in Column C =if(A2="",A1,C1) then just copy down to the end of your data and then copy column C into Column A using paste special -> Values Impossible is Nothing

If I am following this correctly then your data looks like this: 123456 Jane B John A George A Georgia B 654321 Peter X Percy Y Sally S If this is the case and all the people below 123456 are in that site and all the people under 654321 are in...

Thanks skip Im not really up to scratch with VBA and this is a bit of a hybrid that i was trying to adapt to suit me hence the bits that were not being used. Not sure why there was a select statement in there but it was working for me so i left it. Ok as I was writing this I realised what the...

I am having trouble with the following code Sub getitems() Dim WSD As Worksheet Dim WSW As Worksheet Dim QT As QueryTable Sheets("Sheet1").Select For m = 1 To Range("C1").Value Select Case m Case Else mystr = m End Select...

I managed to do it with a combination of functions dont have time to post a full solution but start with =IF(ISERROR(FIND($A$1,$B1,1)),0,$B1) Assuming your search text is in cell A1 and your data is in B1, then fill this to the bottom of your data This will filter out entries that do not...

What im struggling with in Access (and yes im not very well versed in the program) is I want to be able to assign A staff member to a Job for say 50% of the week and 20% of next week, but rather than doing it individually I want to have a table where I can see all staff and all projects and get...

Sorry about the title didnt know how to describe what i wanted. So here is my issue I have been asked to design a capacity planning tool and have been throwing around ideas on how to go about it. I have made one before in Excel which worked fine until it came time to add more fields and...

I am with skip on this one. the solution i posted works for me on my spreadsheets but with multiple users editing it a simple piece of VBA code will do the same thing but more reliable Impossible is Nothing

If you select each INDIVIDUAL row while holding Ctrl untill you have selected all your data, then right click on a row number and select insert. This will put a blank cell in between each set of data. As for the border issue, rather than using copy & paste i would use format painter. Format the...

Data validation only returns the result of the cell. I would make a table with the values that you want in the first column 25% OF TOTAL 50% OF TOTAL 75% OF TOTAL 100% OF TOTAL Then in the next column put the formulas that you want it to return =A1*.25 =A1*.5 =A1*.75 =A1 Name your first column...

This is a messy solution but it works insert a column in Column A moving your data to Column B In cell A1 use this formula =IF(ISBLANK(B1),"",1) In B2 Use this formula =IF(ISBLANK(B2),"",MAX(A$1:A1)+1) Copy B2 down to the bottom of your data range In column C Put Numbers 1 to 100 (or as many...

Right Click on the cell, there should be an option saying Hyperlink. A pop up will appear and will give you the option of pointing the hyperlink to the folder/file/whatever. Click OK Voila Alternatively hit ctrl + k or insert --> Hyperlink Impossible is Nothing

Assuming that your names are always LastnameFirstname, would there be first names that would have 2 uppercase letters in it? If not then you could use the max formula =MAX($B1:$AA1) this would give you the starting point of the first name IF there are no caps in the first name. but you would run...

I understand What you are getting at now and have had a play with the formula. =COUNTIF(YourRange,"<8") will count all cells that have a value less than 8 but will not include text strings. =COUNTIF(YourRange,"8-15") will count all cells that have the text string 8-15 hence this will work in...

Try COUNTIF(Sheet2!a1:a21,"<=15")-K1 COUNTIF(Sheet2!a1:a21,"<=30")-K1-L1 This will do what you want (obviously change the range to suit your situation) Impossible is Nothing