Looking for an excel function which can mirror opposite the data
There are 2 data sets is assumed running in A1 down, viz.:
From A1 down to A10, are showing a set of number: from 1 to 10
In the cell from B1 to B10, are showing from 10 to 1, which is decreasing
from 10 to 1.
My question: I want to know is there any excel formula which I can place in
B1 and pick A10's number; B2 pick A9's number and etc.
I know there is an easy way to do it, just type "=A10" in the cell of B1, but
it is quite difficult to do it when I have more than 200 number, e.g. A1 to
Thanks for your advice,
Message posted via OfficeKB...2 Questions on Pivot Tables
Any assistance appriciated. (Excel 2003)
1) I have a simple Pivot table showing 6 groups with their totals and a
Oz 22 etc.
Grand Total 125
I want to Pivot Graph this data, no problems. I want however an extra line
to show the total on the Secondary Axis. I have almost got it by placing
the column in a second time as a Running Total and then as a Line on my
chart, hiding all the values until the last point.
However I would like if possible the Total as a horizontal line across the
2) I h...Duplication of labels within pivot table
I am using a cvs file to copy & paste data into a workbook (not saving
the file as an excel document and then coping & pasting into the
workbook). This workbook is updated weekly from the same hard format
reporting system with current information only - all other aspects of
the report remain the same. I am seeing duplication of the labels
within my pivot table. It seems that the information is being recorded
as stacked data not as continuious data within my data base. Could this
be caused by the copy & paste directly from the cvs file rather then
from an excel file.
At this tim...Analysis Cubes
What are the minimum requirements for using the Excel Addin for Analysis
Cubes? Do you need to have GP installed to use the Excel AddIn? I have some
users that need to access GP data, but I donot want to have to install GP on
their Workstations, how do I do this? I am using GP version 8.0.
See below for the requirements:
1. Supported Operating Systems: Windows 2000 Server; Windows 2000 Service
Pack 2; Windows 2000 Service Pack 3; Windows 2000 Service Pack 4; Windows
Server 2003; Windows XP; Windows XP Service Pack 1
2. To use the add-in with Analysis Services 2005, the following compone...Blank Emails #3
Environment is Exchange 2003 Standard loaded on a Windows
2003 Server Standard Edition.
My users are using Outlook 2002(XP) and some of them are
using Outlook 2003. Some of them create Rich Text, some
Plain Text, some HTML. I have been going through trying
all different ones for them. This has never happened until
Exchange 2003 (installed roughly 1 1/2 Months ago).
Problem only popped up a week ago.
The problem is, users are sending and recieving blank
emails occasionally. Even the copy that goes into
their 'Sent' Items is blank. They all have the latest
Service Pa...Unhide Tables in Acc2k7
How do I unhide tables in the Acces2k7, please?
When I try:
Navigation Pane, Access Options, Navigation Options, the Groups for "Tables
and Related Views" is empty.
Thanks in advance.
Do they show up if you select Object Type instead?
Try Office Button, Access Options, Current Database, Navigation Options
button. When that window opens, select all the Display Options at the lower
left of the window.
If that doesn't work, make a copy of your database and hide it away in a
safe place. Then do a compact and repair. If that doesn't work, open a...excel #159
How do I prevent 2 files from opening up when I click on one file?
What two files are opening?
If it looks like:
Then you actually only have one workbook open--but you have two windows to that
single workbook opening.
Click on the window you don't want anymore and hit ctrl-w to close that window.
Then save the workbook.
If that's not it, maybe you have another workbook in a folder named XLStart.
Use windows start button and search for XLStart.
Then look in each of those folders for a workbook file (*.xls). Move it or
delete it if you'r...where do office 2000 (including excel of course) service packs go
where do office 2000 (including excel of course) service
packs go. I don't know why they don't give you the option
of downloading and saving them before installing the
various program updates and service packs. This way
whenever I do a fresh reformat of my computer, i need to
spend hours getting all the updates again off of the
internet, where as if I could save thme, I would just have
to re-install. Any help would be appreciated
Don't know about Office 2000......never used it, but Office Download center
offers you the choice of installing or saving to install file to disk....Number of wsheets in an excel workbook???
hey guys, how many wsheets does one excel workbook have? I need to have
about 66 - is that possible?
mariasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31726
View this thread: http://www.excelforum.com/showthread.php?threadid=521656
I have created a workbook with more sheets in it that that. obviously
depending on the amount of data on each sheet your workbook could be
getting quite large and possibly unmanageable! I guess you will have to
try it! D...moving text from a word document to excel
I'm moving a large amount of text from word documents to an excel
spreedsheet, and I have a few questions:
1. When I copy/paste text from the document to the spreedsheet, the text
will sometimes expand the cell very large. How can I keep all the cells the
2. When I click on a cell that has text in it to read it, sometimes it will
only show the text in a long downwards column, whereas other times it shows
it as a big 'blurb' to the right side (which makes it easier to read). How
can I set it up so it is not in a long column?
3. How can I insert cells without h...Excel-Multiple Cells Being Hi-lited
Sometimes when I'm setting up a worksheet and I left-click in a cell,
multiple cells in the same column are hi-lited. After it happens the first
time, it continues as I move through the worksheet, reducing my ability to
get work done considerably. After some trial and error, it seems to occur
when I've been adding and/or deleting columns and/or rows, after a header has
been installed. I can move throughout the worksheet using the arrow keys,
but it is a time consuming and cumbersome technique. I think the version I'm
using is Office Professional 2007 (file extensi...Pivot Options Disappearing!
I created a pivot table which displays data for January Through December. I
ran a tesxt and deselected the "Show All" check box so that I can just
display Jan, Feb, and March data. When I go to reselect April - December data
those options are no longer available! How do I get excel to keep those items
on the list so that they can be selected later?
There's no Unhide option for the data fields. Once you uncheck a field,
it's removed from the pivot table. To see it again, you can drag the
field back in from the field list
> I created a pivot tab...memory problem of Excel 2003 copy & paste
I am using Excel 2003 for some project.
I am having 2GB C drive harddisk space.
After a while, the Excel begins to be extremely slow in copy and
It takes about half an hour to copy and paste just a few cells...
I've consulted people. It seems a memory problem.
But I cannot close my windows and kill the processes, because I am
running long-running (overnight) jobs...
I cannot reboot either.
Is there a way to clean the memory and let Excel 2003 clipboard
function properly without rebooting or killing my 4 long-running
p.s. I am sure this is an is...in creating a pie chart in excel 2007
How many rows or columns of data can the pie chart plot
I once tried 360 cells and got a wonderful Moiré pattern
Why not just experiment with 1, 2, 3 dozen and see for yourself if the
result is acceptable ?
Microsoft Excel MVP
"bsalohcin" <email@example.com> wrote in message
> How many rows or columns of data can the pie chart plot
According to MS:-
Data series in one chart 255 (max limit)
Data points in a...surveys and pivot tables
I have reinvented the wheel by making a paper survey and then entering all
the answers into a spreadsheet. the format of the spreadsheet is; the first
column is the id of every person surveyed and the next 9 columns are their
response to each of the 9 questions (responses are numbered so each response
is a number from 1-8)each row is in reference to the answers that the person
gave. so a typical row would be: PCA 1 6 1 2 2 1 5 8 1. pca being the ID and
the other numbers being the response to the corresponding row's question.
The question is: how do i set up a pivot table to analyze ...How do I add a Trendline to a Pivot Chart
How do I add a trendline to a pivot chart? Help
Maybe rightclick on one of the series lines in the chart and select Add
> How do I add a trendline to a pivot chart? Help!
...pivot table changes when data is refreshed.
I have a pivot table with grouping based on a field called "period
which is of date type. I have grouped it into months and quarters
However when i refresh the pivot table whenever the data (which is in
seperate sheet) is changed, the groupings are going out. I want t
preserve the groupings as they are like a template. How do i stop th
changing the format and layout of the pivot table whenever i refres
the data? any ideas? please help.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages d...How do I make a particular column required in Excel? #2
Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
Is there any way I can make this particular column required so that if it is
not filled in, the chart will not complete properly?
Thank you in advance for any advice or help--I'm a bit of a novice to this!
...Excel Events Conflict with VB and C# AddIns
I have two com addins running in Excel. One is written in VB and the
other in C#. Both addins are interested in the Workbookopen event.
When the event is triggered the c# code captures the event but the VB
code does not. If i disable the c# addin then the vb code works. Looks
like the c# addin is somehow blocking the vb events.
Anyone know how to fix this?
There is only one WorkbookOpen event, so once one add-in hooks it, there
is nothing for the other one to hook.
If you are hooking the WorkbookOpen event in your add-ins, this is
likely your problem.
You may need...linking tables for maximum efficiency
I am trying to build two tables containing information about fish that we
FishPK (one for each individual fish; autonumber)
CollectionPK (links to tbl Collection which contains information about where
and when we collected the fish)
The chemical analyses are only performed on a subset of the entire fish
I am pretty happy with this design, but am open to suggestions! In
particular, I want to know if this design allows me...new blank doc
I some how corrupted my blank doc. When I go to file and open. I get a blank
doc with 3 cloums saying next record. How can I get my blank doc back so
that I can do my work?
While this newsgroup is for Microsoft .NET (dotnet) questions, you should
locate the hidden system file called "normal.dot" and delete it.
"new blank doc" <firstname.lastname@example.org> wrote in message
>I some how corrupted my blank doc. When I go to file and open. I get a
>...Portrait only printing in Excel
I have an interesting problem. I have a workstation (Dell
Pentium IV XP PRO) that has Office 2k on it. When I/we
try to print to a networked printer, the document will
only print in portrait no matter what changes I make to
page settings or printer settings. We are on Active
Directory, so as long as the documents are submitted from
a different computer, it will print fine. Any suggestions?
This could be a complete waste of your time, but the first thing I'd try is to
reinstall the printer driver.
(maybe even get a fresh driver from the printer manufacturer's web site???)
Howa...VBA & Excel
I don't know a lot about VBA.
I need to make an Exe file with VB to give 3 buttons each button starts an
excel work book (book1, book2,book3). I am thinking of a form that appears
on the screen.
When the "Exit" button is cliked it will make an other copy of the 3 excel
files on another folder (say: d:\data) for example (like a back up copy).
Can any one help
You can not make exe files with VBA. If you can use VB5 or VB6 instead then
adapt the VBA code from
http://www.erlandsendata...Create Folders in Directory with Excel VBA?
Is there a way to create folders with a specfic names, and have them
saved in a directory. I have an excel file with 250 records with my
desired folder names.
I want to avoid having to through the process of selecting <File | New
| Folder> then naming the folder -- 250 times!
I imagine there's an easier way with VBA... please help!
It can be done something like this. Attatch code to a command button on the
Alter code to suit your reqirements. Test on a dummy workbook first until
you get it to work the way you want.
Please note that there are practical lim...Pivot Chart Created from Pivot Table is Blank
HELP!!! I am following a tutorial in an Excel 2007 book step-by-step. In
one of the lessons I was able to successfully and easily create a pivot chart
from a pivot table. In my next lesson, I am following the exact same steps
(even have started over a couple of times), and when I create a pivot chart
from the pivot table in this lesson, it creates a blank chart. WHY DOES IT
DO THIS??? I know I have followed the steps correctly. Any ideas on why
Excel isn't cooperating with me on this lesson would be soooo appreciated.
Blank charts usually result from having your cursor in...