| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search number within a database
I have some 20000 data for lottery in sheet 1 like :-
Sl No. Application No. Reg. No. Chque No. Name 01 17211 7552 215587 D.Gupta 02 14546 8258 112536 S.Das Continued ..... to Sl no. 20000 I have some another data for whom has win lottery in sheet 2 like :- Sl No. Application No. Reg. No. Chque No. Name 01 15311 1252 115327 M.Sharma 02 04836 4128 441562 S.Ghosh Continued .... to Sl no. 1200. Now I have to return the amount of the applicant who has not won the lottery. Is there any formula to extract the application number who has not won the lottery from sheet 1. help me |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for database search - is it possible? | Excel Discussion (Misc queries) | |||
| How do I allow visitors to do a keyword search of my database? | Excel Discussion (Misc queries) | |||
| Search & Edit in Excel Database possible? | Excel Discussion (Misc queries) | |||
| Database Search For Help? | Excel Discussion (Misc queries) | |||
| Creating A Search Database..Need Help | Excel Discussion (Misc queries) | |||
Threaded Mode
