Please see attached file with formulas
Formula in D3 is to get unique year criteria
Formula in E3 is to get desired result ***an array formula must be entered with Ctrl+Shift+Enter key combination.
Please see attached file with formulas
Formula in D3 is to get unique year criteria
Formula in E3 is to get desired result ***an array formula must be entered with Ctrl+Shift+Enter key combination.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks