View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GSpline GSpline is offline
external usenet poster
 
Posts: 20
Default Data Field in Pivot Table

Is it possible to change data field values (i.e. if they all show as "1") to
something else on a per column basis? I have 3 different columns, and did
not put any data in the data field so that I can see when the row & column
data match but I need the 1's that appear for matches to be replaced with a
different word per column. Any ideas?