# Difficult excel formula required Excel 2007

1. ## Difficult excel formula required Excel 2007

Hello

Unfortunately I am not very up on Excel formulas or explaining myself..

I have attached a excel spreadsheet trying to explain my idea, I am unsure if this is even possible as I have spent hours online trying to read through different formulas but nothing has sunk in.

Gregory

2. ## Re: Difficult excel formula required Excel 2007

that will work if you sorted date first and points;

put =IF(B18<>B19,A18,IF(A18<A19,"-",A19)) into C18 and pull down

3. ## Re: Difficult excel formula required Excel 2007

Originally Posted by AlanY
that will work if you sorted date first and points;

put =IF(B18<>B19,A18,IF(A18<A19,"-",A19)) into C18 and pull down
Hi Alan,

Thank you very much for taking the time to help me out.

The only problem with that formula is that if the points in A20 than they are in A21 then the Outcome doesn't change to the highest number. Is there any way to convert this?

4. ## Re: Difficult excel formula required Excel 2007

did you mean if points for A20 is higher than A21?
it only work if you sorted "the table first, sort by dates then by points"

5. ## Re: Difficult excel formula required Excel 2007

=IF(COUNTIF(\$B\$18:\$B\$23,\$B18)=1,\$A18,IF(COUNTIFS(\$B\$18:\$B\$23,\$B18,\$A\$18:\$A\$23,">"&\$A18)>0,"-",\$A18))
Try this in C18 and copy towards down

6. ## Re: Difficult excel formula required Excel 2007

Originally Posted by nflsales
=IF(COUNTIF(\$B\$18:\$B\$23,\$B18)=1,\$A18,IF(COUNTIFS(\$B\$18:\$B\$23,\$B18,\$A\$18:\$A\$23,">"&\$A18)>0,"-",\$A18))
Try this in C18 and copy towards down
Thank you Siva that is exactly what I was trying to ask for!

7. ## Re: Difficult excel formula required Excel 2007

Thanks G920 for your feedback and reputation points

There are currently 1 users browsing this thread. (0 members and 1 guests)