Dear Expert and the other
could you help me how to Highlight the last result of SUMIFS in this sample
Dear Expert and the other
could you help me how to Highlight the last result of SUMIFS in this sample
What's the logic??? Highlight the last non-blank cell in column L? Why is L3 highlighted? Please explain in more detail what you want.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
actually I need to mention one result in the last cell, L2 & L3 is same
I do not understand what you have just said...
L3 and L2 same, but could it be highlight, perhaps by using conditional formatting for the last cell result?
I think I understand. Why no highlight of L4? It is also a last value...
Maybe this:
=AND(COUNTIFS($C$2:C2,C2,$D$2:D2,D2,$L$2:L2,L2)=COUNTIFS(C:C,C2,D:D,D2,L:L,L2),COUNTIFS(C:C,C2,D:D,D2,L:L,L2)<>1)
L4, L7 and same result
Once agaain, I do not understand you. The sheet highlights the two cells required. If that is not what is wanted, repost yous sheet showing what IS wanted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks