Creating a PivotTable

[DCGuy2440]

I need to create a report that will return all rows that contain a certain value. The cells containing that value will be in different columns. Can this be done? Thanks.

[newdoverman]

Without seeing your source data and Pivot Table, that is a definite "maybe". If you can filter on the columns in the Pivot Table then it should be able to be done.

Maybe all that is required is to filter your source data and never mind using a Pivot Table.

[DCGuy2440]

number 1 2 3
SOP 123.9 SOP 123.8 SOP 123.7 SOP 123.6
SOP 234.6 SOP 234.5 SOP 123.7
SOP 234.6 SOP 234.5 SOP 345.8
SOP 555.3 SOP 555.2 SOP 555.1
SOP 343.3 SOP 343.2 SOP 343.1 SOP 123.7

This is a simplified version of what I'm dealing with. What I'm trying to do is generate a report that will produce
all rows containing the value "SOP 123.7".

[oeldere]

With countif and an filter.

see the attached file.

[newdoverman]

If the above data is in the range A2:D6, enter this formula in E2 and copy down: (change the cell references to match your data)

Please Login or Register  to view this content.

Select all the data including the column with the above formula and filter on that column selecting 1 as the filter criteria. All rows with the value SOP 123.7 will be presented.