Identify Offset Line

[Raghava@rock]

Hi there,

I am looking for a formula or a vba code that code identify the offset line in a huge data set. Below is a sample.

Thank you .

 

[vletm]

Raghava@rock
Would You update Your sample file based Your a huge data set expected results?

 

[Raghava@rock]

I would not be able to do that , I can apply and update formula based on what I get response in this forum to my actual data

 

[vletm]

Raghava@rock
You have sent few rows data,
but You cannot send
what do You want to get even from those few rows?
Eg if I would send something solution, which gives letter "A" in cell AB234 ... would You be pleased?