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  Register To Reply

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  Register To Reply

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?  Register To Reply

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"  Register To Reply

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  Register To Reply

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!  Register To Reply

7. Re: Difficult excel formula required Excel 2007

Thanks G920 for your feedback and reputation points  Register To Reply

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