Functions

MS Excel 2003 - Advanced Features Add-In
The Advanced Features Team is pleased to announce the release of the first version of their Add-In for MS Excel 2003. Part of this realease are the following functionalities: * Easy and powerful connection between MS Excel and MS Access * K-Means clustering algorithm * Additional User Defined Formula... 4 Mar 2010 11:14

Concatenate function
Hi, How can I concatenate these 2 cells: one is time and the other is text: 9:00 and AM and I want the result to be 9:00 AM =CONCATENATE(AD2, " ", AE2) I have tried different formating cells but it doesn't work, this is what I get: 0.375 AM Thanks for your help. ... 4 Mar 2010 12:22

Function help needed please.
I need a formula that can read vertically down the contents of a column of data and list all of the results in another column. I do not want to list duplicate results, I only want the first instance listed once, then ignore any exact matches that have already been identified after that. EXAMPLE: Column A, ... 4 Mar 2010 12:22

How do I change Column names (a,b,c to Name, Number)
I am trying to change the Columns titles. Example, Column A becomes Column Name, Column B becomes Column, Address. That way when I'm working on row 57 I can still see which column the data goes in without having to scroll to the top and see which column is correct. I know I have done this before in a computer ... 4 Mar 2010 11:14

Rephrased Question on Random Items within Worksheet (3/3/10)
I have several Business Lines that submit General Ledger and/or DDA reconciliations monthly to me. Within each individual reconciliation (Excel Format), there are approx. 0-14,000 items listed. Each Business Line may have up to 1000 reconciliations. Is there a way to set up a program, whether a macro, somethi... 4 Mar 2010 11:14

Duplicates
I trying to use a formula to find Duplicates Entries in a Single Column. I tried some formulas I found it but they didn't work. ... 4 Mar 2010 08:58

Countif OR Sumproduct- I NEED HELP
HI, I need a formula to create I need to count number of items in #SHEET1 $B:$B if VALUE in #Sheet1 $A:$A matches #SHEET2 $A3. Please Help Me. ... 4 Mar 2010 08:58

Text from number
What is the formula if i entered number (i.e, 5000/-) & it convert in word (i.e, Five Thousand Only) ... 4 Mar 2010 06:43

#ref
iam currently using the below formula, if there is no data for a month i am getting the #ref i have tried adding ifserror to input a 0 if necesary but unfortunately have no joy, any suggestions =GETPIVOTDATA("TOTAL ASSIGNMENTS COLLECTED",'PIVOT DATA'!$A$54,"month","FEBRUARY")-GETPIVOTDATA("TOTAL ASSIGNMENTS ... 4 Mar 2010 07:51

What's this: [Sales] ?
I am looking at a Worksheet where it contains the folllowing formula:- =SUBTOTAL(109,[Sales]) I can see and understand what the formula is doing and why it is doing it. I know what the 109 means. What I don't understand is the:- [Sales] - part. I have checked the Worksheet and there is no Range... 4 Mar 2010 07:51