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.
Thanks HansVogelaar​ , but seems there's some discrepancy.. see below( also wanted to mentioned the SFNs, will range from 0~ 1023 and then again start from 0, so somehow need to use like MOD function as well to take it into account:-
Br,
Anupam
You entered the formula in E3 instead of in E2.