Forum Discussion
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 the corresponding RNTIs.
Now , consider row number 207, for the rnti-53714, the ms(in column E) should be 885(row-207) - 855(row204) corresponding to that rnti.. while in
my formula, it messes up the analysis, as it only calculated the difference from the previous SFN, which is for a different rnti, how can I do that..
Attached is the Worksheet,
Thanks in Advance,
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.
12 Replies
Is it worth it?
My formula is slightly different and I tabled your data. I'm getting the expected result for that row:
=IF(ROW()=2,"",10*(C2-XLOOKUP(G2,$G$1:G1,$C$1:C1,0,,-1)))Thanks Patrick2788​ , one optimization if you can pls.. so the SFNs will restart after 1023,
so SFNs range is from 0~ 1023, now in a helper column say can we do something like if -ve then add 1024 and then multiply result by 10, like in below:-
Br,
Anupam
I'm not sure what you mean by "-ve" ?
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.
In E2:
=IFERROR((C2-XLOOKUP(G2, G$1:G1, C$1:C1, , , -1))*10, "")
Fill down.
