Forum Discussion
Solved
Charting help needed
Dear Experts, I have a data like below , in columns A~H:- It has 2 rnti's( 2,18,66 and 53714), and in column "E" , is the time-difference between two consecutive SFNs, for th...
In E2 (not E3):
=IFERROR(LET(n, (C2-XLOOKUP(G2, G$1:G1, C$1:C1, , , -1))*10, n+10240*(n<0)), "")
See the attached version.
So, 21-1013 = -9920 is a -ve number so it should be added by 1023 = 32 then multiple by 10 = 320 , shall be the result in above case
Br,
Anupam
In E2 (not E3):
=IFERROR(LET(n, (C2-XLOOKUP(G2, G$1:G1, C$1:C1, , , -1))*10, n+10240*(n<0)), "")
See the attached version.
Thanks HansVogelaar​ may I also request for a Legacy formula, not using LET/LAMBDA...
A legacy version:
=IF(COUNTIF(G$1:G1, G2)=0, "", (C2-INDEX(C$1:C1, MAX((G$1:G1=G2)*ROW(G$1:G1)))+1024*(C2-INDEX(C$1:C1, MAX((G$1:G1=G2)*ROW(G$1:G1)))<0))*10)
You'll probably have to confirm it by pressing Ctrl+Shift+Enter to turn it into an array formula.