SimonHughes
Active Member
- Joined
- Sep 16, 2009
- Messages
- 428
- Office Version
- 365
- Platform
- Windows
Hello, I am trying to modify a formula in a calculated field but cannot find the way to do it. Any help? I am using Excel 2012, many thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Table - Calculated Field
- Thread starter SimonHughes
- Start date
Excel Facts
Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
You can select the calculated field you want to edit from the dropdown at the top of the Insert Calculated Field dialog.
Upvote
0
SimonHughes
Active Member
- Joined
- Sep 16, 2009
- Messages
- 428
- Office Version
- 365
- Platform
- Windows
So simple - when you know where to look. Many thanks, all done!
Upvote
0
