| Thread | Last Post | Replies |
|
| Excel Question | 12 Feb 2008 21:20 GMT | 4 |
Here is my problem. Say I have a list of 20 baseball player names in one column and how many home runs that they have in the next column. How can I make a cell = all the players names that have over 20 home runs?
|
| Conditional format question.. | 12 Feb 2008 21:02 GMT | 2 |
Can't seem to figure this out... Three columns of data. If the value in column 1 is a text string that is "N/A" I want to format cells, for that row, in column 2 & 3 (which will be empty of text) with a
|
| reference work sheet name by using a formula | 12 Feb 2008 20:45 GMT | 3 |
I have multiple sheets. Instead of using the harcode sheet name and the reference cell in that sheet, is there a way to refer to the worksheet name using a label. I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1
|
| creating 2 columns | 12 Feb 2008 20:31 GMT | 3 |
Just need to know how I can eliminate pages by creating columns with my list of addresses. For some reason this new program baffles me sometimes on the simplest tasks.
|
| circular reference question | 12 Feb 2008 20:30 GMT | 2 |
I am trying to calculate answers that use the answers from other calculations. Is there a way to do that without getting errors?
|
| Problem with date display | 12 Feb 2008 20:18 GMT | 1 |
Despite changing the formatting of the cells, typing in a date displays the serial date, i.e. 35608 etc. Other worksheets open and function ok. Can't see in the options where something may have changed on the problem
|
| protection is not work. | 12 Feb 2008 20:11 GMT | 5 |
I created an excel file and set two colmumn on one worksheet to hide ,and then set protection on the worksheet. those two colmumns are refered by other worksheet. My problem is that user can unhied the protected colmumns. Protection is not
|
| Conditional Vertical Lookup | 12 Feb 2008 19:43 GMT | 2 |
I am trying to write a functional statement that picks up a certain value on a different worksheet. If the first 4 letters of this column in this sheet equals this, insert H- in this cell.
|
| ExportAsFixedFormat for Multiple Sheets in a Single Excel File | 12 Feb 2008 19:42 GMT | 2 |
It seems I can only save to PDF one sheet at a time, is it possible to print multiple sheets in a single PDF document i.e. multiple page PDF? Thanks.
|
| Multiple values from the same list of numbers | 12 Feb 2008 19:13 GMT | 3 |
I have a (long) list of spectral data. It consists of 1 column of time increments, and 1 column of intensity values. I am trying to find the maximum for each of three peaks in the data, plus, once the maximum has been found, the values closest to halfway between the baseline and ...
|
| I WANT TO CREATE A FORMULA USING DATES | 12 Feb 2008 19:02 GMT | 8 |
I have dates in 3 seperate colums for 3 seperate tasks on Sheet 1. On Sheet 2 with in the same file i have a colomn that has either nothing or an X in it when a specific task is complete. the three date colomn's are:U5, V5, W5.
|
| Normalfordeling | 12 Feb 2008 18:21 GMT | 3 |
Pleas, I have to draw a normal fordeling kurve, I have x and y data, and I draw histogram, but I would like to draw en kurve "normal fordeling" Thank you very much
|
| Given today's date, I want this week's Monday's date | 12 Feb 2008 18:16 GMT | 3 |
I cannot find a good way to extract this week's monday's date. I want the sheet to read Today() and return the date of the monday of this week. I would prefer to NOT do this in VBA but that is an option. I consider myself a pretty advanced Excel/VBA user so please unload.
|
| IF formula help part two | 12 Feb 2008 18:01 GMT | 2 |
I am trying to do a similar thing but my values are different.
>>> The idea is that if J16 equals 0, then G11 will show 0 >>> If J16 is greater than 0 and less than 1, then G11 will show 0 >>> If J16 is equal to 1 but less than 2, then G11 will show 1.5 |
| Formula Nightmare | 12 Feb 2008 17:54 GMT | 6 |
I need to compare a range with a number and then have a certain result based on the range. Can anyone help?
|