Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I still need help with one of my requirement.
I have data coming from a database -- which i have in sheet2 of sample excel attached.
sheet1 has the data thatz in another source. sheet3 is the output i want to see after .
the requirement is : as soon as data is added to sheet2 is should cheek in sheet 1 if it exists or not .. if not set flag to 1 else 0.
tried couple of solution but nothing works . ( you can find it all my possible in multiple tabs i Qvw File)
is it null in every row?
in every row of the field row2?
yes
Why don't you just replace the quotation marks with blank?
