Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed for identify relations between rows.
Hello,
Allways nice to figur something out that's looks impossible. Perhaps a challange for somebody :) I've got a sheet with several records and I have to check some relations. It's looks to complex to do this by formulas so perhaps a code (which is to complex for me) can help me out. In text it looks like; The code should runs resulting in column AE; For each row from record 2 till last; for each row i start rule; If(AAi<4 then set 0 END CODE otherwise; If(and(AAi=4;CBi="") then set 2 END CODE otherwise; If field CBi containts neither "*K*" or "*Z*" then set 3 END CODE otherwise; if field CBi contains text "*K*" then check in all other rows (except in row CBi !!) where the name in column AH (all rows!!) is the same as the name in field AGi, then check if in at least one of the rows of those identical ones, if in column CA also one times at least the text "*K*" is registered. If it is then register "K-oke" and otherwise "K-noke" otherwise; if field CBi contains text "*Z*" then check in all other rows (except in row CBi !!) where the name in column AH (all rows!!) is the same as the name in field AGi, then check if in at least one of the rows of those identical ones, if in column CA also one times at least the text "*Z*" is registered. If it is then register "Z-oke" and otherwise "Z-noke" So, that is looking complex. Somebody like to solve. Please help ! regards, Johan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed for identify relations between rows.
One misstake....
if field CBi contains text "*Z*" then check in all other rows (except in row CBi !!) where the name in column AH (all rows!!) is the same as the name in field AGi, then check if in at least one of the rows of those identical ones, if in column CA also one times at least the text "*Z*" is registered. Should be; if field CBi contains text "*Z*" then check in all other rows (except in row CBi !!) where the name in column AH (all rows!!) is the same as the name in field AGi, then check that in none of the rows of those identical ones, in column CA the text "*K*" is allowed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter and relations between fields | Excel Worksheet Functions | |||
Macro needed to identify value and delete row if value below targe | New Users to Excel | |||
Macro needed to delete rows | Excel Programming | |||
Can I create a macro to identify and delete blank rows in a range? | Excel Programming | |||
VBA code or formula needed to identify certain records in a database | Excel Programming |