ID B Month A1 Pass Feb A1 Pass Feb A1 Pass Feb A3 Fail Feb A4 Fail Feb A4 Pass Feb A4 Fail Feb A4 Pass Feb A1 Pass Jan

I am having a problem reading values other than the plotted values off the graph. For example: Values plotted for x=30, x=50 are y= 2 and y= 5 respectively but...

I have a workbook for a company budget with an intentional circular reference (calculate a loan balance, then calculate the interest charge on that which...

Good morning Rose - What you describe so far can be done with a macro in Excel. You could start by recording a macro that does what you want it to do - from...

I am trying to use the insert function in developing a VBA application for Excel and I noticed the second parameter to the Insert function in the new Office...

Hello, I use Excel 2002 and I will appreciate having a detailed procedure of creating a new user defined function and storing it in the personal.xls...

i was wondering, is it possible to have data be imported into excel sheet 1 automatically sort into different sheets by the information given. i.e: imports...

If I understand your question you can go to Data / Text To Columns in Excel and it will do it for you. It offers you different choices on which delimeter to...

Try something like: =SUMPRODUCT((A1:A100=5)*(B1:B100=1)) Adjust range to suit (but both ranges must be...

Just do an editreplace and replace Sheet1 with Sheet2 Another way would be to use a reference to the sheet in the...

Hello, I have used Excel long enough to know that when you copy a formula and paste it into another, it should calculate the formula. It seems that I have to...

I'm trying to set up a formula that will subtract one date and time from another, but must be less than another column to provide true or false. **I only want...

Hello, On Sheet1, I have a matrix of data (D4:R23, with many cells blank) that is updated by users, and that I’m gradually reformatting into...

Hi, please tell me how to unselect "Option Button" for printing (Office XP, Excel). thanks

I have a spreadsheet with two columns detailing hours worked, (i.e. from and to) and I have then two columns that convert the hours into a number format, and...

we have page overflow and date format issues with excel macro. this macro generates about 20 pages of charts... 18 of 20 are printing on two pages when we run...

When using text wrap in a cell in Excel, the text entered will wrap properly then suddenly, text will disappear, other text will start appearing in the middle...

Installed ACCLNK.EXE to my Excell 2002 program (Windows XP/Microsoft Office XP Profession). I had to click Tools to add-on Access Link twice before I could...

I can easily do this with the "NETWORKDAYS" function in the analysis toolpak, however not everyone on my distribution has this add-in. How can I count the...

Hi, This is URGENT. Problem: In MS Excel, Column A contains values from A to Z and Column B contains value from 1 to 5. Now, I need to count the records that...