A formula that tells me if an account is active based on data in a table

**mfairhurst1** · 10-13-2013, 03:07 PM

Hi there,

I hope you are well!

I am trying to find a formula that makes a cell say "Account Active" if any of the accounts are active in a table.

I have attached a spreadsheet with further information in. Please feel free to have a look and give it a go!

Thanks

Mike

Active Account.xlsx

**Pepe Le Mokko** · 10-13-2013, 03:13 PM

Perhaps

Please Login or Register  to view this content.

**Pete_UK** · 10-13-2013, 03:14 PM

Try this:

=IF(COUNTIF(I7:I13,"yes")>0,"Active","Not Active")

Hope this helps.

Pete

**Ace_XL** · 10-13-2013, 03:14 PM

use

=IF(COUNTIF(I7:I13,"Yes"),"Active","Not active")

**mrice** · 10-13-2013, 03:14 PM

Try

=IF(COUNTIF(I7:I13,"Yes")> 0,"Active","Not active")

Say "hello" to Wigan for me, I originate from a couple of junctions up the M6 in Leyland.

**mfairhurst1** · 10-13-2013, 03:24 PM

Thank you for your responses everyone. Those formulas work brilliantly!

**Pete_UK** · 10-13-2013, 03:31 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks,

Pete

A formula that tells me if an account is active based on data in a table

LinkBack

Thread Tools

Rate This Thread

Display

A formula that tells me if an account is active based on data in a table

Re: A formula that tells me if an account is active based on data in a table

Re: A formula that tells me if an account is active based on data in a table

Re: A formula that tells me if an account is active based on data in a table

Re: A formula that tells me if an account is active based on data in a table

Re: A formula that tells me if an account is active based on data in a table

Re: A formula that tells me if an account is active based on data in a table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to pull data based on Filtered results - To create Statement of Account

[SOLVED] How to censor account numbers based on how many characters are in the account number

[SOLVED] Formula that tells me whether a date is later than the current.

Adding formula to active table and for pivot table in macro

Filtering a data table based on multivalue active cell

Bookmarks

Bookmarks

Posting Permissions