![]() |
#1
|
|||
|
|||
![]()
Hello,
I have a formula in google sheet but when you download as excel the formula is changed as below. Google sheet - =((QUERY(transpose(I413:T413),"Select Col1 where Col1 is not null limit 1",0))/(ArrayFormula(iferror(lookup(1,I413:T413/I413:T413,I413:T413)))))^(1/(counta(I413:T413)-1))-1 Convereted to below in excel =IFERROR(@__xludf.DUMMYFUNCTION("((QUERY(transpose (I413:T413),""Select Col1 where Col1 is not null limit 1"",0))/(ArrayFormula(iferror(lookup(1,I413:T413/I413:T413,I413:T413)))))^(1/(counta(I413:T413)-1))-1"),0.000510855849876756) Need your help in fixing this issue. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
a formula for this excel sheet: | emvella | Excel | 1 | 09-14-2019 05:57 PM |
Update Excel worksheet from Google sheet | tasneemj | Excel | 0 | 02-11-2018 12:17 PM |
Convert From Google to Microsoft for everything | MarkNicholson100 | Office | 0 | 02-23-2017 01:41 AM |
![]() |
cmcmeekin | Excel | 2 | 08-03-2016 11:32 AM |
Excel formula from looking the base date and convert into desire result | PRADEEPB270 | Excel | 1 | 02-17-2013 03:11 AM |