RE: Formula to ignore specific text during cell reference from pivot data

[Keers1]

Hi All,


I have a pivot table in my workbook and I am trying to pull data from pivot data column using cell reference. The source data will change, hence I need to extend the excel forumla to certain range.


I need an formula that should ignore and return empty cell if it come across certain text in cell value from respective column. I have attached the sample data for your reference.


The pivot range starts from column "A" and 4th Row. The formula which I have currently used is below:

=IF(A4<>"",A4,"")

This formula returns the cell value in column A and returns empty if no value in column A. But if any text like grandtotal and blank occurs, it is returning the same text. i have attached the sample screenshot for your reference.
formula.PNG

[Squeaky]

If "Grand Total" and "(blank)" the only text you will come across, use =IF(A4="(blank)","",IF(A4="Grand Total","",IF(A4<>"",A4,""))) If you have more texts you can add more "If"s.

[Keers1]

Thanks Squeaky for your help