I have an excel spreadsheet that has columns with dollar totals in columns E through L. In column M I total these columns up with a simple formula =SUM(E236:L236) (for example) and it should total ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/27/2008 Rating: 9.8 Views: 0
We recently installed the update KB943985 for Office 2003 and ran into a huge issue.
It changed the default delimiting option from tab to fixed width. This is a huge problem because a lot of our...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 03/20/2008 Rating: 9.7 Views: 0
Hi guys,
I have a spreadsheet which has 4 columns (A, B, C and D). Column A and B are always populated but C and D might not always be. The data in these columns are in two column pairs (AB an...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have a transparent boundary map of my county overlayed on a grid in excel. what I want to do is link a cell to a specific file name and colour the cell if the file exists.
This way I can identif...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/27/2008 Rating: 7.4 Views: 0
In Excel, I have a column of inventory numbers that reference data in a separate worksheet. I want to use the inventory numbers in a calculation that then populates cells to the right of the inve...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/04/2008 Rating: 9.6 Views: 0
I need UK books barcode (scanned) number converted into ISBN. So for instance when scanning the UK books the barcode number is pasted into a single column spreadsheet, I need this number converted...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I've been give a spreadsheet and 1 field on that spreadsheet has the following information all in 1 cell
LOCATION: TMH SHOP FAILURE CODE: GROUP CODE: REPAIR REQUESTED BY JOE QUESADA COMPLAINT: N...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/05/2008 Rating: 8.9 Views: 0
I'm using vlookup to bring in name/address of a customer when the user just needs to enter the customer #. This name/address file (.xls) is being updated daily. It appears that sometimes when the...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/09/2009 Rating: 7.8 Views: 0
I'm sure this is easy for you all ...
I need to % of the SUM of two numbers D2=8 , E2=3
If I use ' =E2/SUM(D2:E2) * 100 ' would be right ? It telling me its in error without telling the ...
http://www.experts-exchange.com/Microsoft/Applications/Q_24131447.html
I getting #VALUE and #DIV/0! errors ... I've attached a spreadsheet... Thanks for any help!
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/10/2009 Rating: 9.3 Views: 0