jimbojames136

CAM, Sorry I know this is an old post. I searched for Residual and this came up. Can I ask how did you manage to calculate Residual for a student? I am currently trying to do this for KS5 students. any help would be amazing. thanks

Yeah i can see what you mean now. Ive moved the columns and its worked fine. Quite a simple problem really. thanks very much for your help pcstru.

This is the sheet, should be pretty self explanatory... actually ignore column B that's something else i just tried to get it working. Book1.xlsx

Hi, I'm trying to use a data validation drop down to select a subject in column D1, and in C1 I want the subjects Qualification code to populate. Lots of forums are saying about indirect lookups or using named ranges. Nothing i have read seems to work. Does anyone have any solutions? thanks James

also tried that, the macro still references the other workbook to copy over the information. it might be that i have the whole process wrong. i have designed my report in SIMS. taken a copy of the blank reportdata file. run SIMS report. edit report using record macro feature (this is where i copy formulas and formatting from another workbook) stop macro record. open VB script editor, take copy of code, and close without saving report) open copy of reportdata and past in VB code. close run report in sims again with the template pointing at your copy of reportdata. this could be completely wrong, its my first attempt at running a report like this. thanks James

no this doesn't seem to work as it still references the other workbook within the formula?

Hi all, im trying to set a excel template for data extract from SIMS. im having a problem because im copying formatting and formulas from another workbook while creating the macro to do this. Therefore every time I run the report it needs the other workbook open. is there anyway of getting round this other than having to write every formula manually? ta James

i have a list of names in column A2:A12 i have a formula that randomly picks from these names to poupulate a list in B2:B6 and C2:C6. but i cannot seem to find a way of stoping the Randbtween formula duplicating results. Is there a way to stop duplicates ? thanks James

Thanks Cesil..... that worked. Really appreciate that!

That seems to Highlight the whole thing.... Attached is the table, i need it to automatically highlight a row that contains a Y in Concern column. I cannot do this in Excel as it is an Individual Report from SIMS and as far as im aware you cannot change the output of a Individual Report to Excel. Any help would be much appreciated. Table1.doc

Not sure you can change the output of an Individual Report from SIMS. I know you can do this with Standard SIMS Reports......

Yes, it is an individual report from SIMS so it has to be in word, as far as im aware! I got a VB script to look at the column that i want, and select it, but i do not know how to make it look at the data. One would have thought it would be an IF statement of some kind. But i am no VB Scripter and could be talking utter rubbish!!!

No i mean in Microsoft Word.... I have a table with 4 columns and i want to be able to colour a row based on the 4th column?

Is it possible to highlight a row in a 4 column table, based on a value in the fourth column? thanks james

Hi dont know if anyone can help On the attached document, I need Admin Sheet Cell C11 to C18 to look at Teams Attendance sheet and return tournament names that they are missing! As you will be able to see i have managed to do this with an IF Formula, but it only looks at the first argument if there are multiple results. Need it to say Pennine C tournament 1, tournament 2. Any help Much Appreciated thanks James Book1.xlsx

Has anyone ever managed to make their own instant web messenger to embed into a site ? something similar to Googles "Talk"? thanks James

im trying to make a summary sheet where you can select a reporting period in the first list box, but then in the second list box it only shows the avaliable options for that reporting period chosen in the first list box? and then display results using a vlookup for that particular reporting period and subject. also if all is selected in the first list box then everything is show in the second list box any ideas ? thanks James

perfect thanks

Hi, I want to assign grades in a sheet values: 8 -A* 7 -A 6 -B 5 -C and so on........ I'm guessing I need to use a lookup table of some sort, but I'm a complete novice using lookup tables so any pointers would be great. thanks James

Thanks Guys, it may be messy but it works

Hi Trying to use a count ifs formula. =COUNTIFS(K3:K246,"A",K3:K246,"B",K3:K246,"C") its to count the number of A - C grades in one column, but it keeps returning a value of 0. can anybody see where i might be going wrong? or suggest an alternative to countifs ? thanks James

Hi Guys, Just after some information on Corero as they are coming in for a meeting to offer a cost effecitve alternative to SIMS. Any information/Experiances people have had with them or have heard about them. thanks James