if find blank cell in coloum need to take the header name in remarks

[shrinivasmj]

this is formula need to modify

=TRIM(IF(LEN(M311),"",M$1&", ")&(IF(LEN(N311),"",N$1&", "))

I need to remove last comma and add last sentence, if only one blanks cell is there add- ( is not available )

if more than 2 blanks cell need to add at last ( are not available )

 

[AlphaFrog]

Try something like this...

=IF(COUNTBLANK(M311:N311),

CHOOSE(COUNTBLANK(M311:N311),IF(LEN(M311),N1,M1)&" is",M1&" and "&N1&" are")&
​

" not available","")​

 

[shrinivasmj]

HI ITS WORKING BUT NEED FOR all the other fields in between like a2 to l2 and not take d and e row with same above formula i need

Service Point No.	Source No. (11 Digit Pole No.)	Mobile / Landline No.	Service Main (UG/OH)	Supply (1/3)	Phase (R/Y/B)	Meter Make	Meter Sl. No.	Metre Type	Meter Model	Meter Mfg. Year	Current Rating ()Amp)
1	10000160985	+919845898986	UG	1		LT-LTD	JQ21518	EM	EM101	1997	5-20

<tbody>
</tbody><colgroup><col><col><col><col span="5"><col><col span="3"></colgroup>