Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a table that i broke into groups based on a key characteristic. I
separated the groups with 2 blank lines. I want to make sure that another value associated with the key value is constant within each group. I think it can be done with "IF" statements but I'm not sure what to write. Here's an illustration of what I have and what I want: KEY1 5555 KEY1 5555 KEY1 5560 I want to flag this as "WRONG" in the column adjacent to the data. In the above instance all numeric values should have been 5555 within this group. I want to flag errors so that I can manually repair them. I don't understand VB for the most part so if I can handle this with IF or nested IF's I'd probably be able to handle that. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I chart two separate sets of x and corresponding y values . | Charts and Charting in Excel | |||
How do I plot several sets with different x values in the same plo | Charts and Charting in Excel | |||
unique values within groups | Excel Worksheet Functions | |||
validating cells in the same row has unique values | Excel Worksheet Functions | |||
Checking 2 sets of values to provide True False | Excel Worksheet Functions |