Hi all,
I have an excel file formatted as a table with the following layout:
Item Area
a01 CAR
a02 CAR
a03 CAR
b01 TRAIN
c01 AIR
c02 AIR
d01 MC
d02 MC
To get the new column called "New Area" I compare the current value in the Area-column with the previous value, if equal I write "" else I take the value from the Area -column.. this is how I want it:
Item Area New Area
a01 CAR CAR
a02 CAR
a03 CAR
b01 TRAIN TRAIN
c01 AIR AIR
c02 AIR
d01 MC MC
d02 MC
But this I get from excel:
But on the first line I must compare the value against the column header Area
a01 CAR CAR
a02 CAR CAR
a03 CAR CAR
b01 TRAIN TRAIN
c01 AIR AIR
c02 AIR AIR
d01 MC MC
d02 MC MC
The calculation for the first line:
=IF([@Area]<>Table5[[#Headers];[Area]];[@Area];"")
The calculation for the second line:
=IF([@Area]<>Table5[[#Headers];[Area]];[@Area];"")
It still refers to the header, how can I fix this?
Thanks!
Bookmarks