LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 50
Default Extract data from database

We have to maintain our client database like
A B C D
1 Receive Date PAN No. Name Address
2 16/01/2008 ABCDE1234F ABC & CO. Nagpur
3 16/01/2008 PANNOTAVBL XYZ PVT LTD. Kanpur
4 17/01/2008 PANNOTAVBL NTCP INTL Kolkata
to be continued.....
now I would like to extract the data from this databse whose received date
or pan no ("PANNOTAVBL") is same in sheet 2 & 3 respectively.
so is there any formula to do this same, thanks in advance

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tying to extract all data from a pivot pulling from external data Ted Urban Excel Discussion (Misc queries) 3 September 14th 07 10:50 AM
Manipulation of Data extract from Access Database Chase Excel Discussion (Misc queries) 2 July 19th 07 07:42 AM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
how to extract a figure from a database mercialex Excel Discussion (Misc queries) 1 March 31st 06 03:15 PM
In Excell-2000, database how do you extract unique records bgpereira Excel Worksheet Functions 5 December 24th 05 06:47 AM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"