Check thisWithout helper column you can do using sumproduct
formula..for explanation i have kept formulas in the end...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 3, 2014 at 4:54 PM, Mandeep Baluja
wrote:
> Try this resolve this query.
>
Try this resolve this query.
Trying to automate this any help will be appreciated.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RU