Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a way to change formulas to values for sorting purposes?
|
#2
|
|||
|
|||
Hi!
Select the cells with the formulas. EditCopy then EditPaste SpecialValues Biff "Change formulas to values" <Change formulas to wrote in message ... |
#3
|
|||
|
|||
Hi, ps, save your Workbook before you play with Macros, and as a different name afterwards. To change the H column to reflect the formula in column B is For i = 1 To 100 Range("H" & i).Value = "'" & Range("b" & i).Formula Next i To put that into a macro, select Tools, Macro, Record new macro, select a cell, then end the macro recorder. then, Tools, Macro, Macros, select the macro and Edit. Copy the code, and amend the For i = 1 to 100 to show the rows where you wish this to happen, amend the columns H & B to be where you want the formula to show (a spare column) and where the formula was. Run the macro. Hope this helps Change formulas to values Wrote: is there a way to change formulas to values for sorting purposes? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=401367 |
#4
|
|||
|
|||
Bryan Hessy wrote:
Change formulas to values Wrote: is there a way to change formulas to values for sorting purposes? The Sort command (Data-Sort) treats formulas as values. Have you tried sorting your data as is? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Numeric Values from Formulas | Excel Discussion (Misc queries) | |||
vlookup formulas returning no values | Excel Worksheet Functions | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Can series tool change formulas over time when used to copy them | Excel Worksheet Functions | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) |