+ Reply to Thread
Results 1 to 1 of 1

sort numeric cells and formula Value only questions

Hybrid View

  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    Cape Coral, Florida
    MS-Off Ver
    Excel 2007
    Posts
    13

    sort numeric cells and formula Value only questions

    1.The formula =COUNT(FIND({"07","35"},B3)) works just fine. However, I would like to be able to return the Value found in the cells in say Column B to adjoining Column C but when I copy the column B to C it copies both the formula (which is hidden) and the Value. The reason that I want to copy from B to C is to preserve B for editing different numerical values in the database but be able to sort the Values in C from ascending or descending order. With the formula also in C it fouls up the sort process. I can of course highlight the thousands of cells in C, right click “Copy”, right click “Paste” and then use the dropdown menu on the small clipboard icon and select “Values Only” which knocks out the formula leaving only the Value so I can sort the Values. Any suggestions on how to revise the above formula so that it puts just Values in C while preserving B?

    2.Since the cells that I am searching on have a series of five 2 digit numbers how can I take the numbers in that cell and flip them vertically putting each 2 digit number into its own cell (in other words I would have 5 cells, each with a 2 digit number) so that I can sort the numbers in ascending or descending order. Since I will have numerous data cells that I want to “stack” the numbers for sorting all the data this would save having to hand enter each value from the many individual cells into its own cell.
    Thanks for anyones help in advance - Raymond - Cape Coral, Fl
    Last edited by CATALES29; 02-02-2011 at 08:48 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1