Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 10th 20, 07:14 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2019
Posts: 49
Default 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   Report Post  
Old May 11th 20, 05:40 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2019
Posts: 49
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filter and relations between fields Dennis Cheung Excel Worksheet Functions 1 September 15th 09 02:23 PM
Macro needed to identify value and delete row if value below targe Pyrotoy New Users to Excel 3 December 9th 08 11:35 PM
Macro needed to delete rows simmerdown Excel Programming 4 March 27th 06 04:00 PM
Can I create a macro to identify and delete blank rows in a range? carlsondj Excel Programming 6 June 10th 05 12:38 AM
VBA code or formula needed to identify certain records in a database Paul Simon[_2_] Excel Programming 1 August 16th 03 02:21 PM


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017