Sorting Possible avoiding cell Formulas?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mhz - 15 Jul 2006 17:23 GMT

Just wanted to know if it is Possible to sort omitting any formul
activity?

I know, sounds crazy and doesn't make much since, but when I attempt t
sort, the data resorts back to the original position based on som
formulas I am using.

So I guess the main question would be, Is it possible to freeze formul
activity to allow general sorting? If Not, I can surely understand Wh
..Thanks In Advance..

Reply to this Message

Mhz - 15 Jul 2006 18:04 GMT

Kind of Replying to myself here ...:rolleyes:

The only way I have found to do this so far is to create another shee
that references the sheet I am trying to sort with the formulas an
recreate the data without the formulas.

eg.

In Sheet3:

=IF(Sheet2!A2<>"",Sheet2!A2,"")

I now can sort In sheet3 without the Formulas In Sheet 2 Re-Sorting...

Still Welcome any other Input...Thank

Reply to this Message

Niek Otten - 15 Jul 2006 18:07 GMT

You could Copy your data and Paste Special>Values in another column or row and use that as your sort key

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Just wanted to know if it is Possible to sort omitting any formula
| activity?
[quoted text clipped - 6 lines]
| activity to allow general sorting? If Not, I can surely understand Why
| ..Thanks In Advance...

Reply to this Message

Mhz - 15 Jul 2006 22:58 GMT

You are so correct Niek, As simple as it sounds, I couldn't think o
that :eek:

One more solution to that sort situation... Thanks Alot :

Reply to this Message

Rate this thread: