| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF functions
Thank you,
That was exactly what I was looking for. "Bob Phillips" wrote: I suggest that you use Data Validation (menu DataValidation), with an allow type of Custom, and a formula of =COUNTIF(2:2,B2)=0 This way, the error is trapped on input. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wilhelm" wrote in message ... I cannot figure out how to make an if function (or macro?) which returns e.g. the value false or error if the data in a certain cell already exists in another cell in the same row. I have made a table which shows which workers are working which day and at which machine. The days are in the left column and the machines in the top row. The workers(using last names) are in the cells inside the table. The function should check or prevent that the same worker is working at two different machines at the same time. In other words the same data cannot be in two different cells in the same row. Should I use some kind of if function or would a macro work better? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
| excel functions and User defined functions | Excel Programming | |||
Hybrid Mode
