In column A I have subaccount numbers which may repeat. In columns B thru F, there are amounts that I need to sum if they meet the specific criteria of what...

If I have two columns of information or mutiple columns and column A is the date an event happened or will happen, how would write a formula to say if the...

in VBA you get import or export options for spreadsheets - in 2003 it gives options such as 'acSpreadsheetTypeExcel5' whereas in v97 - it would just give the...

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM, SAS and CCleaner, Office 2007. All of a sudden only one (of many) worksheets...

I have an Excel file which links to our database via ODBC and Microsoft Query. The Excel file contains a graph of sales figures which I have set to refresh...

I'm combining text from four different cells into one cell, which works well. However, I would like the information from one of the four cells to be Bold...

Hi all, I have thes lines of code: Range(Cells(tellerteller + 2, "Q"), Cells(tellerteller + 2, "Q")).Select ActiveCell.FormulaR1C1 = "=SUM(RC:RC)" In...

Can you please help me with setting up a formula? Product A = $100 Product A = $100 Product A = $300 I want my result to be Product A = $500 not $100....

Dear, I have data in the range of cells A2:E1000. The row 1 has the headers to which i had given filters. The column E has a numeric value for which an...

I have some columns with the width 4. Sometimes the validation pick list is wide like 40 and sometimes it is only as wide as the column. I already know...

Hi. Our yearly calendar runs from 01/11 - 31/10 every year. I have a spreadsheet that contains dates from 01/11/2006 onwards in column a. I would like to be...

How do I put this into a spread sheet?

I have a column with over 400 rows of names that most contain names reading last name first then a comma then a persons first name. Such as Sullivan, Mike. ...

I receive files from China that always has foreign characters, which sometimes translate to symbols or ASCII characters in it. I would like to be able to...

I'm trying to use the formula below, but its not working correctly. On the Hiring tab, column T has a date formatted as MM/DD/YYYY. I want a formula that...

In the older version of excel, you could have multiple color fill tabs and you were able to tear off the color fill to pin it open on the sheet. I can't to...

:confused: I have a number of timesheets for various departments up and running correctly. However, I am trying to change one to calculate hours over a 24 hour...

Goodmorning Everyone! I have a worksheet within a workbook that contains 1500 rows of data over 14 columns (the 12 months, plus to summary columns) - called...

Hi there, I do have a string in a cell that looks like this (this is UTM ED50 format): 46° 34' 21.09" N 8° 24' 54.28" E I need to convert this string...

Ever since my printer has been networked by the cells in my excel if filled with color do not print in color. The print preview displays the various colors...