| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to compare a cell to find same value in a column in Excel
I have customer data in an Excel spreadsheet with about 500 customers IDs in
one column and a list say 60 delinquent customer's IDs in another. I want a simple formula to state whether a customer on the list is delinquent or not, preferably to put a "1" in the column if the customer is on the delinquent list, and a "0" if the customer is not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Threaded Mode
