Formula Help

Goodspeed

New Member
Joined
Sep 24, 2006
Messages
32
Hello,

I am currently using the following formula: =if($b$1="Doe,John",c1,"x") to display data in a range when the value of b1 meets specific criteria. The value in B1 is imported data and changes when new a persons data is imported into the spreadsheet. Currently I am copying and pasting the results of this formula into another range in order to save the results for reporting purposes. What I would like to know is if there is a way to either format the destination range or if there is a formula which will allow the cells to populate with the appropriate information but not change when the value in cell B1 changes. Hope this makes sense.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good morning Goodspeed

If I understand you correctly, what you need to do is highlight the range you want to set as "hard coded" cell values, right click and select copy. The right click and select Paste Special and when the dialog appears select Values and click OK.

HTH

DominicB
 

Forum statistics

Threads
1,136,354
Messages
5,675,303
Members
419,560
Latest member
g3org

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
Top