There is probably no way to beat this, but it's worth a try.
I am downloading a list and if count this list with the following formula it
gives me what I would expect.
Column A = 285 names (contiguious) (Starts in row 2)
gives me 285
Because this list includes a lot of repeats and I am interested in a count
of unique names, I sort the list.
Then in column B(B2) I insert the formula =IF(A1=A2,"",A2) and copy it down.
This gives me a list with lots of holes where the repeat name occur.
I use the formula: = COUNTA(B:B) and expected a number much les...Call in?
Do new owners of Office X have to call up Microsoft to register their
copy? If yes, what's the number? thanks.
Ming <firstname.lastname@example.org> wrote:
> Do new owners of Office X have to call up Microsoft to register their
> copy? If yes, what's the number? thanks.
Nope. We're not using Windoze :->>>
This version does not require activation.
- Mac:MS MVP (Francophone) -
(MS) MVP: http://support.microsoft.com/default.aspx?ln=FR&scid=fh;FR;mvp
Newsgroups produits MS: http://support.microsoft.com/newsgroups/?ln=FR
...Excel: Can I extend the amount of characters in a text box?
I have several forms where I've merged several cells (say 3 rows of
cells each). They're all formatted for text, but I appear to b
limited to the number of characters regardless of the size of the box.
Is that an Excel limit or is there a way to increase this amount?
Thanks in advance for all your help.
Message posted from http://www.ExcelForum.com
the limit is 1024 characters. You can extend this limit with manual
entering line breaks. Use
to do this
"Healingbear >" <<Healingbear.19t981@excelforu...Covered Call Options
I do I go about dealing with a covered call transaction in Microsoft
Money 2007 Premium? Currently what I am doing is inputing the option
symbol, and choosing the transaction "Sell to Open" then when I go to
expire the option I try to do a Sell to Close. However it does not
seem to work? Also what happens if instead of expired I has the
position assigned? how would I account for that? Thank you.
In microsoft.public.money, Shhhh wrote:
>I do I go about dealing with a covered call transaction in Microsoft
>Money 2007 Premium? Currently what I am doing is...Formatting exponentials in Excel
I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used
The thing is the space is GB or MB (1x10^9 or 1x10^6)
I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?
Hope that makes sense,
Please keep all correspondence within the Group, so all may benefit!
"N...How do you do a strike out in an Excel cell?
How do you do a strike out in an Excel cell?
Format | Cells... | Font | Effects = strikethrough
"dgalati" <email@example.com> wrote in message
> How do you do a strike out in an Excel cell?
...Call center tracking and reporting
Anyone use CRM 4.0 for call tracking? Our Sales/Marketing is set up. Now I
need to decide how to most efficiently customize CRM 4.0 for our company's
call tracking portion. Can someone send me a link to information?
when placing a telephone call using outlook, everything
works fine except I can't hear the person i am talking
to. They can hear me find. When I use a telephone
program not associated with outlook every thing works
great. can someone help
...can't delete text box word 2007
I am using Word 2007 and Windows Vista. I inserted several text boxes, and
now want to delete them. I have selected the box and hit delete, but it is
not working. I am sure the cursor is outside of the box, not in the text
portion. Any suggestions would be greatly appreciated.
Are they floating? This may be a bit of a bug. Try right-clicking and making
them In Line. Then select and Delete them.
Terry Farrell - MSWord MVP
"TL" <TL@discussions.microsoft.com> wrote in message
> I am using Word 20...Excel VBA Question
Ok, I am stuck trying to write a function to do the following, and it
would be greatly appreciated if someone could help me.
I have two columns, one of data, and another of dates. I need to write
a function that filters by dates, and counts the total number of items
My data (column 1) has Members, Non_Members, and Other. My Dates
(Column 2) have, well, dates.
I have a report sheet that I need to report the numbers. So in the
report for each data type (Member, Non_Member, Other) I want to be able
to use function (=blah(date I am filtering for less than or equal to))
an...Closing Excel 2000 from VB (Unwanted process EXCEL.EXE)
I have an Access database - it uses the following code to open Excel
Public Sub OpenXlSheet(strReportName As String)
' Check if excel is open, close it if it is
If AppInUse("xlmain") <> 0 Then
Dim objExcel As Excel.Application
Set objExcel = GetObject(, "Excel.Application")
Set objExcel = Nothing
Do While AppInUse("xlmain") <> 0
'open a fresh excel application and load strReportName
Set objExcel = CreateObject("Excel.Application")
objExcel.Appl...Insert spinning button with time format in Excel 2000?
I am making a form template in Excel 2000. Every time I try to enter a
spinner button I can't get it to work with time format. I want the time to
be between 00:00 and 24:00 with 15 minute increments. I've tried with and
without the colons but nothing is working.
I put a spinner from the Forms toolbar on a worksheet.
I rightclicked on it and chose format control.
On the control tab, I used:
Minimum value: 0
maximum value: 96
Incremental change: 1
And cell link A1
Then in B1, I put:
and formatted as time: hh:mm
96 is the number of 15 minute increments in a day (4*24...very slow to open excel file
hello, my computer in office is using WIN 98 SE, i found that it's too
slow to open an excel file recently. please help
thanks a lot
Most probable causes are:
Too much accumulated junk in:
Shut down your computer and re-start. Then delete all contents of the
Alternative might be a bloated Excel.xlb file.
Locate the Excel.xlb or Excel10.xlb file using Start > Search > For
Files and Folders. The xlb file should not be above around 30kb and is
usually much smaller. If it is bloated, there's not a lot that can be
done w...Calling Macro
I have macro like this
Counter_item = 0
For Each Item In nodups
counter_item = counter_item + 1
bic_var = Item
I have another macro
If counter_item <= 1 Then
In the first macro i am declaring counter_item equals to 1.
In my second macro i need to call that number.
At the to of the module put:
Public Counter_I...excel online
How can I put an excel xls on the webserver so that I can use
to click and fill up the information and then click a button to send an
email to a default sender? Please advise me the methodology. Thanks.
...Excel construct single chart from 2 charts
Hello All, Anyone an idea how to construct such a chart in Excel?
I know you can build more then one chart into one chart sheet but what
i really want to do is construct one chart or 2 chart objects
assembled into 1 so they can be exported into 1 gif as per above
looked at the charting samples at the John Peltier site but still got
no idea how to construct this
The way I've done this is by embedding two chart objects in a blank
chart sheet. A little VBA to make sure the chart axes line up. Then the
chart sheet is exported.
-...Word Document 01-14-10
I have two Word documents saved. Everytime I access one of these documents
to make a change, the cursor just freezes as soon as I hit any key. I have
to hit Ctnl, Alt, Del to exit the document because the entire page is locked
up. What causes this and how do I get by this freezing? Thanks.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
> I have two Word ...Word document
Is it possible from an Attachment or Hyperlink( or any other) field to
launch Word, create a document, save the document and place the document name
in the field where launched? I know that there is code to launch Word it is
the return part that I do not know about.
thanks in advance.
As a general rule, you don't want to save the document in the database, but
only store a path name to the word doc.
I would suggest that you *ask* the user for the name, and *then* launch
word, create the doc. that way, you already know the name + path name.
I have a sample word template system tha...Workflow -Assembly Call
How does add subtract in the Workflow>> assembly call works.
I do understand that ypu can write your own custom workflows, register it
and then call them from here, but I am pretty confused with the existing
workflows can call other workflows
workflows can also call a method in a .net assembly. ie you could write a
piece of code in c# or vb.net and then have the workflow call your code.
Microsoft CRM MVP
"SAM" <SAM@discussions.microsoft.com> wrote in message
news:DE...Excel and Sorting
In Excel I have my checking information I would like Excel to take my
information and sort it as to the catagory I have labled each transaction and
put them into groups with totals. This is done it Quicken is this possible to
do this in Excel?
You got a response to your first version of this question.
> In Excel I have my checking information I would like Excel to take my
> information and sort it as to the catagory I have labled each transaction and
> put them into groups with totals. This is done it Quicken is this possible to
> do this in Excel?...How do I create a calendar from data in excel?
I have two columns with dates in them and would like to display a calendar at
the bottom of the page. Is this possible?
Try a 3rd party application like WinCalendar...
With this you can insert a Calendar into any excel sheet. You can
also save daily appointments on a floating Calendar that later display
on the inserted calendar.
Refer to http://www.wincalendar.com/ for more info.
On Jul 31, 12:00 pm, kare7272 <kare7...@discussions.microsoft.com>
> I have two columns with dates in them and would like to display acalendarat
> the bottom of the page. Is this possible...Split Name Field in Excell
I have a single name field that has both the first and
last name of some clients. How can I separate each name
and create separate fields for each?
the easiest place to start is by using data / text to columns ...
insert a couple of spare columns to the right of the column you want to
select the column to split
choose data / text to columns
ensure delimited is selected - press next
untick tab, tick space
let us know how you go
"crystal" <firstname.lastname@example.org> wrote in message
news:5cf901c474b7$77d4abc0$a...Pasting HTML into excel
I have copy and pasted some HTML data (stock symbols) into excel but the
VLOOKUP function doesn't seem to recognize these symbols even though the
symbols appear to exist within the VLOOKUP search range. For example when
searching for say IBM it does not find it. If I manually clear IBM and type
IBM back into the same cell then VLOOKUP finds it.
My guess is that there are some trailing non-visible HTML characters that
VLOOKUP sees that are thwarting the match.
Any ideas how I can delete these non-visible characters?
I tried copy and paste special values, but it doesn't help.
Th...Exporting From US Excel and Importing in Euro Excel
I'm curious how this situation is handled.
You have a worksheet that has some columns that represent U.S. monetary
values that include decimals (e.g. 19.28). You export that to a .csv file
(comma delimited file). You then have someone in Europe who wants to import
this file, but they use commas as the separator in their monetary values.
Is there a way they can import this, but also convert the decimals in the
monetary values to commas?
Not sure if it would work Tim but could you use Find/Replace on the
range of "Values" changing "." to ","
...Async calls to WebService in MFC
I use a webservice over the net which is scripted in VB.Net. This web
service receives a username and a password and returns a string
structure with multiples infos. If the string is empty, I had the wrong
username and/or password. Pretty simple isn't?
Ok now the problem is a bit more complex. I'm using an MFC client to
connect to these web services, and since they're on the internet,
there's a delay between sending the data and receiving an answer. I
don't know really how I can tell me client to "wait for the string".
The wrapper MFC created for the w...