Search results

3G / Montrey Excellent feedback -- will get onto some polishing up over the week end. Cheers G

Hi all I've been trying to create a student data dashboard for the past week. Thanks to some great awesomeness from this forum, I now have a version fit to look at: http://www.glengilchrist.co.uk/wp-content/uploads/2013/01/student-dashboard.xlsm This is part of a post I made on this...

To answer Luke's question: I am taking a list of student scores and automatically allocating them to a group based on their average test score. The whole student body is either "X" or "Y" - hence the need to rank(if). My initial solution was just a fudge to scale all the numbers so I could...

Solution: Thanks to Luke for your input - you are most awesome.. 1) Calculate unique score: =IF(ISERR(AVERAGE(P12:U12)),"",(AVERAGE(P12:U12)+(ROW()/1000))) Bascially compute the average score and add a tiny bit depending on the row that the data is in. Always unique. Then used Luke's...

Hi I think I'll go down this route: ={N12/MAX(IF(Bandxy=L12,Score))} To compute the "normalised" score and use VLOOKUP to pull a set number.... G

Hi Luke Perfect, and I stand more chance of understanding it due to the copious SUMPRODUCT examples out there. Yea, the shared ranking is OK - what I am trying to do is to cream off the top n numbers and allocate them to "set 1", the next y numbers to "set 2" and so on. Ranking them is a...

So, I found this (which works) =MATCH(B3,LARGE(IF($A$3:$A$11=A3,$B$3:$B$11),ROW(INDIRECT("1:"&COUNTIF($A$3:$A$11,A3)))),0) Which does exactly what it is supposed to. Great. I read somewhere about adding a random number to a list to force a ranking -- but when I do that, the random number...

Ok folks - I have two columns, BAND and SCORE I want to rank SCORE, BUT BAND has two options (x) or (y). So I want a ranking of SCORE if BAND = x and if BAND = y eg Band Sore x 120 (rank = 2 of the "x") x 111 (rank = 3 of x) y 101 (rank =...

Genius Hui, for some reason known only to my mouse, the named ranges where not the same and some $$ had gone missing. Odd error -- but thanks for the pointer. Classic. G

Hi Hui Yea I know -- I have the syntax correct and still AVERAGEIFS chucks a Value! error when I use the named ranges. Fortunatley I can use AVERAGEIF as I don't need multiple criteria in this one, but prefer to use IFS as its more general....... Cheers G

Hi (again) Curious... The =AVERAGEIF(Sex,"m",Score) formula works fine (I know the syntax is different).... mmMMMMM G

Hi all Happy New Year all or as we say in Wales, Blwyddyn Newydd Dda. I have a 2 named ranges: SCORE which is defined as StudentData!$F$13:$F$300 SEX which is defined as = StudentData!$C$13:$C$300 On a different sheet in the same workbook I want to use this range in an AVERAGEIFS...

Hi For those who watched this thread. So far we are in the third version of this: http://glengilchrist.co.uk/csv/table3.html Back to the original post and what you see there is pulled straight from a csv file exported from Excel. No tweaking in Excel, just dumped into csv and imported...

Hi Bob So, I've been playing with this as it really intrigues me. Reading a csv into a web page is not trivial as it is not part of the core html set (html5 does have the function, but I dont play with the big boys!!) But, you can achieve it with some ajax / javascript code. Have a look...

Hi Found this on the interweb.... "Actually you can import multiple xml files into Excel (at least I could in 2003). If the files have identical structure create a map from any of them. Then just import the files you want through Data - XML - Import. The files should be located in one...

Hi If Excel is running 24/7 I guess you could write some VBA. If not, you need an application to schedule the file to open. On Windows 7 http://windows.microsoft.com/en-GB/windows7/schedule-a-task But just Google scheduler and this should throw a few suggestions. Luck G

Hi I go for the KISS approach. Currently downloading a html5 ide to see if I can make this work, properly formatted on mobile devices. Seems to me a table, with pages approach (with the different "bugs" on pages is the way to go). Then I can display a page with ALL the drug info on...

Rhoyt Is the "app-ness" of this most important? I can create a html web page that pulls in the data from .csv file (from Excel) into a table that allows you to search / select from drop down combo boxes - quite easily. If the .csv is stored in a Dropbox public folder, then uploading...

Hi As a long time lurker and recent forum convert, this question as really grabbed my interest. Do you mean something that looks like this: https://pm.caregroup.org/abgm.asp From a website that seems to be talking about what you want to do...

Hi all I'm Glen from Newport, Wales. Brief bio: High School Science Teacher Data nut Love visualization Looking to contribute / ask / learn and all things Excel. G