Forum Discussion
Solved
IFS or anyother function
Dear Experts, I have a data like below:- So, Column "B" - sfn can go from 0 ~ 1023, and Column-"C", can go from 0~19, Column "G" has 3 values(rnti's) - Now, we have only 2 ...
Not sure I understood the logic correctly. As variant
=IF( D2=D1, H1, "fdm-" & COUNTIF(OFFSET(D2, 0,0, 10), D2 ) )and fill down. Please check in attached.
You are welcome
