Top 10 users formula
How I can count top 10 or 20 users in worksheet contains 700 to 100
records? if am having 300 users are entered in the worksheet
I can do it by counting with count formula and sort the records in th
ascending order however this a bit long way and boring too I need t
get top users by just one calculation and without sorting
Message posted from http://www.ExcelForum.com
If I understopod your question correctly you want to count the number
of rows per user and create a top 10 list (that is the user with most
rows at the top)
one way: use a pivot table on your data. for some instructions...Office 2003 02-13-10
i was trying to download office 2003 pro from my technet subscription, but it
has it as unavailable, why is this and will it be available in the future
In article <8CF1DFFF-6C95-4124-9CDA-5D4D5EF8AB01@microsoft.com>, Raptor12 wrote:
> i was trying to download office 2003 pro from my technet subscription, but it
> has it as unavailable, why is this and will it be available in the future
That would be a question for TechNet's support folks.
...Help with Formula Please 01-25-10
I need to count up everytime a Y appears in a cell in column I ('Data
Sheet'!I:I) but only when a cell contains a 3 in column F. This is one of the
many variations I have tried. The trouble is, it counts ALL the Y's in column
I instead of only those where a 3 is contained in a cell in column F.
=IF(AND('Data Sheet'!F4=3,'Data Sheet'!I3="Porosity"), COUNTIF('Data
I would really appreciate some help for a newbie if possible.
Countif supports only one "if". If you have Excel 2007, you can us...Hyperlink to drop down options
I am working in Excel 2007 & OS is Windows Vista.
I want to have a cell displaying text 'Bank Accounts'. When a user
click or moves the cursor on this cell, there should a drop-down list
of all bank accounts. Each of these drop down should be hyperlinked to
a specific cell of a different worksheet. When the user clicks on any
of the bank account (from the drop down list), he should be taken to
the hyperlinked cell of the different worksheet.
All bank account details are on a single worksheet but in different
area of the worksheet.
Let me know if this is possible.
...Custom Format to divide by 10
I was wondering if you can create a custom format to divide by 10. As you
know you can create a custom format for 1000 i.e. 0, and 1m i.e. 0,,. I was
looking to do a similar style for this group of cells and I don't really want
to use the Paste Special and Divide or linking to another cell to divide.
Can't think of way of formatting this - hopefully some other bright spark
You could use a macro:
Dim cel As Range
For Each cel In Selection
If cel.HasFormula = False Then
cel.Value = cel.Value / 10
...Spinning beach ball of death in word 2004 and OS X 10.4.2
It happens quite often, that Word 2004 (SP2) on OS X Tiger locks
up for several minutes and sometimes longer. I can't say why and
when it happens because almost everything can provoke it.
Just changing to another font or sending a document to print can
result in a spinning beach ball of death. It's really annoying.
I have deleted com.microsoft.Word.plist inside ~Library\Preferences
but unfortunately it didn't solve the problem, so what can I do?
There is a known bug in MacOS that deals with fonts that can cause this
to happen. Apple and Mi...Trendline Issues
Microsoft Office 2000
I have two graphs on one chart and both axis are used. The left axis is
based on whole numbers. The right axis is based on percentages. I have
no problem adding a trendline to the line graph using the left axis. I
cannot add a trendline to the line graph using the right axis
(percentages). When I right click the line graph and select "Add
trendline" nothing shows up. However, the "undo" feature says "Undo add
trendline". Could Excel be trying to use the left axis as reference for
Also, for additional informat...New Message Options
I have created a message that I do not want to be sent
until a certain date. I went to "Options" and I check do
not send before and added a future date. However, the
date has come and gone and the person did not get the e-
mail. It is still in my outbox. How come? Is there
something else that I should have done?
...Public Folders #15
Is it possible to assign tasks from a public folder in
I do not believe you can.
On Tue, 18 May 2004 10:36:14 -0700, "NIC"
>Is it possible to assign tasks from a public folder in
...dymanics GP 10 exam MB3-528 & MB3-527
i planing to achieve Dynamic GP 10 Exam
and i don't useing it before but i have e-learing coures for it
bec iam microsoft trainer so this coures it is useful to pass in exam
and collect skills form it
anyone can guide me
my email: firstname.lastname@example.org
Yes Haitham, the e-learning courses will assist you in exam
On Jun 26, 6:55=A0pm, haitham sayed <haitham sayed
> i planing to achieve Dynamic GP 10 Exam
> and i don't useing it before but i have e-learing coures for it
>...Access Denied Issue
I have a single server 2003 R2 that has SQL 2005 and MOSS 2007 installed. I then install Project Server 2007 and when I go to the admin panel to start the servername/pwa service. I get system resoruces failure and following logs are seen in the event viewer
The Execute method of job definition Microsoft.Office.Server.Search.Administration.IndexingScheduleJobDefinition (ID daee21de-4fe4-4515-81df-977b2f73178d) threw an exception. More information is included below.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
For more information, see Help and Support Center ...NEW RECORD ISSUES
I have a New record button in my main form. In the click event i have
DoCmd.GoToRecord , , acNewRec command to add a new record. this seems fairly
When i click on it I can create a new record. The problem arises when i
select other records using a combo box the value is retained for that
selection and when i click the new button again the record is focused on the
most current record selected with other feilds blanked out.
How can i code to clear all values including ensuring the combo box field
accepts the new record value.
thanks in advance
...ex bpa ssl result
just ran best practices analisys and got this result -->
regarding the ssl certificate, it has expired on 12 15 2004
furthermore, there is a mismatch between names.
cimbo.com doesn't matches snake desert, snake town, snake oil ...
what exactly am i dealing with ?? we are not using ssmpt. is this related to
thanks for any help
Pedro Leite from Portugal
...Excel macro 06-03-10
Hi, i need a macro to copy from one cell the text below and to paste only the
contenet of the parenthesis.
Invoice currency (USD):
I need to paste only USD. The currency can contain "USD, EUR' CHF,...etc"
Can this be done?
One way...to return the text
Dim strData As String
strData = "Invoice currency (USD):(ind)"
MsgBox Split(Split(strData, "(")(1), ")")(0)
Jacob (MVP - Excel)
> Hi, i need a macro to copy from one cell the text below and to paste only the
> contenet of th...Excel Problem #10
Can anybody answer this query please?
because I dont seem to know the answe
jiggy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3549
View this thread: http://www.excelforum.com/showthread.php?threadid=55749
On Fri, 30 Jun 2006 16:54:03 -0500, jiggy
>(http://www.generationtalk.com/talk/viewtopic.php?t=...Using Outlook 98, why are there no tracking options for email?
I didn't see any downloads and I can't seem to locate any way to initiate it
using the information for Office assistance: ie Tools, Options, E-mail
Options (after this I don't have tracking options), etc. HELP???
...set up email 09-01-10
my msn email stoped working..tried to re-set up..keeps saying POP3 cannot be
found...got to tools...accounts..etc..won't let me set up.any thoughts..mike
Make sure your settings agree with this:
Use port 587 rather than port 25 for the SMTP server.
Gary VanderMolen, Microsoft MVP (Mail)
"mik" wrote in message =
my msn email stoped working..tried to re-set up..keeps saying POP3 =
...Boot from IDE 2nd master + slave (optional) ?
on our x86 CEPC, there's two CF card slots as secondary IDE master + slave.
The default boot-device is secondary master.
The place to store the hive registry is set to secondary master too (with
congatec- BSP variable BSP_ENABLE_FSREGHIVE_DEVICE=2).
With a change in boot order in bios, it is possible to boot from the other
cf card slot (secondary slave).
Where is the registry stored then, still on secondary master?
Thanks in advance.
As long as your secondary slave CF card is bootable, change the BIOS boot
order is doable.
But the boot odder in BIOS is nothi...Can I switch off "Grammar" options in Word 2007 yet keep Spelling
I miss the simple Tools/Options facility in Word 2007 using Vista Ultimate,
is it "hidden" somewhere?
You will find a similar set of options if you click the pizza (office)
button top left of your Word 2007 screen and select Word Options.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>><...Cross Domian connectivity issues
The WAN I work with will not allow outlook 2000 to access
a user's profile located in another domain, however all
other privledges function (save internet explorer). Also
outlook functions normally when logged in under the
primary domain, this eliminates a permissions error. I
believe the problem is related to either the firewall, or
global security permissions. If anyone has experience
with this kind of thing I would greatly appreciate the
...How to convert WMV to MP4 MPEG4 with WMV to MP4 Converter 06-03-10
Do you have some WMV files and encountered following problems or similar kind, now are seeking an effective way to convert WMV to MP4 files?
1. I just downloaded some WMV files; I need a video converter software to change WMV to MP4 to get them work on my iTunes/iPod/iPhone/iPad.
2. I have a bunch of videos (that are .WMV) that are HD. I want to convert them to .mp4 while keeping the same quality in HD
3. I need help to convert my wmv file into a mp4 file which i can play it on my PSP MP4 Player.
4. And more reason to convert WMV to MP4...
So, how to [url=http://www.daniusoft.co...PivotTable Calculated Field issue
I'm new to working with calculated items in PivotTables, and I've run
into a bit of a snag.
My PivotTable is built off of a data set with a start and stop time (in
military time) for a number of workers. Included in the data set as
well is a worktype. I have a calculated field in my Pivot which returns
the # of hours worked by way of the following formula:
I have this data displayed by work type and date on the top, and by 1/2
hour interval of the start time on the left (the data set as well is
restricted to half hour intervals). This part works great!
...exchange 2003 -> 2007 mailbox move issue
I have a mixed 2003, 2007 environment where all mailboxes used to live
on the Exchange 2003 box, but in the past week I have been moving
mailboxes over to a 2007 box. Most of the moves were successful,
however 20 � 30 failed (could not move user contacts), I increased the
number of allowed errors during the transfer and was able to move
everyone across. The problem I am facing right now is with the users
who had errors during migration. What happened was their mailboxes
moved 2007, but mailboxes on 2003 did not get deleted because they have
a few problematic items left. Looking at t...Customize form 11-10-04
I would like to know if its possible to add a new form that use fields of
If not, its possible customize a form with fields of diferent tables?
Thanks and regards...
Not a feature that is available in the current version - unless you develop
your own ASPx page to replace the shipped one.
This is a planned feature for V2.
"David Cabrero" <email@example.com> wrote in message
> I would like to know if its possible to add a new form that use fields of
> distinct tables.
> If not, it...Issues with GP10 system freezing.
We are running Great Plains 10 on Citrix.
We have these issues sporatically.
1. We are having issues with large reports being extracted from GP 10 to
Excel, and Excel to GP10. Sometimes, the process just hangs, and does not
2. Issue when cancelling/stopping distribution checks, First step is the
to cancel, second series post, third delete batches which all worked fine.
When I began working in the void check segment the system let me create two
voids, and on the third entry I received a hour glass so to me the system
Anyone have any ideas?