Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with range name
Hi, How can I set the validation like this formula? =countif(rngCheckColumn, CheckCelladdr)<=1 -- gabch ------------------------------------------------------------------------ gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662 View this thread: http://www.excelforum.com/showthread...hreadid=542368 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with range name
Assuming A1:A10 is the range of concern, give it the RangeName of "TheRange",
by highlighting it and doing Insert Name Define and typing "TheRange" (without quotes) in the small upper box of the pop-up. Then assuming B1 is the cell you wish to validate, click on it and do Data Validation choose Custom in the Allow: window and in the Formula: window type =COUNTIF(TheRange,B1)=1 and click OK hth Vaya con Dios, Chuck, CABGx3 "gabch" wrote: Hi, How can I set the validation like this formula? =countif(rngCheckColumn, CheckCelladdr)<=1 -- gabch ------------------------------------------------------------------------ gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662 View this thread: http://www.excelforum.com/showthread...hreadid=542368 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Countif for specific cells rather than a range ???? | Excel Worksheet Functions |