Originally Posted by José Augusto Try in J8 the array formula and copy down Formula: Select Code copy to clipboard Formula: =IF(ISNUMBER(F8),$K8/MAX(--($D$8:$D$103=D8)*$G$8:$G$103),"") $K8 instead $k$8 Perfect! Thanks!
=IF(ISNUMBER(F8),$K8/MAX(--($D$8:$D$103=D8)*$G$8:$G$103),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks