| Thread | Last Post | Replies |
|
| In Exel how can I select and sum the top two values in a column? | 20 May 2007 17:45 GMT | 2 |
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 GMT | 2 |
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 size | 20 May 2007 17:32 GMT | 4 |
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 help | 20 May 2007 16:27 GMT | 13 |
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 Formatting | 20 May 2007 16:00 GMT | 2 |
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 column | 20 May 2007 15:40 GMT | 4 |
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 formula | 20 May 2007 15:22 GMT | 1 |
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 form | 20 May 2007 14:22 GMT | 4 |
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 relative | 20 May 2007 13:57 GMT | 1 |
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 2003 | 20 May 2007 13:15 GMT | 4 |
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 Groups | 20 May 2007 12:33 GMT | 2 |
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 rows | 20 May 2007 12:23 GMT | 1 |
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 GMT | 4 |
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 2007 | 20 May 2007 10:47 GMT | 10 |
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 GMT | 4 |
or IRR. Any help would be appreciated.
|