Hi, I found that TRANSPOSE and MMULT do not work together well. if I type the following I get #VALUE!. =MMULT(A1:C1,TRANSPOSE(A2:C2)) where A1:C1 and A2:C2...

Hi everyone.. I have a file that I have transferred into Excel, 40000+ rows. I have written a simple formulae to check for duplicates, based on the surname...

I'm trying to stick the today() function in with text, so that a cell could read: PREPAY today's date. (e.g., PREPAY 8/10/04) I want to do this without...

Sometimes I get this "Macros Disabled", but sometimes I don't. I'm getting it right now, and it's driving me crazy, how do I get rid of it?

I am trying to match the same values in two different columns. For example: Problem: Column A Column B abc def def ...

I am trying to create a link where I have a list of data in 1 workbook and I want to tranferit automatically to a new workbook just by either clicking a cell...

I notice that the autosave functionality only works with an autorecover, rather than actually saving the file. I am refreshing a query, and want to...

=NOW() format as hh:mm, updates whenever you close/open or calculate the workbook (you can also press F9) -- Regards, Peo Sjoblom

Hi there, I am trying to acheive something like the following: ="For the months of: " & Format(MENU!B4-12, "mmm-yyyy") However with no luck. How might I get...

I have a spreadsheet (exported from Outlook) that has the birthdates for several contacts. The date was imported in mm/dd/yyyy format. I have tried...

could someone please help with this calculation. it does not seem that difficult but i can't seem to get it. i need the formula for column i. col c = given...

Hey - I promised a friend I'd help get some addresses into a spreadsheet. There's 25,000 of them! My problem is that the street address for each one looks...

i have a validated drop down menu... what im trying to do is make a choice on the drop down menu and grab a value from another worksheet and place on my...

I have a simple function =isnumber(g53) The result is consistently "FALSE" G53 contains "5". I have tried formatting the cell to text, number, general. None...

In Excel 2002, I am referencing data from an external worksheet via the following formula: ='Jul-04'!D11 I would like to make the "Jul-04" part variable...

Hi, Hope someone can help me with this one: I have a spreadsheet full of figures & formulas- that will not calculate automatically. The only way they...

I'm trying to extract only certain columns that meet a requirement and failing at it miserably. here's what I'm trying to do Date Customer# Business...

I work ved arrays and lists with varying number of cells. How can I make a formula, where I ( in a single column og row)want to ignore ex 10 % of the higest...

My friend send me an Excel Spreadsheet created in 2000. Neither he or I (I am using 2003) can insert a new row without getting this message which doesn't make...

G'day there One & All, Having pulled out what little hair remained, I now turn to those who know what they'e doing. I have a list comprising about 8 columns....