I want to sort a column based on the displayed data not the underlying formula. Can this be done? cell formula =VLOOKUP(A1,RteTable,2,False) The resulting...

I need to evaluate the contents of three cells and return one of 8 choices in a fourth cell. The contents of the cells to be evaluated are numbers and are...

I think I accidentally hit a key command and now when I create a formula (say just adding a column of numbers), if I go back and change one of those numbers in...

I am trying to sort a column that contains 2 or more things, like red and blue and yellow. How can I sort them based on 1 colour (ie, yellow)?

I think Microfost should be adding more lines in Excel: 65k lines and 256 columns is simply not enough when you want do do serious calculation. Altought I can...

Hi, I have table with A,B,C and D colums and text in the rows. Some of the words in the text are with bold and different color letter. I need to extract those...

Hello, I have a problem with my workbook, the wrap text format is not functioning for the fist 7 rows. My workbook is designed like a template and has 3...

hi to all While feeding our production reports we can punch starting time & ending time ( Clock time ) of the activity & we want the time duration to...

Hi, Is there a way to have an if statement based on data type. Here is the equation I am using. =IF($F10="",E11,E11+F10) As you can see I can not add E11...

I am trying to get the sytax right on a function that gets a value from a pivot table: =GETPIVOTDATA((cell("contents",a5))!B9,"Total Student Capacity") I...

how do I place the name of a sheet into a cell (on the same sheet...)?

Hi, Here's my situation: I have a workbook in which I'd like to reference a cell in another worksheet, but would like to increment the reference as I move...

When I type a formula in the "true" value, the formula is displayed and not the result of the formula. Please advise how to ensure that the numerical result is...

I have a user who would like t be able to select more that one from a drop down list. Is there a way to do this? I told her to create two cells and select one...

Hello friends, I believe that the solution to my problem lies in the writing of an array formula; but since my creativity with writing array formula is very...

I was reading a post from Hope that was asking about password protecting individual worksheets in a spreadsheet to allow sales reps to only access their own...

How do I convert an entire column of text only email addresses to hyperlinks pointing to the same email address? Any help greatly appreciated

I copied some information from 2 sets of bank statements--"Bank Checks" and "Direct Deposits" (in Explorer web page form)--into a series of Excel...

Help please! I have a worksheet "receiving data" column1 state; column 2 city county name; column 3 gross (blank); column 4 tax(blank). I have a "data...