Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am working on creating a worksheet which will help me keep track of the
players stats in a game I am running. The Spreadsheet currently Tracks the following fields. Date Posted, Poster, Contract/Objective, and Words I enter the data daily as players submit their posts and record the date, name, and count of their words. Thus far I have figured out how to use named ranges to make a report on the sheet to show total posts and wordcount. Postcount: =COUNTIF(PosterRange,"=<postername") Wordcount: =SUMIF(PosterRange,"=<postername",WordsRange) The problem I have been encountering is that I have been having to manually paste in the new last date posted into their row on the sheet. What I would like to do is have that become a field which looks through the PosterRange and finds the Last instance value that belongs to that Poster. And then returns the DateColumn in that row. I've tried a few different scenarios, but all of them seem to either return a bad date (something ala 1900s), or returns the first date found for the user and not the lance. I'm stumped here. Any suggestions? Some sample data: Date Poster Contract Words Monday, October 02, 2006 John Objective-I 1705 Monday, October 02, 2006 Margo Objective-I 769 Tuesday, October 03, 2006 Kyle Objective-I 671 Thursday, October 05, 2006 Kyle Objective-I 1372 Thursday, October 05, 2006 Margo Objective-I 667 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum column based on value in each row, if two cells equal, or if date is within time period | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
date formula | Excel Discussion (Misc queries) | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
Find a time value in one column based on names in another | Excel Discussion (Misc queries) |