When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR

**jsimha** · 11-15-2012, 12:55 PM

Dear Folks,

I am working on huge amounts of data, where i have to find out incorrect condition in between records.

Col-a Col-b Col-c Col-d Col-e Col-f
AUTH_ASSISTANT SAP_R3_LG S_USER_AGR ACTVT 01 AND
AUTH_ASSISTANT SAP_R3_LG S_USER_AGR ACTVT 02 AND

Conditon :
When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR condition

but in my huge data set this condition went wrong and values are filled with AND. Now i need to find/mark records which have AND value in Cpl-f when record met with condition above. I am not able to do this in pivot or any vlookups, concat etc..

See attached sample data.

Any ideas to how to deal with this.

Regards,
Jay

**arlu1201** · 11-15-2012, 01:09 PM

If they are not equal, what should be the entry?

Should the data be sorted or is it already sorted?

**jsimha** · 11-15-2012, 01:31 PM

Data is sorted.
if condition = AND even though value from Col-1 to 6 Column- k should be updated with not ok.

**arlu1201** · 11-15-2012, 01:41 PM

What do you mean by this

if condition = AND even though value from Col-1 to 6 Column- k should be updated with not ok.

**jsimha** · 11-15-2012, 01:51 PM

sorry to create confusion.
If they are not equal, what should be the entry? it should be OR.

right now in my data set it is set to AND.

**arlu1201** · 11-15-2012, 01:54 PM

You mentioned this in post 1 -

When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR condition

That means for 2 rows, if columns A to D are equal, it should be OR.

What if they are not equal?

**jsimha** · 11-15-2012, 01:59 PM

It is AND condition.
See sample 2 file

**arlu1201** · 11-15-2012, 02:13 PM

This is what i have understood that needs to be done and i have put in my calculations in the last 2 columns. Please check and let me know if i am right or else correct it.

**jsimha** · 11-15-2012, 02:23 PM

Correct interpretation.
End record in range should be OR always.

**jsimha** · 11-16-2012, 05:29 AM

is there anyone to help on this problem.

**arlu1201** · 11-16-2012, 05:42 AM

Try this code - for the purpose of testing, i have given the output in column M. You can either change that in the code or you can check if the macro is giving right output and then just replace the contents in I with M's contents.

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

**jsimha** · 11-16-2012, 07:20 AM

Thanks for stepping up.

I tried given code. It isn't work as expected.
See file , samplefile-2.

**arlu1201** · 11-16-2012, 08:21 AM

You want columns A to D to be checked right?

What should be the output? - OR and AND or should it be OK and NOT OK?

**jsimha** · 11-16-2012, 09:50 AM

Col-B to Col-F should be checked.
And / OR values coming from system. Any my aim is to check whether they have right condition maintained or not.

That is why i want OK in col-m when condition maintained correctly. if not it is Not Ok.

Seems that we are close.

**arlu1201** · 11-16-2012, 10:41 AM

Try this

Please Login or Register  to view this content.

**jsimha** · 11-20-2012, 10:58 AM

Dear Arlette,

Thanks. I have tried it on the same day.
It doesn't work. Appreciated your support in this.

May I know your email ID?

Regards,
Jay

**arlu1201** · 11-20-2012, 11:32 AM

When you say, its not working? Are you getting any error or wrong results?

When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR

LinkBack

Thread Tools

Rate This Thread

Display

When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be OR

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Re: When values in row 1 and row are equal from Col-a to Col-d are equal Col-F should be O

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions