Thread: Datediff()
View Single Post
 
Old 06-23-2018, 01:25 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Quote:
Originally Posted by otuatail View Post
What I need is to divide by the number of rows selected by
=INDIRECT(I1)-INDIRECT(H1)
Something like?
Code:
=(INDIRECT(I1) - INDIRECT(H1))/(ROW(INDIRECT(I1))-ROW(INDIRECT(H1))+1)
Last edited by ArviLaanemets; 06-23-2018 at 04:36 AM.
Reply With Quote