HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)? HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)? ... 27 Mar 2010 22:12 Excel's COMBIN and integers In theory COMBIN works with integers in Excel (2003 and 2007). So "=COMBIN(9,3)" gives 84 and so does "=COMBIN(9.7,3.6)". Similarly "=COMBIN(9,3)-84" gives 0. But "=COMBIN(9,3)-84-0" gives -1.42109E-14 and there are many similar examples suggesting that some sort of rounding is involved. The sign can even cha... 2 Apr 2010 14:52 Worksheets are stuck on default text format with left align This is really making me crazy. I have data that I have downloaded from mysql. The problem I am having is that every cell is defaulting to text format with a left align (the field starts out with a hidden apostrophe). No big deal except that I need to convert on of the text fields by inserting a dash in be... 27 Mar 2010 17:42 How specify number format of cell value in concatenate function? When combining text and cell values in a concatenate function, I would like to control the number format in the concatenate cell: comma separator, decimal place, etc. ... 27 Mar 2010 15:25 how do i set an alarm to work on excel i have delivery/collection spreadsheet and i'm trying to set some sort of worning to tell me that a collection is over 30mins late any tips ... 27 Mar 2010 19:58 Updating Next Consecutive Cell in Range I am trending a bank account balance. Every time I enter the current value in cell c3, I would like it to update the value in the next empty cell in range c5:c200. Thanks Sony ... 10 Apr 2010 01:35 Excel formula I need a formula that does the following: Calculates how old I am when a birth date is entered. The formula needs to use the calendar days not a fixed number of days per month. The second part is if the person is more than half way through the year the age needs to increase by one. For example my birthday is a... 26 Mar 2010 19:16 sorting in Excel 2007 problem I've copied data from a list and pasted it into a pre-existing list in an excel worksheet. I cannot get the two lists (the pasted one if just underneath the original data) to sort together. Can someone help? Thanks! -- Courtenay Lambert ... 26 Mar 2010 22:57 SUMPRODUCT with two valid criteria Hi, Thanks in advance for your help. I am creating a calendar to see time availability from a huge table that list the room, the date, the day, and the time. We rent our facilities, so I need to know which events are ours and which one are for outsider. PROBLEM: I found out that if there is an event planned at... 27 Mar 2010 01:11 Help with Value in one column... If you have an ethnicity column I want to go to the next column and for all of a certain ethnicity I want to return either a 1 or a zero. Column A Column B Hispanic 1 White 0 African American ... 26 Mar 2010 19:16