Looking some guidance:
When I post some rent payments, is there a way to show the name of the column that has the last payment posted?
In other words, when I post the Payment for August, the cell with the formula will show AUGUST.
As always, I appreciate all of the help I have received.
Roger
Yes, indeed there is a way to do it.
Let's assume that your amounts are in the range B2:B13 and your month names in A2:A13. Try this:
=INDEX(A2:A13,MATCH(99^99,B2:B13))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks