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, 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...

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...

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 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 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 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...

hi all, i wonder if anyone can help me with a formula i want to create. in column A i have names of products, and in column B i have the date (sell by date,...

Hi, I am using the formula below and others like it to extract certain data from a single workbook into several different workbooks. I have multiple sets...

Hi, Is there a way to find the maximum value of a column in Excel and then list it along with the corresponding values in adjacent cells in the row? I know it...

Here's my scenerio: Sheet 1 is the main page with all the information (a quotation with material and price breakdown). In columns A & B data has to be entered...

I have a colum with exact dates and another with values that correspond to those dates. Columns D and E respectively. Rows 7-36. What I would like to do in...

I am trying to do a similar, but capping a cell that I use for discounts eg the cell could read 35%, but I only want a max of 30% on some products But the...

Would like to share an excel worksheet, but both protect modification of the entire worksheet (simple enough -- know how to do that), but would also like to...

I have 2 columns D7:D36 and E7:36 Column D contains dates ie: 9/7/2004 Column E contains a value ie: 2 In another cell I would like to add the values for...

Let's say I have 2 columns of data on worksheet "Data" - column A is date, and column B contains numeric values. Using a date found on worksheet "Test" (in...

I am attempting to do inventory analsysis where I need to pick the highest and second highest values from a row of numbers. I can get the highest by using the...

I'm using an array formula to count occurrences of certain text values in a column. The column contains various 2-letter codes, and I want to count the number...

I need to use a formula that does a count based on font color. Is it possible? And do you have an example I could see? -- John Kirschner

I am trying to do a sheet containing Holidays and Absence my problem is that if you only have a 1/2 day holiday my formula is counting it as a full day I need...