Help required in Find

[narendra1302]

Dear All,

I am having a formula in column for Complaint generation.
Now it is huge data (10000 rows). How to find a particular complaint.

e.g. if complaint no. is AB15648, CD18749,.... etc - But these are made by formula & can not catch in Ctrl+F.
If I want to find AB15648 & if I put it in Ctrl+F, it is not finding - However it is there in that field.

Thanks

Narendra

 

[xenou]

Be sure that under Options you choose:

Look In: Values

(and don't check entire cell contents)

 

[narendra1302]

Dear Xenou,

Thank you.

I am using Excel 2007 - May i know where the option Look In : Value is there

Thanks
Narendra

 

[narendra1302]

Dear Xenou,

I got it - Thanks