Hi. I am trying to create a formula that would display the latest date (in column A) when specific text occurs (in column B). I've attached a workbook with the desired solution. Thanks.
Hi. I am trying to create a formula that would display the latest date (in column A) when specific text occurs (in column B). I've attached a workbook with the desired solution. Thanks.
try this ARRAY formula...
=MAX($A$6:$A$10,IF($B$6:$B$10="*a b*",0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
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
3. Click on the star if you think someone helped you
Regards
Ford
Here, try this:
Formula:Please Login or Register to view this content.
Nice 1 zbor, I just noticed that mine doesnt work anyway
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks