Display Months on multiple condition

**vinaynaran** · 09-13-2010, 12:26 PM

Dear all,

Please see attached excel file on that I have explained what I want.

Actually I want to display months name according to their multiple condition.

Thanks

Vinay

**NBVC** · 09-13-2010, 12:36 PM

You will need a VBA or addin function for that...

Try adding this code to your VB editor (ALT+F11, Insert|Module)

Please Login or Register  to view this content.

then put this formula in N2:

Please Login or Register  to view this content.

confirm it with CTRL+SHIFT+ENTER and not just ENTER.. and copy down.

**DonkeyOte** · 09-13-2010, 12:37 PM

Or possibly...

Please Login or Register  to view this content.

but I agree with NBVC a UDF is certainly more practical.

**NBVC** · 09-13-2010, 12:45 PM

I guess I shouldn't have said...

You will need a VBA or addin function for that...

should have said that it would be easier or more practical with the udf...

I am used to seeing this kind of problem expand to multiple more concatenations then the given samples show...

**vinaynaran** · 09-13-2010, 12:49 PM

Guys,

You both are brilliant.

I have tried both and those are working perfect.

Thank you very much to solve my problem

Regards
Vinay

**ChemistB** · 09-13-2010, 01:49 PM

Just for comparison, my solution places each month in its own cell (from highest % to lowest).

=IF(AND(COUNTIF($B2:$M2,">= 1.50")<COLUMNS($A$1:A1),COLUMNS($A$1:A1)=1),"Non Seasonal",IF(COUNTIF($B2:$M2,">= 1.50")<COLUMNS($A$1:A1),"",TEXT(INDEX($B$1:$M$1,MATCH(LARGE($B2:$M2,COLUMNS($A$1:A1)),$B2:$M2,0)),"mmmm"))) dragged right and down.