E3=aggregate(16,2,a2:a100/(a2:a100<>"")/(a2:a100<=d3),0.5)
E3=AGGREGATE(16,2,A:A/(A:A<>"")/(A:A<=D3),0.5)
empty cell are zero in Array
E3=aggregate(16,2,a2:a100/(a2:a100<>"")/(a2:a100<=d3),0.5)
E3=AGGREGATE(16,2,A:A/(A:A<>"")/(A:A<=D3),0.5)
empty cell are zero in Array
Last edited by CARACALLA; 10-25-2021 at 03:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks