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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to compare a cell to find same value in a column in Excel
Try this:
For CustomerID's in Col_A on Sheet1 Delinquent list in Col_A on Sheet2 On Sheet1, A1: (some customerID) B1: =--ISNUMBER(MATCH(A1,Sheet2!$A$1:$A$100,0)) Adjust ranges to suit your situation. Does that help? *********** Regards, Ron "Diane Briltz" wrote: 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. |
Reply |
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 |