Status
Not open for further replies.

rohithbli

New Member
Joined
Jun 21, 2018
Messages
2
The column "name" must match with column "formula"


ex :the Value "Calculation_385057835130777604" must match in column "Formula" and must replace with column "Caption" value

"Calculation_385057835130777604" must change to "Year_Brand"

captionnameformula
Year_Brand[Calculation_385057835130777604]if [Parameters].[Parameter 2] = "This year" then [Calculation_385057835129393153]



elseif [Parameters].[Parameter 2] = "Current Month" then [Calculation_385057835129593858]



else [Calculation_385057835129860099]



END
Previous Year_[Calculation_385057835142270982][Parameters].[Parameter 1]-1
ΔPY YTD_Brand[Calculation_385057835145179143]SUM([Calculation_385057835130777604])-SUM([Data Shown Filter (copy)])
EU_YTD[Calculation_385057835146694665]{ FIXED [Month],[SEGMENT] : SUM([Calculation_385057835130777604])}
Current Month_prev[Current Month (copy)]if year([Month]) = year([Calculation_385057835142270982]) and month([Month]) = month([Parameters].[Year (copy)]) then [Zulassungen] end
Previous_Year_Brand



[Data Shown Filter (copy)]if [Parameters].[Parameter 2] = "This year" then [This year (copy)]



elseif [Parameters].[Parameter 2] = "Current Month" then [Current Month (copy)]



else [YTD (copy)]



END


I am looking macro to replace the duplicate values with "A" Column Values.

Thanks in advance


Regards
Rohit

<tbody>
</tbody>

 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Status
Not open for further replies.

Similar threads

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top