Excel query not producing any results

[wadjssd]

I am querying a data range within an Excel spreadsheet to extract the records that match my criteria. Two of the columns in my range are IDNO and NAME, which are numeric and text respectively. If I set up my criteria range using IDNO, I get perfect results. But if I use the text field NAME, I get no records back, even though I can see them in my original data range. Any ideas on why this may be happening? I REALLY need to run this query based on the NAME field.... :O(

Thanks

 

[DaleWatson123321]

wadjssd,

I could "take a stab" at the cause of the problem, but my preference would be for you to send me the file (or a scaled down version if need be - with sensitive data replaced with "dummy data" if need be).

I'm VERY confident that I can resolve your problem, as this is an area where I've been spending a great deal of time.

This approach of dealing with the actual file will likely be much quicker and much more specific, and save everyone some time.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[AngO]

wadjssd,
I'm sure Dale can help you as he mentioned. I would also like to follow the thread.

Could you please specify what method you are using to "query" your data range?
Thanks,
AngO