Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating cells in the same row has unique values
Is there a way to validate cells in the same row has uniqe values. that is
none of the information in the cells in the same row should be the same. I need this validation for the cells containing texts. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating cells in the same row has unique values
I will Use:
Dim oldAddress= acitvecell.address Find(cell value, By Row) if no error, and no change row then msgbox "duplicate found" Range(oldAddress).select Somthing like that. "Volkan Akyuz" wrote: Is there a way to validate cells in the same row has uniqe values. that is none of the information in the cells in the same row should be the same. I need this validation for the cells containing texts. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating cells in the same row has unique values
Many many thanks,
But the table I will use is something like that http://www17.brinkster.com/vakyuz/Kitap1.htm And I need to know for which lines there is a conflict (Çakışma). Such that one teacher can not take a lesson more than one. If the way you know is programming via Visual Basic, please include more details, because I am very novice in programing visual basic in Excel. Many thanks again "jchen": I will Use: Dim oldAddress= acitvecell.address Find(cell value, By Row) if no error, and no change row then msgbox "duplicate found" Range(oldAddress).select Somthing like that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Copying values but skipping empty cells | Excel Worksheet Functions | |||
How can I fix values in cells calculated by formula in Excel | Excel Worksheet Functions | |||
cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions |