Hi, I know about the ACCRINTM() function in Excel which returns the Interest-Accrued between the Issue date and the Settlement date at a given Rate ...

How do convert an int value of seconds past midnight into a time value? Example: 53100 = 2:45PM

When setting up a "table" I repeatedly used the merge & center function. I want to expand and edit the table but the merge & center button is not functioning...

Hi I do the ladder for the darts club I play darts for and have a webpage that has all the fixtures and results of all the teams for Monday and Wednesday night...

Hi I'm still having problems with the ladder, I get a problem with teams won drawn and lost not adding up correctly. Any one help please. Regards...

I want to how to put a formula for the beow requirement. sum of two cells, if i get a postive asnswer I want to display it, if I get a negative answer i...

Sorry I am new to excel. The formula I need is to know how to put these two formulas together so that they work. =b1-b2 =if(b2=0,0) Thanks for any help

I have a data by heading in a file as a master data file. I do have form 7 file with 10 worksheet. each worksheet represent single form. In master data file...

Hi! Is there a way (even a long way) to apply conditional formatting based on order, say: I want to paint bold blue the 5 highest values in a row? Thanks.

Hi, I have an xl having "XLODBC.XLA'!SQL.REQUEST". and i am fetching values from oracle database. After that i want to create an ouput file with values...

Hi, I have a table of contact list in which person's employer name is entered. What i want is to use that employer name (from input column) and arrange...

Can anyone elaborate me how I can make multiple dependent drop down. I want to create a drop down list that depends upon two values. And second, I have a...

I want to create a drop down list which depends upon two or three previous drop down list. What I want exactly is to to list down first the type of...

My first question is I want to lookup multiple values in the worksheet. In my specific problem, I want to lookup three and four cells to find their matched...

Greetings....... How can i schedule to run an xls file on specific time if it has macros to enable. Thanks in Advance Zubair

All - Thanks in advance for the help. I have a long list of text values and I want to count the number of cells that contain error values rather than text....

Hi, good morning everybody I need your help! I have a list and I like to use it like this. Colum A = Product Name A2:A18 ; Row 1 = Size B1:U1 ; The prices of...

can anyone help?

Is there any way to take only a portion of an amount in a cell and then multiply it by a number? Let's say that I have $1000 in a cell, but only $50 of it...