Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a number within data by formula
I have some data, which containing is "Reg. no., Roll no., Name, Add. " etc.
in each column, in sheet 1, and another sheet there are some data, which containing is "Reg. no. & Roll No. in seperate column. Now i want to find out fail or pass to put up the "Reg. no. in sheet 1 in another column from sheet 2 by using formula. I would not like to use ctrl+f. is there any formula ? help me |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to find how many cell have a number between 2 numbers. | Excel Worksheet Functions | |||
Best way to find row number of last row containing data | New Users to Excel | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
What is the Formula to find the Media of a number of cells? | Excel Worksheet Functions | |||
The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions |