Forum Discussion
Charting help needed
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 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" ?
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
I think this does what you need.
=LET( sfn, C2, last_sfn, XLOOKUP(G2, $G$1:G1, $C$1:C1, 0, , -1), diff, IF(sfn - last_sfn < 0, sfn + 1023 - last_sfn, sfn - last_sfn), IF(ROW() = 2, "", 10 * diff) )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...