Pivot adjustments

  • Thread starter Thread starter walrus
  • Start date Start date
W

walrus

Following is extract from a pivot. All Centre IDs are related to 67210. I
want to show 67210 in each line


Account Centre ID Deptt 1 Deptt 2 Grand Total
67210 2110 0.06 0.06
6015 278.35 278.35
6999 (30.54) (30.54)
8010 131.67 131.67
 
Hi,
you can copy the value down, if you have different numbers you can use a
formula like the following, I assume that 67210 is in cell A2, and your
formula in D2 so D2 enter

=if(A2<>"",A2,D1)

copy formula down
 
Back
Top