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
Bookmarks