query

[gronkette1]

Is this easier to do in Access?

I have a file with temperatures for 24 hours from 3 different sources from 1997 to the present. I need to 'find' the closest temp by time from the source....

I'll need to custom search by filling in the source, date, and time.

thanks

 

[PaddyD]

Hi,

"Is it easier to do in Access" - depends! If you've got hundreds of thousands of rows of data, Access is likely to be your best bet. If your data fits on a spreadsheet, no reason why excel can't do the multi key lookup.

Post bcak with more info - how many records, where they are on your sheet, give an example of the problem & the expected outcome.

Paddy