I have an Excel spreadsheet with about 15 columns and want to print them out onto a 8-1/2 by 11 inch page.
I want to do this because printing a regular spreadsheet of about 15 columns would...
Is it possible to set permissions per worksheet as opposed to per workbook. Can you point me to it in the interface?
I have a spreadsheet with a column of numbers that are supposed to be dates, but are actually text. This was an import from a database I have. How do I convert 12032007, or 132006 to a date. I...
How do I do a count if with two date criteria. Below is the single date criteria that works
=COUNTIF(AssignedTodate,"<"&DATE(2007,11,1))
I tried the below for two dates
SUM( (Assigne...
Seeking a software solution for the following:
I work at a school where, currently, proposed events, fixtures, sports matchs, drama performances, etc are put onto an excel spreadsheet. Whe...
Hi,
I need help find the 3rd degree irreducible polynomial and then create an addition and multiplication table for the following polynomial function: [x4 + x3 + x2 + x +1] and also create B...
How do I use the date attched to a computer to change concurrently within an excel spreadsheet, to determine travel rate. Example: 20 units sold / 23 working days expired * 31 workings days ...
I exported a record to Excel that had lot of repeating information. I filtered the data by clicking on unique record, which got rid of the repeating records. The problem here now is that inst...
Is there a shorter way of stating the following array formula in MS Excel:
=SUM(($I$2:$I$25017=0)*($BN$2:$BN$25017))+SUM(($I$2:$I$25017=86)*($BN$2:$BN$25017))+SUM(($I$2:$I$25017=89)*($BN$2:$B...
Im looking to get inventory data from accpac 6.5 for dos to some text or some medium that can be easily put into say an excel spreadsheet...Inventory Items and stock qtys and possible prices w...
I need a formula for an Excel spreadsheet to do the following:
I have a known starting value;
I need a field I can input assumed appreciation (annual or monthly)
I need a field I can inpu...
We have just upgraded from Office 97 to Office 2007. One of the users is trying to open an Excel 97/2003 spreadsheet in Excel 2007, but in cells where data should be displayed, all that is sho...
My friend bought a new computer for her small sandwich deli and Quick Books 2008 Simple Start was on there so she decided to try it for the 30 day trial. The only thing she added was Cash Tra...
I have an Excel Pivot table which is based on a SQL Analysis Services Cube (created using MS Performance Point Server software).
I need to change the data Connection file (ODC) when I migra...
I have an Excel (2003) spreadsheet with a number of fields containing over 500 rows of data. An example field in the Excel spreadsheet would be "Last Name."
I also have an Access (2003) da...
Hello,
I am attaching a file with data and examples of pivot tables. I have been at this since 4am (9 hours) and am getting nowhere. This is for a project that was due last week.
I need to b...
Hi, I am trying to use the value in my MATCH formula to work in my IF formula, but to no luck.
The match formula is =MATCH(I689,C:C,0)
I am then trying to use that value I get in the MATCH f...
I have an Expense spreadsheet which displays columns for users to enter expenditure under certain columns, the user always enters Gross amounts (Cost + tax). Adjacent to each column, there is ...
How do I combine the below SumProduct Formulas. Whenever I try I get a N/A error. What am I doing wrong?
First Formula
=SUM( SUMPRODUCT((LEFT('NTCSS-RAWDATA'!B9:B2557,8)="NALC IMA")*('...
I can't locate clear answers to basic questions about Excel Macros: 1) Where is the code for a Macro I create stored? Apparently, it can be in one's PERSONAL.XLS file, but I have never seen a...
I have a spreadsheet with 20,000 rows formatted like this:
ID Description
000873 Breach of Implied Warranty
Negligence,Strict Liability
Unfair an...
