GROUPING AT THE ACCOUNT LEVEL

nick22

Hello,

I'm working on a formula to dynamically count the number of rows and group them together based up a condition:

My data looks like this

account # product indicator dollar value

1 c 100

1 n 150

1 n 0

2 n 250

The formula has assign if the account is "active" or "non active" based up the Product indicator = "c" and dollar value > 0.

I can do this but only at the line level with a basic formula. I need the formula to say if for the account in question if the criteria is met at least once then "active" else "non active"

any suggestions are greatly appreciated,

Thank you,

Nick

Reporting

Output

Tips and Tricks

Preparation

Accepted answers

estherb47

Hi @nick22

I think you're almost there!! A filter to find those that meet the active criteria, and then a Find Replace to bring in the status you want to use for any of the rows that are tagged as active. That will create a second status column. Empty values in that column indicate a status of inactive. Another formula tool copies over the inactive value.

Let me know if that helps.

Cheers!

Esther

All comments

estherb47

Hi @nick22

Let me know if that helps.

Cheers!

Esther

nick22

Hi EstherB47,

Thank you for getting back to me so quickly, I think this will work but I'm having trouble configuring the find and replace tool. Not all of my fields are available, so I cannot set the find and replace to look at account #.

Any suggestions?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335