Get Column Headings with Comments

[ootkhopdi]

Hi All

i have a table like this

GradePay	BandPay	BasicPay	DA	HRA	CCA	HA	PersonalPay	SpecialPay
4600	3	47600	5712	1840	0	0	0	0
0	3	40000	4000	2000	100	0	0	0
-4600	0	7600	-1712	160	100	0	0	0

now i want to result like this
In this table, Last row is Difference in above two rows,
i want to get column heading(With Comment), in which difference is not equal "0",
with Textjoin formula i can got column heading but with comments, i can't
i want results like this...
Diffrence in Column: Grade Pay-Grade Pay Deducted,
Basic Pay- Basic Pay Deducted
DA- DA Deducted
HRA-HRA Increased
CCA-CCA Applied

 

[GraH - Guido]

Hi ootkhopdi, it's always better to upload a sample file. Because your thread contains some confusing wordings. "Table" suggest you have used table object in Excel as does "Heading" and "with comments" suggests you have used cell comments.
But perhaps you have simply used cell ranges to enter your data and "comments" means you want to see evolution of both lines. Going up/down. Applied is starting from 0 it went up?

Look at the attached file, it contains 2 possible scenarios range/table with a nested IF() approach.

 

[ootkhopdi]

Thanks GraH for give some solution.

you get exact database formation but, there is a change .

as your suggestion i attached a sample file to show, what i want (In Remark Column)
But I Don't Want Nested If Solution, Some times it gives too slow calculations.. and errors