need to add heading if data is less then 30

[sksanjeev786]

Hi Team

Below is the data B-D ,E-G,H-I, K-M, N-P will have in the same set with 3 columns and if any between 3 columns have less than 30 score
I need to add a note like Colunm B9..

Currently, B5 , F5, M5 have data less than so I have added those names Fro Row 6 to B9

book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
5	22	270	270	57	12	260	81	442	442	147	780	2	26	117	117
6	DMA: Atlanta			DMA: Dallas - Ft. Worth			DMA: Los Angeles			DMA: New York City			DMA: Washington, DC (Hagrstwn)
7
8
9	DMA: Atlanta, DMA: Dallas - Ft. Worth, DMA: New York City
Sheet1

 

[sksanjeev786]

In your example, you must also include N5

View attachment 122176

thank yo so much sir...

working very well..

 

[Peter_SSs]

In your example, you must also include N5

As was already pointed out.

What about N5 (26)?

@sksanjeev786
Given Dante's non-volatile formula suggestion above, another macro approach would be

Sub Less30_v3()
  Range("B9").Value = Evaluate("TEXTJOIN("", "",1,BYCOL(B6:P6,LAMBDA(a,IF(MIN(TAKE(INDEX(a,1):P5,,3))<30,a,""""))))")
End Sub

 

[sksanjeev786]

Thank you so much team for your support and help.... All Macros and Formula's are working superb...!!

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.