Return Latest Attempt At Exam From A List?
Mar 10, 2014
I have a list of students that have sat a number of exams on different dates. Can I pick out from the list the last exam for each person. I can sort by id number and then by date but how do I then show the record showing the latest date for each person?
Example
Mary 1/2/2012
john 2/3/2012
john 1/3/2012
mary 1/1/2012
mary 4/4/ 2012
I want to select the record showing the latest date for each person. the result would be
mary 4/4/2012
John 2/3/2012
View 7 Replies
ADVERTISEMENT
Aug 5, 2012
I have a table with different values on different dates. To get the newest value on the lastest date I'm using this formula; =INDEX(F5:K5;MATCH(9,99999999999999E+160;F5:K5)).
However, how I can get the second latest value? In this example I want a formula to to return the value previous price;
Latest observation
Latest observation date
Previous price
previous price change date
01.08.2012
02.08.2012
03.08.2012
04.08.2012
05.08.2012
06.08.2012
[code]....
View 8 Replies
View Related
Oct 11, 2012
I am in need of a vlookup formula that will return a value that corresponds to the latest day in a month. Example:
Column A had dates in format 1/3/2012 ect....
Column B is a $ amount
Column C is a date in format Oct-12 ect...
I want column D to be a formula that match up column C's month in column A and return the $ in column B that corresponds to the latest day in the month. IN the example above it would returna value for Oct 31 (if there was one), Oct 30 next and then Oct 29 ect...
So if column A had October dates of: 10/1, 10/4, 10/17 and thats it in Oct then it would show the 10/17 $ in column B.
View 2 Replies
View Related
Dec 21, 2012
I'm working on a project with tables. I'm not sure if I can use a function or I have to vba. I want to retrieve the lastest 5 entries for a specific column (column AA), but not blank ones. Then I want to retrieve latest 5 entries for column AC. On a seperate sheet I want the entries to be seen in order and I want it to change as new data is entered into the table. In the end I'll have the latest 5 entries for Internal (Column AA) and then after that the latest 5 entreis for External (Column AC).
View 3 Replies
View Related
Jan 18, 2008
I am trying to use a function to search for a particluar value (e.g., ssn) in one column and return the "InDate" in another column. I thought this would be easy, but I'm having considerable trouble. When I do manage to get a value returned, it's the wrong value. I need to return the most recent "InDate" for the ssn that I search for. The button on the " Lookup" sheet is to sort the InDate column descending so that the Excel function will start with the most recent date when it searches. I've tried Lookup and and just about every other similar function with no luck. I originally wanted to search for a ssn and return the information for the last 5-10 most recent visits, but gave up on that long ago.
View 2 Replies
View Related
Nov 11, 2009
I have text in column X and dates in column A...
How can I return the last (latest) date (column A) that "hold" was used (in column X)?
View 9 Replies
View Related
Jul 25, 2014
I am looking for a formula that returns the latest Sale date for a each model of car. Below is sample data which I am trying to use the formula. I tried with below formula, but not successful.
=MAX(INDEX($A$1:$C$40,MATCH(A2,$A$1:$C$40,0),3),1)
MakeModelSale Date
AudiA4 11-Jan-14
AudiA4 quattro 12-Jan-14
AudiA4 quattro3-Jan-14
AudiA5 Cabriolet 14-Jan-14
AudiA5 Cabriolet q15-Jan-14
AudiA4 16-Jan-14
AudiA4 quattro17-Jan-14
AudiA4 quattro18-Jan-14
AudiA6 quattro19-Jan-14
AudiA4 10-Jan-14
AudiA4 quattro09-Jan-14
AudiA4 quattro10-Jan-14
AudiA4 11-Jan-14
AudiA4 quattro11-Jan-14
AudiA4 quattro11-Jan-14
AudiA8L 11-Jan-14
AudiA8L 11-Jan-14
View 3 Replies
View Related
Apr 16, 2013
I have data for various firms - such as revenues, employees, etc. - for multiple time periods. There is no uniformity, so for some firms I'll have data for 8 time periods, for others for 1, for others for 30, etc. I have hundreds of columns, but the three relevant ones are: in one column is firm ID, in another column in reporting date, and in another column is number of employees.
The attached sample data will make it easier to understand.
I'd like a summary table that tells me the most recent reported number of employees for each firm, and the date of that reported figure. If that firm never reported any employee figures, then the summary table should still have a row for that firm ID, but blanks in the 'reporting date' and 'employees' columns. So, the summary table should be 3 columns - firm ID, reporting date and employees.
The challenging aspect is that the most recent reported employee figure is not always the most recent date on which we got data from the firm (so I can't just do a sort followed by a 'remove duplicates'). It'll need either a multi-step formula solution or a VBA code (that's my guess).
The attached sample data will make it easier to understand. It has the form of data I have and the desired output form.
Excel help needed.xlsx‎
View 3 Replies
View Related
Dec 10, 2012
I'm trying to return a distinct list of rows that filter based on the latest date and largest quantity for each distinct AccountID and ProductID combination.
I tried some variant of the =max function, but I need two filters.
The purpose of this is to create a data set of all company accounts with the most recent number of products used to upload to a database.
The simplified and original data set is as follows:
AccountID
ProductID
Company
Date
[Code].....
View 7 Replies
View Related
Oct 9, 2008
In the attached workbook - the stock Inventory is increased, every second day, by the value shown in cells of column A. Column B displays the date of the update. I'm looking for a Formula (might be an Array Formula) that will return the latest date before the stock turns to be greater than the value in cell D3. I managed to solve it, in cell F3, but with the help column C.
View 2 Replies
View Related
Dec 24, 2013
How to find the latest price by each sku in the list, the list contains many skus.
View 13 Replies
View Related
Oct 12, 2007
I have a faculty member who needs to regrade an exam. (a CMS problem). The answer key is on one page and each of the individual student submissions are on subsequent pages.
The students all received exams that had the questions and the answers scrambled.
I need to find a way to match the question from the submission to the same question in the answer key and return the correct answer to a new column on the student submission.
A few issues:
* Some of the questions have multiple answers and the submission log lists each as a separate question. (ie. Answer Key #69)
* Not all of the "Correct Answers" are in the same column on the Answer Key (ie. Answer Key #70)
There are about 140 submissions all together -- I need some help trying to figure this one out.
View 9 Replies
View Related
May 31, 2007
I have a spreadsheet and it shows a raw data dump of all sales transactions per product. This has been transferred via ODBC and I need some sort of query to filter out the data.
Is there any way I can write a query to only bring in the latest transaction based on the sale date per product?
Columns are:
Product Code|Last Sales Date|Cost Price
View 9 Replies
View Related
Jan 6, 2014
I am working on a large data file (leasing file), that has many duplicates. The names on the file are duplicated due to the various variable costs associated with leasing. I need to remove the duplicates names based on the latest contract end date.
View 4 Replies
View Related
Mar 29, 2007
I want to maintain a history of exam results held on different dates
For this purpose I created a file with three sheets named Inputs, Working & result history. Description of all sheet is as follows :
“Inputs” Used as main Input file to feed marks for each subject on certain exam date.
“Working” Linked with sheet inputs and perform calculations ( total marks, % etc)
“Result History” Date wise history of exam results based on sheet (working).
Required Solution Steps:
1.Score entered for different subjects in Sheet “Inputs” for a particular exam date.
2.Obtained marks are totaled and score % calculated based on scores entered in sheet inputs.
3.Date wise history of exam results recorded based on working sheet.
To transfer/copy/paste results from “Working” sheet to “Result history” sheet I recorded a macro which is linked with a button. This macro copy record from working sheet and paste it as value to result history sheet....
View 6 Replies
View Related
Jan 20, 2012
What criteria can I use to filter a list on and item and the latest date?
I need to extract a list of all items but only with the latest date of each ...
View 3 Replies
View Related
Jul 25, 2014
I'm trying to pull the earliest and lasted times out of a list of time stamps. Say I have a column full of clock in and clock out times and wanted to find the first clock in time and the last clock out time (just an example). My lookup_value would be a Store number. I can't post it here due to legality reasons, but I have a column a store numbers that will be my lookup values and I need to find the earliest and lastest time in a list of data on another tab.
View 9 Replies
View Related
Feb 23, 2007
My file has 8 sheets with identical linked drop-down boxes at the top. Sheet1 has a graph that needs to be sorted from top to bottom each time a drop-down box from any of the sheets is adjusted. Using tips from this site, my macro moves to Sheet1, sorts, and then returns to whichever sheet I start at.
This works if the first drop-down box I adjust is from Sheet1. If the first drop-down box I adjust is from any other sheet I get "Run-time error '1004': Sort Method of Range Class Failed." Basically I get an error unless I use a Sheet1 drop-down box first. After using a Sheet1 drop-down box, all sheets work without error. How can I fix this error? Below is my macro................
View 4 Replies
View Related
Jun 23, 2014
So this is my first attempt at creating a UserForm progress bar. I currently have the status bar doing basically what I am trying to accomplish but I'm trying to broaden my skills (BTW, I've deleted all company sensitive data but the code should still work for you). I got almost all of this code from microsoft's web page on UserForm Progress Bars and then modified it to work with my existing code. When I execute the code (Click the macro button) the UserForm comes up, but the progress bar is not updating like I was expecting.
View 1 Replies
View Related
Nov 14, 2005
I've attached a spreadsheet which is a basic version of what I'm trying to achieve. I've got a pivottable based on 3 columns of data: Order No, Delivery Date, Value
I want the sum of a given order in a certain month. E.g. the value of Order No. 1001 for Dec '05. I tried doing a pivottable and then using GETPIVOTDATA (which I've not really used before) and failed. I imagine there's a better way I've not attempted yet. Can anyone shed any light? The spreadsheet is attached
View 7 Replies
View Related
Dec 30, 2008
Created a button in a spreadsheet but cannot activate the shortcut menu that contains "assign macro." Help says select the button, right click on a handle and a shortcut menu appears with "assign macro." Not. I right clicked every handle numerous times and get the regular shortcut menu without the "assign macro" option.
View 9 Replies
View Related
Jan 29, 2007
I am trying to write a code enabling some calculations. As part of this code I want to find an integer in an excel range. I set the variable (integer) as Rvalue and wrote the following:
Selection.Find(Rvalue).Activate
which works fine as long as the find is successful. The issue I have however is when the variable cannot be found. I tried using the "iserror" function in vba but it appears that excel/vba does not recognise this issue as an error; I could use an excel formula (i.e. if(iserror(vlookup...) but I would prefer to find out how to handle the issue in vba.
View 2 Replies
View Related
Feb 7, 2013
I've attached a sample excel for what I'm looking to do. Basically, based off a search box(drop down), I'd like to automatically populate a list of non-blank ingredients in another list.
View 3 Replies
View Related
Oct 4, 2009
I am trying to find the largest value, second largest, and third largest value for a column of numbers then return a content value for the adjacent column that contains the name for which each. The problem I am running into is when the second highest has the same value as the highest and also when the third value is zero (n=meaning there are only non-zero numbers for the column). I am using these formulas currently whic work when the numbers are not the same and I have atleast 3 non-zero numbers but I need to modify in order to account for the problem stated above...
View 8 Replies
View Related
Mar 9, 2014
i have several styles to handle mentioned under different rows separately.
all the styles have their various raw materials inward date mentioned under different column of their respective rows from column Q to Y
now i need to 1. extract the latest date of any particular raw material which can be in any of column from Q to y columns ACCORDING TO DIFFERENT STYLES IN A Particular row automatically that is AC
View 1 Replies
View Related
Jan 28, 2009
is it possible to have a cell return all matches from a list and have the list of matches reduce as you type, then be able to select one item from the list? this is a typical feature on internet sites, but can it be done in Excel?
View 3 Replies
View Related
Jan 19, 2010
I have a table which has approx 20 rows and 6 columns. On each row only 1 column will have a value in it, how can i return the value of the cell which is populated?
View 2 Replies
View Related
Jun 7, 2006
Need a way to return a list of non-zero without doing sorting the column? For example, I have a list of number running down column A and I want column C to have the number running down starting from the top (in the same order as column A) but leaving out all zeroes. I've attached an example spreadsheet.
View 3 Replies
View Related
May 28, 2014
I've got a macro that gets me a list of all files in a folder, however I need it to only return .xls files.
Code:
VB:
Sub List()
Dim objFSO As Object
Dim objFolder As Object
[Code]....
View 2 Replies
View Related
Jul 13, 2009
I have a list of items and for each of them their created date. I want to retrieve the 3 most recent items on a different page.
so for example
a01 May 2009
b02 May 2009
c06 May 2009
d03 May 2009
e01 May 2009
would give me
c
d
b
View 2 Replies
View Related
