excel #35i want to try this again. I am trying to determine a winner for each county.
In b5:e5 I have my canidates. In column A6:a139 i have my counties, B6:E6 i
have the votes for each canidate. in G6 i have my total votes, and in H6 i
need to input the winner by name using a formula. I tried
=index(b5;e5,match(max(b6:e6),B6:e6)) that gave me the person with the least
votes and i need the highest votes. Please tell me what am i doing wrong.
I am on windows vista home premium, excel 2007, service pack 1
thanks
Shone
> =index(b5;e5,match(max(b6:e6),B6:e6))
You must set MATCH to look f...
Postcard conversion...I have been printing 5 1/2 x 8 1/2 cardstock postcards and would now like to
convert my 2 per page size to 4 per page or 4 x 6 size postcards. How can I
convert my larger graphics and text w/o having to go thru the madness of
cutting, pasting, and resizing everything to the smaller size postcard?
Thanking you in advance.
Frank Engels
...
VC6 -> VC2005 conversion problemHello,
I'm converting my project from VC++6 to VC++2005.
among many compilation errors now solved, that one is stucking me :
I have that template :
template <class T>
class TLineApproximator
{
public:
//! \name Structures and typedefs
//@{
//! 2D homogenous point
struct SHomog
{
public:
SHomog(T _x=0, T _y=0, T _w=1) { x=_x; y=_y; w=_w;};
T x;
T y;
T w;
};
//! 2D point
struct SPoint
{
public:
SPoint(T _x=0, T _y=0) { x=_x; y=_y;};
static void CrossProduct( const SPoint& p, const SPoint& q, SHomog& r)
{
r.w = p.x * q.y - p.y * q.x;
r.x...
Is it possible to view Excel split screen by tab within same fileI would like to view split screen tabs within the same Excel workbook. Is
this possible?
Hi SS. Go to Window - Arrange - and select the view you would like. It
shows all tabs. Minimize or close the ones you don't want. I find the
vertical view the easiest to use. HTH
--
Sincerely, Michael Colvin
"SS" wrote:
> I would like to view split screen tabs within the same Excel workbook. Is
> this possible?
Window|new window
Window|Arrange (horizontal/vertical/whatever you want)
Check windows of activeworkbook (if you only want that one workbook)
You'll see som...
Outlook 2003 Cached Exchange Mode freezes upWe're using Outlook 2003 with the cached exchange mode
set. Sometimes desktop computer email will not update
when in cache mode.
What is required to fix this problem?
Thanks,
Jim
...
Converting from Pockect Excel to Excel XPI setup a mileage sheet for my Pocket PC which has Pocket
PC 2003 that came with Pocket Excel.
When I formated the sheet some of the cells have boarders
and others do not. There are a few cells that are
irregular from the others, for example Column B3 - B34 all
have a full boarder then in Column C the full border
extends down all the way down to C35, there is then
additional data with just a bottom boarder on D38.
This leaves Cell A34-A38 with out any data or boarders at
all and this is exactly how it locks on the Pocket PC. How
ever when I transfer the excel file to my Home Computer...
Excel 2007 "document not saved" when on a network share AND file set as an offline fileHello~
Have this annoying REPEATABLE problem with Excel 2007 running on Vista
Business saving to a share on Windows Server 2003. On the client,
Vista and Excel all up-to-date with SPs, the machine is part of a
domain, and some files on different shares are set to be available
offline.
On the server, Windows 2003 also up-to-date, the client user has full
permissions in all the directories in question - both share
permissions and NTFS permissions), and the directory is set to make
only files users specify to be available offline.
Client has no problem opening and saving files in Excel that ar...
MOVING DOCUMENT IN EXCELI NEED TO MOVE THE DOCUMENT UP, IT IS SHIFTED DOWN TO
WHERE I CANNOT SWITCH TO THE OTHER WORKSHEETS
Window|Arrange|Tiled and resize by hand??
LAURA wrote:
>
> I NEED TO MOVE THE DOCUMENT UP, IT IS SHIFTED DOWN TO
> WHERE I CANNOT SWITCH TO THE OTHER WORKSHEETS
--
Dave Peterson
ec35720@msn.com
...
ConversionsHello! I work as an Information Specialist. Majority of our job requests
involve conversions. We just received an Adobe Acrobat pdf in which the
original document was created in MAC OS. The conversion was successful
through Omni Page as we only needed to capture text to convert to a Word
document.
I was wondering is there any other suggestions you can recommend for
conversions from other softwares such as MAC. Thanks so much for your time.
A PDF file is a PDF file, no matter which OS was used when the file was
created.
If you want conversions for specific Mac formats t...
where do i ope PHStat in exceli have installed PHStat for excel on my computer, but i dont know where to
open it once ive opened excel. i have office 2003 so any help would be great,
thanks
Ramsbee987 -
> i have installed PHStat for excel on my computer, but i dont know where to
> open it once ive opened excel. i have office 2003 so any help would be
> great, thanks <
First choose Tools | Add-Ins. It should be listed, and be sure there's a
check mark. Then a PHStat item should appear on the menu.
- Mike
www.mikemiddleton.com
If you have phstat and excel on the desktop, you can drag phstat on...
Outlook 2003Exchange 5.5, sp4 - Outlook clients using 2003 or XP are getting the popup
messages that Outlook is attempting to contact the exchange server. This
happen very frequently and is annoying my users. I know we can turn that
option off - but management now thinks that my exchange servers are to
blame. Has anyone else seen this or having the problem? My Outlook 2000
users are not experiencing any latency etc - only 2003. Maybe a registry
hack we could do during installation? Any ideas? TIA
Nancy Stevens
Nstevens@tycoint.com
...
excel as a repositorywhy is it that people use excel for a repository?
i mean-- Access was used to store data-- Excel doesn't have the basics
for storing data.
i mean-- why do people use Excel EVER?
it kinda blows my mind.. i just wish that you kids would grow up and
learn a real program.
i mean-- im trying to import data from Excel into a database-- and i
have this column that Excel keeps on coughing on.. i mean
i just dont understand why people make all these pretty reports in
Excel-- the problem is that Excel is a complete 1 way street.
Give excel real validation-- give excel the ability to store data...
TYPE CONVERSIONMy goal is to automatically update the End Date to display the create date
from a record previously reported. For example the end date for the first
record listed below should be 9/24/2009 12:41:00 PM and the end date for the
third record listed below should be 8/21/2009 9:00:00 AM.
ID CATEGORY RANGE CREATE_DATE END_DATE
3426 Service 24 months 9/15/2009 9:35:00 AM
3426 Service 24 months 9/24/2009 12:41:00 PM
3426 Service 36 months 8/20/2009 12:23:00 PM
3426 Service 36 months 8/21/2009 9:00:00 AM
I have the query listed belo...
Cannot select and then copy an entire worksheet, in Excel 2008Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
Have been using excel 97 2004 with no problem for years. Now have new Mac and new excel spreadsheets which are 750 times bigger. Now, as earlier, I can still 'move and copy' a sheet over to a new workbook, but when I select the entire sheet (top left corner), then 'copy' the selection, excel freezes, and I am warned there is not enough memory. <br><br>I want to be able to create individual invoices from my own invoice template spreadsheet (which contains formulas referring to custome...
how do u get Excel file sizes smaller?What takes up so much spaceSometimes Excel files get incredibly big very fast apparently without
adequate reason. Once big one seems to never be able to get them smaller
again. Any ideas why and how to reduce? What are the factors that one must
avoid if one needs small files? (My current file has jumped to 42Mb and needs
to go back & forth over slow dial-up lines. Zip only reduces it to 39Mb).
Thanks
A couple of things I have noticed along a similar line ....
I sometimes copy a large file into a worksheet, then delete a lot of
it to retain only the parts I need. If I save it while the large file
is there, ...
Pasting Word table cell with paragraph markers into single Excel cI have a Microsoft Word document that contains a table, each cell of which
may contain paragraph markers. I need to copy and paste this table into
Excel. However, whenever a cell from the Word table contains paragraph
markers, rather than pasting the contents of the entire cell into a single
cell in Excel, the paragraph markers are treated as delimiters, and the data
is pasted into multiple Excel cells. If the cell from the table in Word
contains one paragraph marker, then when I paste that cell to Excel, it
pastes it into two cells. If it contains two paragraph markers, then it
pa...
Excel File OverwriteHow can I restore an overwritten file? I was backing up my files and I
accidentally saved an old version instead of the new one. This sets me back
to May 2009...I cannot find the file I used on Friday Jan 16, 2010.
Help please!!
Hi,
Check with IT if the have backed up your file, or see if you sent the file
by email to someone, otherwise sorry but the file is gone
"GradAsh10" wrote:
> How can I restore an overwritten file? I was backing up my files and I
> accidentally saved an old version instead of the new one. This sets me back
> to May 2009...I cannot ...
Outlook 2003 Sort issueI am using Outlook 2003. The issue, which is Intermittent, when i'm
viewing my mailbox and i click on an email just to highlight but not
open and then click on the subject column to sort by subject. The mail
sorts by subject but the email that i had highlighted isn't
highlighted anymore and is lost in the sort. My mail is being
delevered to a .PST file and i am running windows XP. Has anyone seen
this problem? Please help
Yes, I've seen that behavior before. I don't think there's any fix for it,
unfortunately.
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
htt...
Copying formulas in excelI have the column A full with 252 entries. The formula I apply between cells
A2 and A1 is:
ln(A2/A1)
and I get a result.
I want to copy this formula but in a way that the Excel itself to perform
the following calculation:
ln(A3/A2)
ln(A4/A4)
ln(A5/A4)
etc.
I would be pleased if someone could tell me if I can achieve that.
--
antonis
Click on the first cell with a formula in it. A small black square
should be at the bottom right corner of the outline of the cell. Click
and drag this cell down; it should copy the formula the way you want.
Szalapski
--
TommySzalapski
------------------...
M2004 Deluxe-TIRA to Roth Conversion QuestionHi,
I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a Roth
back on Nov 24th. The conversion was with the same mutual fund, ticker
symbol. How do I do the transaction within Money to effectively close the
TIRA and have the Roth Start on 11/24/08? I want the converted amount, for
tax purposes, to show up on the Money Home page.
Thanks!
Transfer Out investment activity?
"Mike" <Mike@nothere.com> wrote in message
news:%23UAtIoDaJHA.3908@TK2MSFTNGP06.phx.gbl...
> I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a
> Roth b...
Ho wto display a list of appointments in outlook 2003HI I'd like to find a way of displaying a list of my appointments
similar to the task list option. Is there any way?
cheers
DW
...
Excel ProtectionI have set up an excel spread sheet and have used the data group an
outline function to group rows together.
.However when I choose sheet protection I am unable to use the grou
and outline function.
I also need to protect certain cells within the document, whil
allowing users to edit pther ranges.
Any suggestions gratefully recieve
--
Message posted from http://www.ExcelForum.com
Hi james
Right click on the Sheet Name Tab and select "View Code" and paste in
the code below
Private Sub Worksheet_Activate()
Me.Protect Password:="Secret", UserInterfaceOnly:=True
...
excel organizational chart subordinate goes left not downTrying to create an excel organizational chart but the subordinate selection
goes to the left as though it were an assistant choice and not underneath as
the diagram suggests. How do I get the subordinate underneath and not to the
left or right?
...
ConversationsI have searched for and got a list of 70 items in my inbox, which I
now view as conversations, bbut the count at the bottom of the screen
still shows '70 items'.
Is there a quick and easy way to count the number of conversations,
rather than the number of items?
Thanks,
G
No.
<george.walsh@doeni.gov.uk> wrote in message
news:6798cc53-de91-4772-be4e-9de69dc45289@w40g2000hsb.googlegroups.com...
>I have searched for and got a list of 70 items in my inbox, which I
> now view as conversations, bbut the count at the bottom of the screen
> still shows '70 items'.
...
Problem with Excel HelpWIN XO HE, XL 2002 SP3
Hi, every time I hit F1 within Excel, I am getting the following error
message:
"The window name "langrep" passed to HH_GET_WIN_TYPE has not been
specified."
Any idea how to fix that?
Tx,
S
I have no idea, but I'd start with:
Help|Detect and Repair
(or maybe reinstall excel/office)
(I have no idea what "WIN XO HE" is either--winXP Home???)
saturnin02 wrote:
>
> WIN XO HE, XL 2002 SP3
> Hi, every time I hit F1 within Excel, I am getting the following error
> message:
> "The window name "langrep" passed...