Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
In Exel how can I select and sum the top two values in a column?20 May 2007 17:45 GMT2
I am trying to develop a simple Stableford scoring worksheet for a men's golf
league. I need to select the top two scores for each round to track the team
scores.
vlookup (a drop list)20 May 2007 17:36 GMT2
I'm not the most computer friendly person so I’ll my best try to decade what
I want to do: Fist my reference has three columns:    
Column A       Column B       Column C
Item Name     Cost               Level
uisng two paramaters for conditional formatting / Limiting screen size20 May 2007 17:32 GMT4
I have a couple of small questions :
1. The first one is to do with using more than one condition in
conditional formatting without having once countermand the other.
I'm using =MOD(ROW(),2)=0 to colour alternate rows down my worksheet.
Formula help20 May 2007 16:27 GMT13
Hello,
I am looking for a way to capture info from one column while referring it to
another.  For example, the info I'm analyzing pertains to cities and the
provinces in which they're located.  I'd like to find a way in which I can
Trouble Finding Duplicate Values with Conditional Formatting20 May 2007 16:00 GMT2
I'm using Excel 2007 and need to locate duplicate values in a column.  I'm
using Conditional Formatting > Highlight Cells Rules > Duplicate Values.  
This is picking up SOME of the dupes, but not others.  So far as I can tell
the cells that are duplicated are identical to one ...
Protecting a single column20 May 2007 15:40 GMT4
Is it possible, within an Excel spreadsheet that is not otherwise protected,
to hide and password-protect a single column of data?  I want to have a
spreadsheet with data that is shared with co-workers, but within that
spreadsheet I want to have a column (or several columns) of ...
obtaining formulas and help w formula20 May 2007 15:22 GMT1
I would like to make a monthly total derived from a sum column on 4 different
worksheets.........does anyone know the formula?
Also, does anyone know where I can get a list of formula's available for use
in Excel?
List box or form20 May 2007 14:22 GMT4
I have an excel file which contains about 30 sheets - I always have trouble
scrolling through them to find my data, is there a way of adding a list
box/form that would always be on top allowing me to have links to the pages?
Boucle sur ligne relative20 May 2007 13:57 GMT1
Boucle sur ligne relative
Bonjour
A la macro macro_C(), j'appelle la macro C_N toutes les 28 lignes.
Selectionne la colonne 17 de chaque ligne pour y mette le résultat de C_N
Saving .csv files in Excel 200320 May 2007 13:15 GMT4
I am downloading survey data from Qualtrics.com in .csv format into Excel
2003. The data appears to arrive perfectly, each item in its own column, but
once I save-and-close, then reopen the file, all the data is scrunched up at
the left-hand side of the page instead of ...
Ranking System For Large Groups20 May 2007 12:33 GMT2
If I have a class of students, say A-F and they have different grades in
different subjects. Everytime they take a new test I give them a new grade
and I keep an average of all the grades for each student. In a ranking table
I use a macro to sort the grade of the students in ...
Loop relative rows20 May 2007 12:23 GMT1
With  the macro macro_C(), I call the macro C_N all the 28 rows.
Select column 17 of each row for puts the result of C_N at it
How to make so that C_N holds account of the values of column 1 with
that of the last nonempty cell of the line in progress of lig
Calculated Textbox not showing proper results.20 May 2007 11:14 GMT4
On a userform I have three textboxes. Two that people use to enter amounts
and a third that automatically displays the sum of the two amounts.
amount1.text
amount2.text
Importing Text files to Excel 200720 May 2007 10:47 GMT10
I'm being asked to test 5% of the files in a hard drive given to us.
There are 1620 files, so I need to test 81 randomnly choosen files.
I open the hard drive using Windows Explorer and sort them by Name.
I need to know if we can create a text file of the contents of the hard
How can I use excel to calculate average annual ROI...20 May 2007 05:58 GMT4
or IRR.  Any help would be appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.