LinkBack URL
About LinkBacks
Hi
I try to count the time when home team has had their last home game or away game. Same thing with away team. There is something wrong in my formula because i get weird values for example in cell g7 and h4. What should i do?
Hi
I try to count the time when home team has had their last home game or away game. Same thing with away team. There is something wrong in my formula because i get weird values for example in cell g7 and h4. What should i do?
Hello,
You will need to change the reference to match each other. Here is your formula
=($C2-INDEX($C2:$C$3160,MATCH(D2,E3:E$3160,0),1))
Here is what it should have been
=($C2-INDEX($C3:$C$3160,MATCH(D2,E3:E$3160,0),1))
Previously your formula is returning the cell in the row above where a match is found.
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks