Return no value if the quantity is less than three

[Losguapos1]

Good afternoon, a while back i had some help with a formula on the attached sheet. I need to update it now. The strengths are going to stay the same, but the weaknesses (purple headers on spreadsheet) only have to show up if the value associated with it is 3 or greater. (So traits with 1 and 2 will not show up as a weakness)

I have attached a spreadsheet wit desired results.

Thanks for all of the help

Los

[Ace_XL]

use

=IF(your_formula<3,"",your_formula)

[AeroTheManiac]

Put this in cell AC3

IF(SUM(P3:W3)<3,"InsertWeaknessHere"," ")

[Losguapos1]

Ace , even if it is array formula in the cell i can just throw the if function in there?

[Ace_XL]

Ace , even if it is array formula in the cell i can just throw the if function in there?

Sure, yes

[Losguapos1]

Ace i tried that and i seem to be getting error.

Anychance you could show me what it should look like.

This is my formula

{=IF(COLUMNS($AC4:AC4)>COUNTIF($P4:$W4,">0"),"",INDEX($P$1:$W$1,MATCH(LARGE($P4:$W4-(COLUMN($P4:$W4)/1000),COLUMNS($AC4:AC4)),$P4:$W4-(COLUMN($P4:$W4)/1000),0)))}

[Ace_XL]

Try..

=IF(IF(COLUMNS($AC4:AC4)>COUNTIF($P4:$W4,">0"),"",INDEX($P$1:$W$1,MATCH(LARGE($P4:$W4-(COLUMN($P4:$W4)/1000),COLUMNS($AC4:AC4)),$P4:$W4-(COLUMN($P4:$W4)/1000),0)))<3,"",IF(COLUMNS($AC4:AC4)>COUNTIF($P4:$W4,">0"),"",INDEX($P$1:$W$1,MATCH(LARGE($P4:$W4-(COLUMN($P4:$W4)/1000),COLUMNS($AC4:AC4)),$P4:$W4-(COLUMN($P4:$W4)/1000),0))))

[Losguapos1]

So popped that in and it seemed to work but when i dragged it over and down it didnt seem to give me the desired results. It repeated some and added some in when there shouldnt be.

I am a total noob when it comes to this stuff.

thanks for all your help

Los

[Losguapos1]

ACE... Just throwing this back out there. I need a solution ASAP. I have to be able to run the data report tomorrow. Any all help would be greatly appreciated. I have reattached the sample.

Los

[Losguapos1]

Anyone's help would be greatly appreciated ! ! ! I am really stuck

Los

[Losguapos1]

Is this possible? If it can be done could someone possibly put it into the sample file and attach it back on here. I have to be able submit this information tomorrow and i do not want to have to go through over 1000 records.

Thanks

Los