My code =IF(G2=0,0,(SUMPRODUCT(I2:I720=I2)*(J2:J720>J2))+1)
It works if I use column H, but when I use column I, I keep getting an error...
Help?
Thanks
My code =IF(G2=0,0,(SUMPRODUCT(I2:I720=I2)*(J2:J720>J2))+1)
It works if I use column H, but when I use column I, I keep getting an error...
Help?
Thanks
Yes, because you have errors (#N/A) in Column I. You need to clear them out first.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
maybe with an pivot table, and ten sort on column B.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
As ChemistB noted, you have #N/A errors that can cause problems.
Either get rid of the errors and use your SUMPRODUCT formula or you can keep the errors and use this array formula**:
=IF(G2=0,0,SUM(IF(ISTEXT(I$2:I$720),IF(I$2:I$720=I2,IF(J$2:J$720>J2,1))))+1)
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks