Hi All,
We have uploaded a excel file, there are two sheets, sheet1 & sheet2,
we have used a formula in sheet 1, column G (its o.k.), but when we try to add a new formula in sheet2, column d not getting the result (get 4 value from formula)
we have tried it but not find the solution, in sample file, we have used the formula in sheet2 D5, pls drop down it to D16 and you find that its not working.
Maybe formula in column D is unable to get the text "Flag" that's why not taking the 4 numbers through formula
pls check and provide the solution.
Thanks
Forum link from where we have got the answer
https://www.mrexcel.com/board/thread...rmula.1131247/
Bookmarks