After Applying Filter Display a specific Word.

[icsonu]

The below displayed is a Reference Table for quick Evaluation of Sale which
is below a data base of Brand names of Cars, with monthly sale.

The 1st table is before applying filter, and the third column becomes blank
as formula is given that if sale is >0 then return a blank cell. In this I
want the cell D480 to be blank before Filter and I want Honda in the D480
only if the Cell in Column C naming Brand Displayed is Honda and other brands
are Blank. (refer Table 2). This name should be in a the Reference table.

Table 1
Brand Monthly sale Brand displayed
Ford 450 (blank)
Honda 500 (blank)
Suzuki 800 (blank)
Prada 950 (blank)
Pajero 845 (blank)

D480 is displayed (blank)

Table 2
Brand Monthly sale Brand displayed
Ford 0 (blank)
Honda 500 Honda
Suzuki 0 (blank)
Prada 0 (blank)
Pajero 0 (blank)

D480 is displayed Honda

 

[icsonu]

The below displayed is a Reference Table for quick Evaluation of Sale which
is below a data base of Brand names of Cars, with monthly sale.

The 1st table is before applying filter, and the third column becomes blank
as formula is given that if sale is >0 then return a blank cell. In this I
want the cell D480 to be blank before Filter and I want Honda in the D480
only if the Cell in Column C naming Brand Displayed is Honda and other brands
are Blank. (refer Table 2). This name should be in a the Reference table.

Table 1
Brand Monthly sale Brand displayed
Ford 450 (blank)
Honda 500 (blank)
Suzuki 800 (blank)
Prada 950 (blank)
Pajero 845 (blank)

D480 is displayed (blank)

Table 2
Brand Monthly sale Brand displayed
Ford 0 (blank)
Honda 500 Honda
Suzuki 0 (blank)
Prada 0 (blank)
Pajero 0 (blank)

D480 is displayed Honda