please check, where is the problem so that not getting result in column D

Hi Ajay45822

For me, your formulas in "D" call their own result with the column "G" which creates a circular reference and is therefore not calculable by Excel

Thanks bro for giving me time on my post

Any other option, so may i get the solution

Originally Posted by BrianM45

Hi Ajay45822

For me, your formulas in "D" call their own result with the column "G" which creates a circular reference and is therefore not calculable by Excel

Thanks oeldere,

please find attached the file.

sheet1 is data, sheet2 is required result

required process is if we will get the Flag in column in F, in column D we will take the three value from column E and start search again for Flag and when we find will take the 3 values from column E

you can understand by it with our previous file.

thanks for your attention

ok, we are writing my query in detail and thank you all who have see my post and give me time

we have two points, if any one solved, my problem will be solved

Point1. What we are doing in this file – There are four entries in column D, we just want a formula who will search entry1 from next cell in column F and when find anything will show the “flag” and stop searching, when we find Flag we will put the new value in same cell column E where we have find “Flag” in column G
We have got the below solution from a thread in this forum its working fine but problem is only that we need “Flag or any other Text value” but not by doing

HTML Code: 

[>0]"Flag";""

we are attaching "file 1" where we have used a formula in "column F" which is

HTML Code: 

=IF(COUNTIF($G$4:G4,LOOKUP(2,1/SEARCH(F5,$E$4:E4),ROW($E$4:E4)))>0,0,IFERROR(LOOKUP(2,1/SEARCH(F5,$E$4:E4),ROW($E$4:E4)),""))

and after that we have done - selected range G5:G16 and applied

HTML Code: 

[>0]"Flag";""

number format.
And get “Flag” but my problem is, Can we get "Flag" in column F without doing "selected range G5:G16 and applied

HTML Code: 

[>0]"Flag";""

number format." If we can get my problem will be solved.

or can u please provide a new code

Point2. Please provide a new formula/code/vba/programme who can do all things done at once which we have asked in thread #1

After you change your title, answer awaits you.

thanks oeldere ji,

please find the file again

and Earlier Formula used in D3

=IF(OR($B53=3,$F53="Flag"),Get4Numbers($E$53:$E53),"") then copied down.

UDF Get3Numbers is used.
Code for UDF

HTML Code: 

Function Get3Numbers(Batch As Range)

Dim T As Integer, X As Integer
Get3Numbers = ","

For T = 1 To WorksheetFunction.Min(3, Batch.Rows.Count)
  If IsNumeric(Batch.Cells(Batch.Rows.Count - X, 1)) Then
    
    If InStr(1, Get3Numbers, "," & Batch.Cells(Batch.Rows.Count - X, 1) & ",") = 0 Then
    Get3Numbers = "," & Batch.Cells(Batch.Rows.Count - X, 1) & Get3Numbers
    Else
    T = T - 1
    End If
  
  End If
X = X + 1

Next T

If Get3Numbers <> "" Then Get3Numbers = Mid(Left(Get3Numbers, Len(Get3Numbers) - 1), 2)

End Function

Please read post #6., edit your first post and change your title to something descriptive of your Excel problem.
Thanks

Dear Pepe Le Mokko,

we have given the reply on #8, also change the title

and also sent u a message, please check and help

Got the solution in other Forum,

Thanks for your forum support also

Hi Ajay45822

Even if I am not an administrator, it would be good to put the solution found here.
This would allow those who will fall on this subject, to know it

Thanks