Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete
all
text "X" rows.

Why write a function and a macro when the macro can do everything??? Have
the macro do your comparisons and delete the row.

What do you mean "Come Together"?.
How can column E have Cr and Dr amounts?

The request is confunssing.

"K" wrote:

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete
all
text "X" rows.

He means that when the credit (CR) amount cancels the debit (DR) amount they
come together? Don't you understand Brit talk Joel? <g Apparently it is a
journal listing so the debits and credits are listed in the same column. I
gave him some code to match column A and B criteria and delete the rows if
column C equaled zero for the one's that "came together", but for some reason
it didn't work on his system. I modified it to trim spaces, but don't know
if he tried that or not.

"Joel" wrote:

Why write a function and a macro when the macro can do everything??? Have
the macro do your comparisons and delete the row.

What do you mean "Come Together"?.
How can column E have Cr and Dr amounts?

The request is confunssing.

"K" wrote:

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete
all
text "X" rows.

On 26 Apr, 23:17, JLGWhiz wrote:
He means that when the credit (CR) amount cancels the debit (DR) amount they
come together? *Don't you understand Brit talk Joel? <g *Apparently it is a
journal listing so the debits and credits are listed in the same column. *I
gave him some code to match column A and B criteria and delete the rows if
column C equaled zero for the one's that "came together", but for some reason
it didn't work on his system. *I modified it to trim spaces, but don't know
if he tried that or not.



"Joel" wrote:
Why write a function and a macro when the macro can do everything??? *Have
the macro do your comparisons and delete the row.

What do you mean "Come Together"?.
How can column E have Cr and Dr amounts?

The request is confunssing.

"K" wrote:

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . *And then i need macro to delete
all
text "X" rows.- Hide quoted text -

- Show quoted text -

sorry joel i wasn't good enough to explain my question to you but
JLGWhiz has solved my problem. Thanks lot JLGWhiz my friend your code
is working superb. I have tested it on a sample sheet and it working
good. i'll go back to my office on Monday and will try this on
Original Sheet and if i have any question then i'll come back to you.
Many Thanks again