Find MAX data in sheet (Cell)
How would one go about finding the cell that contains the MAX info, o
say any/all cells that exceeds 8,000 characters/spaces in a Excel page
confuzedagain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2943
View this thread: http://www.excelforum.com/showthread.php?threadid=49148
1. Highlight the entire document
2. Select Format->Conditional Formatting
3. Select "Formula Is"
4. Input this formula
5. Format with something obvious like green bac....NET 3.0, 3.5 SP1, Media Center Issues
Well, I managed to download .NET Framework 3.0, in lieu of 3.5 simply
DISCONNECTING non-stop, and though it (3.0) tells me that it has been
successfully downloaded and you can now disconnect from the internet",
"setup is proceeding to install it" etc., and not more than a few seconds
elapse before it tells me that "an error occured, all files are being removed
from the computer"...an icon is on the desktop, and I'm advised that when I
click on the install icon it will be installed...again, and again..ad nauseam.
3.5 SP-1 will not even complete downlo...duplicates #3
Does anyone know how to delete duplicate entries from excel?
With conditional formatting it seems ezy enuf to find dupliates but
how to delete them ... apart from one at a time that is. Ok when the
list is short but when its long as your arm, that can seriously cut into
ones drinking time.
One way ..
Take the sample data below assumed in A2:A5:
> Mark Davies
> John Smith
> David Jones
> Mark Davies
> David Jones
> John Smith
Put in B2: =IF(COUNTIF($A$2:A2,A2)>1,1,"")
Copy down to B5
This'll mark any duplicates in col A with a &quo...Newsgroups in Outlook 2003 #3
I know this sounds stupid, but I cannot find out how to get my newsgroups integrated with Office 2003
Can anyone send me the directions [ eg. files ->...]?
You cannot. Newsgroups require Outlook Express to read.
"Andreas" <firstname.lastname@example.org> wrote in message
> I know this sounds stupid, but I cannot find out how to get my newsgroups
integrated with Office 2003.
> Can anyone send me the directions [ eg. files ->...]??
Is that a n...mailbox size #3
I want to decrease the size of our users mailboxes to decrease their limits. To do this, I need to justify that any mailbox size over 500mb needs to be revised because ...(good reason).
Does anyone have a MSFT document that explain something like that?
I dont think you will find anything like that.
What is your SLA in case of disaster and you need to do a full
On Fri, 04 Jun 2004 18:20:51 -0200, Marcelo Moraes
>I want to decrease the size of our users mailboxes to decrease their limits. To do this, I need to just...Can a macro open another worksheet?
I've got a macro that I need to run on about 200 spreadsheets. Is there
a way to get it to select and open all 200 spreadsheets?
Are they all in the same folder?
In fact, do you need to open all the workbooks in a folder?
Or all the workbooks in multiple known folders?
If you have files in one folder--but you want to choose (click on the first and
ctrl-click on subsequent in the file|open dialog), you can do something like:
Dim myFileNames As Variant
Dim iCtr As Long
Dim wkbk As Workbook
myFileNames = Ap...Export data in XML through Web Services
I have a WebMethod that retrive data from a DB and I want to return this
data in a XML format.
I try to do with the TextWriter class but I wasn't able to do, because I
didn't found any example thet explain how to use the Stream attribute.
Can I use the TextWriter or I have to use the XmlDocument class?
Thanks in advance
can you show us the code now, and
show us what you are getting on the wire
and show us what you would like to get on the wire?
http://www.15secon...Share Workbooks and Comments #3
Can anyone help me with this one...
I have a simple spreadsheet which is shared and resides on a server.
Apprx 6 people access and modify the sheet and save their modifications
back to the server.
No 2 people ever change the same cell so there are never any conflicts.
The problem I have is that often the comments in a cell do not upload
to the server. The user is unaware of this util he closes and re-opens
the workbook to find that all of his changes have been saved but none
of his comments.
I have been getting the users to make their own copy at the end of the
day and if they e-mail that c...Number format #3
Ah, works perfectly. Thanks
carg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1527
View this thread: http://www.excelforum.com/showthread.php?threadid=27578
...Where do I get Visio 2003 electronics template?
On Wed, 4 Feb 2009 13:06:52 -0800, splendidbcpgm
>Where do I get Visio 2003 electronics template?
Would you like to have a look at my
Regards, Paul Herber, Sandrila Ltd. http://www.sandrila.co.uk/
...how do i search an excel sheet for links to another spreadhseet?
Is there a Find function that allows me to look for links in a sheet?
When I can't find links, I'll use Bill Manville's FindLink program:
> Is there a Find function that allows me to look for links in a sheet?
...Open & update another file (through macro) while running macro
I am using MS Excel 2003 and I need help to solve my problem.
One excel file (suppose A.xls) in which I’ll update my graph and the data is
available in another file (suppose B.xls). What I am doing (through macro) is
that I have created one button (in A.xls) and when I pressed it; its open the
file B.xls (the data file) and at their I select month from drop down from
which its update the pivot table based on the selection month and then same I
was doing with another data excel file (suppose C.xls).
Is there any solution that when I pressed button from file A.xls its ...data labels in charts
This is a probably one of the simplest questions but I'm just starting to
I have entered a category title "year" in cell A1 and entered from 1995 to
2000 from A2 to A7 that I want to appear on the horizontal axis. I have
entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When
I choose a "column" chart my vertical axis appears correctly but the
horizontal axis does not include the years as labels. The labels that appear
are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick
up the data labels from colu...Cell Reference #3
In a workbook, is it possible to know all the cells where
a particular cell is referenced in a calculation.
Specifically, if I make a change in one cell, what are all
the cells that will be affected.
...how do I get old versions of modified files?
I made a mistake and modified a file, how do I get back the old version? Thanks
From your backup, which, of course you take every evening !!!
"Power Image" <Power Image@discussions.microsoft.com> wrote in message
>I made a mistake and modified a file, how do I get back the old version?
...data extraction from excel
I need to pull information from one collumn. If the collumn is comprised of
yes's and no's, can excel create a list of just the yes's?
Try something like this:
Assuming your list is in A1:B100, with
D1: Question (the same col heading as A1)
E1: Response (the same col heading as B1)
Select your list (A1:B100)
List Range: (already selected)
Criteria Range: C1:C2
Click the [OK] button to filter the list in place.
To copy the matching records to another area:
Click: Copy to another location
Copy...QUESTION- Simpler Way to Add a Data Series to Other Graphs?
I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs.
When I add a new data series to one graph, it is defined by 3 values
(Name, X Value and Y Value)
If I want to add this data series to 7 or 8 add'l graphs, I know that
I can copy/paste these 3 values to each of them.
Is there a simpler way to accomplish this?
...Compare two Sheets with Conditional Formatting #2
I'm going insane
I'm trying to compare two sheets using Walkenbach's approach but for
some reason when I use it...certain values don't show differences.
Sheet 1 (Range Name is Grid) has 18000 on Cell A1
Sheet 2 (Range Name is OldGrid) has 18000 on Cell A2
So if I change Cell A1 on Sheet 1 to 1 it should show me change but
no...it just does nothing. However if I type 133...it shows change.
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
Selection.FormatConditions(1).Interior.ColorIndex = 40
Help really appreciate...cannot copy from one pub to another
all of a sudden, i cannot copy and paste from one ms pub publication to
another ms pub publication.
here's what i've done:
i ran disk cleanup.
i ran norton live update.
i ran windows update.
i ran office 2000 update.
i ran detect and repair inside help in pub 2000.
none of the above helped.
you said "is clipboard set to automatic in computer services?" can you tell
me where computer services is? i looked in control panel, administrative
tools, component services and computer management. I ended up in console
root, component services, computers, my computer, found ms pu...pasting excel data in a powerpoint slide
I am attempting to paste an excel data table in a powerpoint slide but once
pasted, the data is cut off. If I double click and enter the excel data
table and resize the window from Powerpoint, the same data shown simply
stretches to the new size. I have tried numerous ways of pasting from the
excel sheet and it still acts the same. I tried a new workbook and was able
to resize correctly. But to recreate all of the data and formulas in a
different workbook would be difficult. Is there a setting or something in
excel that is not allowing me to resize this particular workbook?
Thanks..."Message Tracking Center" showing incorrect time #3
I have applied all of the DST patches for the OS and Exchange Server. OS is
Server 2003 Standard (latest patches) and Exchange 2003 Standard (latest
I noticed today that when I go into the "message tracking center" teh defult
end log time is one hour ahead of the computer time.
Also, all of the sent times being tracked are showing as being sen one hour
in the future. (i.e. real time is 3:00 PM, messages in tarckign center show
having been sent at 4:00 PM).
I don't have an answer, but I'm seeing the same thing on my system.
"Bob...many sheets from "master data"
In the last few days, ive posted some questions with some success, bu
not being able to completely work though my problem. Given that I a
novice/intermediate in relation to VBA, I am having extreme difficult
augmenting the code to do what i like.
Attached is the file so you can visualize what I am talking about.
What I want to do is to put each "page" of data on a new slide. As yo
can see, all the data is found on the first page. In column T, you ca
see where each new page starts (as indicated by the data and pag
I having trying tirelessly to get the code su...Prevent equation from skipping data when referencing import data?
I am referencing data that is being imported from access in table on a
seperate worksheet. When the data is refreshed, only the last new entry is
placed in my seperate table, not all of them. How do I fix this?
...Input formulas in a defined data range and convert results as valu
I have a dataset for users to view data. It has the following format till
year 2010 and have portions of topics like forecast, shipment, aging .... and
the whole dataset can go very long vertically. Within each topics is the type
of products measured, below is an extracts of my dataset:
Forecast Accuracy Jan 2007 Feb 2007 Mar 2007
Prod A x x
Prod B x x
Prod C ...Can't get out of selection? Assistance would be most appreciated...
Perhaps I have done something inadvertently.
I am in an Excel workbook and I appear to be in the middle of selecting
a block of cells. Everytime I move the cursor, the cell selection area
changes. I can't Esc out, or use the Enter key. Mousing over the
menu, the menu does not respond.
Rather silly really, but I desperately need to use this workbook and
nothing seems to function. Even when the cursor is moving over the
menu items, the cells selected in the workbook area still seems to be
changing. I can't use the menu - the arrow keys don't work.
Does anyone know how to &quo...