formula checking

A colleague created a spreadsheet which amalgomates data from 12 tabs (Each tab relates to a different date). In the amalgomated spreadsheet each cell relates to a different cell in the tabs. I dont know how she created this originally but I have noticed that in a number of the columns there is...

I am having trouble with the INDEX/LARGE function in this sheet: Excel 2000ABCDEFGHIJK2District 0District 1District 2District 3District 4District 5District 6District 7District...

Hello all, I'm new to this forum have have a question on sorting: I have a table where there are columns with text in the format similar to the following: ="Birthday"&CHAR(10)&TEXT(DATE(2013,3,31),"MM/DD") What I would like to do is to sort this data based on the date part of that function...

Does anyone know how to fix #DIV/0 errors that go away when you double click in each cell? I have a large spreadsheet with these errors and need to fix them all in one swing to meet my deadline today. Is this a calculation error? Can I use a Text to Columns type feature to fix this? Thanks so...

Im using Excel2007 and i have an IF Formula having 2 logical test and 3 conditions A1 is a date for example 04/10/2011 and i want to have an arguement like this =if(A1=today(),"Due Today", "Waiting to be Validated") =if(A1 < today(), "Overdue", "Waiting to be...