I need to know if it is possible to identify which fields equal a certain amount on a row by row basis. Say for example I had an amount of 30, I would need field C to be flagged from the table below. Please see the before and after tables below for illustration. Before: ABCDEF102030405060 After: ABCDEFG (fields equal to 30)102030405060C If I could take this to the next level and have separate columns indicating if any 2 fields sum to a certain amount also that would be even better (i.e. with example above A and B would be highlighted as they sum to equal 30). Realise this is far more tricky though so I'll be happy with solution to first example. Thanks for any help.

Identify fields that sum to specific amount

I need to know if it is possible to identify which fields equal a certain amount on a row by row basis. Say for example I had an amount of 30, I would need field C to be flagged from the table below.

Please see the before and after tables below for illustration.

Before:

A	B	C	D	E	F
10	20	30	40	50	60

After:

A	B	C	D	E	F	G (fields equal to 30)
10	20	30	40	50	60	C

If I could take this to the next level and have separate columns indicating if any 2 fields sum to a certain amount also that would be even better (i.e. with example above A and B would be highlighted as they sum to equal 30). Realise this is far more tricky though so I'll be happy with solution to first example.

Thanks for any help.

Datasets

Macros

Preparation

Data Investigation

Accepted answers

ponraj

Here you go!

Workflow Results Results

Identify fields that sum to specific amount_Version2.yxmd

All comments

ponraj

Here is the sample workflow for your case. Hope this is helpful.

Workflow Results Results

Identify fields that sum to specific amount.yxmd

rossEY

Thanks Ponraj, I think that's halfway there. I may need to refine my question however.

So my end goal is really the following:

Ref	Date	A	B	C	D	E	F	Amount to Match	Field Matched
123	01/01/2018	10	20	30	40	50	60	30	C
456	01/02/2018	10	15	20	25	30	35	15	B
789	01/03/2018	10	12	14	16	18	20	18	E
101112	01/04/2018	20	23	26	29	32	35	20	A

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335