how to remove page breaks from an existing document I have an excel spreadsheet with teachers names, etc. How can I remove all the page breaks from the document at one time. ... 6 May 2010 20:58 Excell - two conditions count if factors are true when negativenu linda wrote: Formula to count if two conditions. I want to count column b when = "CAS" and if the number in column J is a negative number. I have tried =COUNTIF(B7:B21,"=CAS")=SUM(J7:J21,""<0) but it returns a "false" read. Column "b" are all words and Column "J" is numbers, but sometimes a ne... 6 May 2010 10:48 Excell - two conditions count if factors are true when negative nu Formula to count if two conditions. I want to count column b when = "CAS" and if the number in column J is a negative number. I have tried =COUNTIF(B7:B21,"=CAS")=SUM(J7:J21,""<0) but it returns a "false" read. Column "b" are all words and Column "J" is numbers, but sometimes a negative number and I only w... 6 May 2010 10:48 formula to return value from a matrix - I know hor and vert va Max, many thanks the 3rd value is manually input to show the skill level of the name against the skill title. Bearing in mind there will be many names with the skill do I just copy the below down x amount of rows? cheers UKMAN "Max" wrote: Indicatively, perhaps a basic Index(area, match(row),m... 12 May 2010 09:09 Using SUM + INDEX in array formula I'm having problems getting an array formula like this to work: =SUM(INDEX(Data_Table,Row_Index_List,Col_Index_List)) Basically, I have two columns of numbers that represent the row and column indexes from a data table (ranges Row_Index_List and Col_Index_List). I want to look up the numbers in the correspondin... 7 May 2010 04:34 formula to return value from a matrix - I know hor and vert values hi Filtering is not an option :) I have a table that shows skill titles across the columns e3:cz3 and staff names down c4:c103, for each name and skill there will be a value between 1 & 4 see example below C E Name Excel Colin 3 I need to insert the finding i... 6 May 2010 10:48 Time calculations over 24hrs Hi I'm using Excel 2003. I'm trying to calculate the total hours (C1) by subtracting end time (B1) from start time (A1) I have formatted the cells for time. I'm currently using B1-A1 which works OK until the end time goes past midnight. e.g start 19:50 end 00:20 should = 4:30 except i just get an en... 8 May 2010 17:49 Formula help please HI, HELP REQUIRED WITH FORMULA FOR EXCEL PLEASE Q: EXCEL WORKBOOK WITH TWO SHEETS, ONE TITLED MON & THE OTHER STAT. ON SHEET MON, I HAVE TWO COLUMNS (H, K) WITH A RANGE OF SAY 20 LINES EACH. ON SHEET STAT, I HAVE TWO CELLS (B5, F5) ON A LINE. I WANT 'MON' 'H' TO COMPARE WITH 'STAT' 'B5'. ON 'H' LINES THAT... 6 May 2010 07:27 sorting numbers Could you help me in sorting numbers. In column c I have the following numbers and it sorts it like this. 03 11 113 12 15 30 303 45 I would like for it to sort like this: 03 11 12 15 30 45 113 303 Thank you ... 5 May 2010 23:49 Worksheet Functions No matter how I enter a function, it displays as text in the cell and doesn't perform the calculation. How can I enter a simple formula and have it display the result? ... 6 May 2010 19:52