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...can't insert, delete or move pictures
can't insert, delete or move pictures
> can't insert, delete or move pictures
...WIndow 7 Outlook 2007
Can anyone help please?
In Outlook 2007 when setting up a calendar appointment the recurrence has
been set as the default, so I cannot make 1 meeting, only a recurrence of the
event. How can I change the default setting to 1 appointment as I do not have
an option to change the recurrence when setting up. The only way around this
currently is to set up a meeting as a recurrence, then go and change it later!
Does this also happen when you use Outlook in Safe Mode?
Start-> type; outlook.exe /safe
If not, it is probably caused by an add-in that you have installed. For
...windows live block list help
This is a multi-part message in MIME format.
Hello and good day to all=20
does any one know any way to get names out or off the block list in the =
messenger when the other user has not or will not delete my user id =
email address from their list I have tried contacting the other user to =
get them to delete my id but a few of the ids in the block list are from =
them dumb spim bots and I just want them out of it can some one try and...Switching between multiple open windows
I ran across an option to change how to switch between multiple open windows
on my desktop. It was an option to choose between hovering over a window or
clicking on it. Thinking that only having to hover over a window to switch
to it would save time, I selecting the option to hover... big mistake as it
just became a big pain in the a_ _ for me. Now I would like to change back
to one-clicking to change between viewed windows but can't remember or find
where the option is located. Any help will be appreciated.
On 2/03/10, rushl posted:
> I ran across an opti...Outlook pop up windows stops outgoing mail
In the last 3 weeks I continue to get a pop up window
titled "Enter Network Password". There is a key icon and
the request: "Please type your user name and password."
It then list my
Password: (entered with asterisk showing)
I continually enter my Outlook password with Bellsouth
and click the box "Save this password in your password
list" and click "OK".
Everything then works alright and then the window pops up
again in 5 minutes. It happens over and over again.
Anybody have any ideas on how to eliminate this? I use
XP Pr...Can I replace word by word in italics?
Is there a search/replace feature in Publisher that allows you to
replace a word by the same word in Italics?
Not in Publisher, but you can in Word using wildcards. Might try copy/paste into
Word, do the editing, copy/paste back into Publisher
"WISEMANOFNARNIA" <COHENMARVIN@LYCOS.COM> wrote in message
> Is there a search/replace feature in Publisher that allows you to
> replace a word by ...Only printing header in Windows Live Mail
My canon printer has suddenly stopped printing the email content - only the
Printing in word, excel etc not affected. Using W7 (+ Firefox if that
Any suggestions please
Does you have the same problem if you try printing from IE? WLM depends
on IE for printing services.
Take a look at this:
Print and Print Preview May Display Only Text at Top of Page
It's a similar problem for a different version but the fix may apply.
Mike - http://TechHelp.Santovec.us
"Jem" <Jem@discussions.mic...create new users STRANGE problem
Hi, I'm developing a web application (using standard asp and not
asp.net) to let certain remote users administer exchange 2003.
I have installed win2003 standard edition, exchange 2003 enterprise
edition,owa and my web application on the same server.
My web app, let users to create mailboxes, delete mailboxes, change
All works fine, but for example, if I reboot the server, a web
application user can create 50 mailboxes.
But when any of these users log on to owa, something goes wrong and
the admin user cannot mailbox enable other user accounts through the
web app, even if he ...can not delete emails
i went out of town and returned with 3000+ emails. some i
can delete, some i can not. i have tried to repair and
fix, i have tried to create a new profile and
import/export everything. any ideas? thanks in advance.
yes, the cannot move item(s). The initial error i get
when trying to delete is:
"the message interface has returned an unknown error. if
this persists, restart outlook". The only thing i can
think of is a damaged profile???
>Do you get an error when trying to move the item to
another folder (e.g.
>move the item to the deleted ...How can I line up 2 columns with similar information?
I have 2 columns with names in each and I'd like to line them up next to each
I think we'll need more information, Kathy. I don't understand what you're
trying to do. Can you give exactly what's up?
"Kathy" <Kathy@discussions.microsoft.com> wrote in message
>I have 2 columns with names in each and I'd like to line them up next to
Column A has employee number, Column B has the same employee numbers but has
addi...Can I retrieve deleted email from the enlarged database
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Email Client: pop
My v.X database is 950Mb with very little email. I know this is because of the deleted emails of the past and that rebuilding the database would produce a new database the right size. I would like to know if I can get to the deleted emails. Can I get them back. I have run in to an issue that I need them.
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12pt'>On 5/11/10 11:41 PM, in article <a href="59bb859f.-1@webcrossing.JaKIaxP2ac0&q...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" <firstname.lastname@example.org> 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...Unable to open the outlook window.
I just downloaded Microsoft Office Outlook 2003 to my computer. When I try to
open Outlook, the window opens for about 2 seconds and then closes
I received an error message: "cannot start microsoft office outlook. unable
to open the outlok window. the server is not available. contact your system
administrator if this problem persist."
I'm have home based computer and don't have an administrator. Can anyone help?
Did you create a profile with settings (email account, POP3 and SMPT server
names, etc.) for Outlook to use?
Outlook Ti...Dynamics CRM windows blocked by a pop-up blocker
Need some help resolving an issue. This morning opening records
through Outlook CRM stopped working. When clicking on the item in
Outlook, the following message would appear after a short delay:
"A Microsoft Dynamics CRM window was unable to open, and may have been
blocked by a pop-up blocker. Please add this Microsoft Dynamics CRM
server to the list of the sites your pop-up blocker allows to open new
windows:our server name"
The following items have been done in an effort to resolve the
1. Disabled IE pop-up blocker and checked computer for any other pop-
up blockers...Windows Media Player no picture 08-03-10
Vista windows Media Player 11 has sound and visualization but no picture on
some AVI files. One file that does not respond is Fill Handle.exe. AVI
which is a tutorial for Windows Office 2007.
...Windows XP Shared PC
We are using Outlook 2000. The PC, which already had
Microsoft Office 2000 loaded on it, was upgraded from Win
98 to Win XP. I then created Windows XP logons for all
four people that will be sharing this PC. When I did, the
Outlook shortcut automatically ended up on the desktop of
each person when they individually logged in. When I
clicked the shortcut the first time I went in to each
person's desktop, I setup the mail account for JUST THAT
PERSON. And when I go back and log into each person's
desktop it still shows ONLY THEIR ACCOUNT. However,
whatever mail they receive ALS...cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and
got it installed then opened Outlook and said it could not setup database. Is
BCM 2007 compatible with Enterprise and Windows 7. Is there a work around?
...Can MsPubliser do INCLUDETEXT or MasterDocument/SubDocument equiv?
I'm preparing a series of bifold + duplexed booklets. There are 8
page, 16 page, 24 page, and 40 page versions with much duplicated
text. I've used Word's Master-Document with sub-documents (and also
the INCLUDETEXT fieldcode) so that changes / typos only have to be
fixed in one file.
I'd like to use the same MasterDocument approach with Microsoft
Publisher 2003. Is this capability available with Publisher? This
would be for duplexed quad-fold versions that end up being 4.25"x5.5".
Does Publisher 2003 have the feature of a master document being able
to include separ...Creating the filter for the recipeint policy
Can you let me know what is the best of way of creating the LDAP filter for
the recipient policy if I want the policy to assign the email address based
on the admin group.This filter should assign the email address to the mailbox
Recipient Policies are based on recipients' attributes - admin group is not
one of them.
Perhaps look at other common attributes, or add an additional UPN suffix and
assign a common UPN suffix to these recipients, than use Recipient Policies
to filter based on UPN.
MVP - Exchange
NEW blog l...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...Publisher calendar, how can I show the previous/next month?
I need to show the past and previous months in blank days at the top of a per
month calendar, but can't see how to do that.
Create a yearly calendar in a new publication. Ungroup, copy the separate
months, paste to your main calendar.
Mary Sauer MSFT MVP
"Jennie" <Jennie@discussions.microsoft.com> wrote in message
>I need to show the past and previous months in blank days at the top of a per
> month calendar, but...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...How do I create a running subtraction column?
In other words, how do I create a column which subtracts from the preceeding
you may provide some more details what you're trying to do exactly.
Maybe post some example rows
> In other words, how do I create a column which subtracts from the
> preceeding cell?
If you want the balance in column B, and you are making entries in column A
which are to be subtracted from the balance, put the starting balance in B1.
In B2 put the formula =B1-A2
On Mon, 4 Oct 2004 08:35:08 -0700, "aschneider"
<aschne...Can I run ON from an external drive without it being installed on
Can I run ON from an external drive without it being installed on a local
"Ang130" <Ang130@discussions.microsoft.com> wrote in message
> Can I run ON from an external drive without it being installed on a local
With Ceedo software
> Can I run ON from an external drive without it being installed on a
> local machine?
YES, if run under Ceedo with the Argo installer.
In theory it should also work with a USB stick.
It would have a superfast stick, m...