Excel formula needed

I hope to find an excel expert who can help create a formula, which would
Take the beginning score and subtract it from an ending score on each account number (there will be several scores for each acct #, but we just need the difference from the first score and the ending score and have that number placed in a cell. We currently do this manually, each month.

I've attached a sample worksheet.
If you can help, it would be so appreciated.score-sheet.xlsx

The Match function finds the row number of the first occurrence of the acct# and Max function find the last. Indirect is used to find the score associated with those row numbers. Conditional formatting is used to "white out" the duplicate values.

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

For those of you looking at Max & Min scores, the question was relating to First and Last score. Looking at the first acct# the first and last are not the same as Max and Min.

You could however use the Max and Min on the dates.

@cheryl23 - are the scores cumulative or is each entry the score for that date? For acct# 121300 are you expecting result of:
1) -15 8 on 20 May less 23 on 20 Jan
2) 86 109 cumulative to 20 May less 23 on 20 Jan
3) Something else?

Wow, thanks so much for the responses. I really appreciate your time.
@Aikimark - Your question: How many unique acct# values will you have? For the 6 month period we are reviewing there are 361 unique acct#s
Rob Henson: Your question: are the scores cumulative or is each entry the score for that date? The scores are not cumulative. 1) 15 8 on 20 May less 23 on 20 Jan (this is what we are looking for POSITIVE 15, 23 minus 8)

Background: We give an assessment and take the total score for that date. We give assessments throughout the treatment period. We look at first score and compare to last score (most recent date). If score has decreased, improvement has been made during treatment (a lower INDIVIDUAL ASSESSMENT SCORE is better). In the example above 23-8 = 15 would show a 65% improvement.

I need to review & test the solutions submitted, may take a couple days. Thanks to all.

It is certainly simpler than my first pass and second pass. Glad you liked it. The first time I used this type of formula was for an EE question that needed to create sequence/ID numbers within same-valued cell ranges.http:Q_27768088.html#a38133521

I pondered and ADO solution, but didn't try it since the OP asked for a formula solution. An example of an ADO solution is here if you're interested: http:Q_27515061.html#a37369496

Are you wanting to add an entry against each person or would you be interested in a separate report whereby you enter/select the patient acct# and the report shows you the required info for that person?

As a separate report you could make use of DMIN and DMAX functions.

Let me know if you are interested in that approach and I will work a sample for you.

Since the original request was to "Take the beginning score and subtract it from an ending score on each account number...", I think this:
=IF(A3<>A2,F1-C2,"")
should have been this:
=IF(A3<>A2,C2-F1,"")

And if there is any possibility of having only 1 score for an acct #, then both of the above will give incorrect results, as the result should technically be 0, since X - X always = 0. I think this would fix that:
=IF(A3<>A2,C2-F2,"")
I know the original request said "there will be several scores for each acct #", but it's hard to be sure whether cheryl was trying to imply that there will never be only 1. What say you, Cheryl? Either way, I think the last option above should work.

I'm well aware of that, aikimark, that's why I said:
"...and column F contains the [insert: 'score from the'] earliest dates, right?".
If you can explain what is wrong with the logic of my last post, we might get to the bottom of this. Maybe I'm missing something.
Thanks.

There is a definitional interpretation between "first" and "last" and earliest and latest. That is all. Your version of the formula is probably what the OP used. I didn't ask, since the OP didn't post a comment about my formula results or how to use the results. I do not think there is any "bottom" to get to.

In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…