| Thread | Last Post | Replies |
|
| Sorting by time (o'clock) | 03 Apr 2008 12:34 GMT | 1 |
I have a list of which an example is below, that I need to sort by the date then the time. This information is in 1 (each) cell. 3-26-Wed - 6:00 PM - Company - Alhambra Dinner Theater - Jax - 641-1212
|
| conditional formatting rows depending on a column | 03 Apr 2008 08:22 GMT | 2 |
how to conditional format a n*m box depending a column value for example I have 4*3 box and I want to highlight the row depenidng the third column value. a,f,3
|
| Data Validation with named ranges | 03 Apr 2008 06:29 GMT | 2 |
I have a wierd problem: in a planning module it should be possible to choose the correct product in a validated list. There is a matrix that shows only those articles that can be planned on a specific machines.
|
| help with formulas | 02 Apr 2008 23:41 GMT | 2 |
example of what i want to do: take a number from F1 and add it to D2 and then have the sum placed in F2. i want to set it up to continue to do this for every new number entered in column D it will then place the new total in column F. Help!!!!!
|
| E-Mail Excel Worksheets | 02 Apr 2008 23:32 GMT | 1 |
Is there a way to e-mail just one sheet in a workbook that contains multiple sheets? Thanks, Debra Lassman
|
| any way to erase all "objects" within a selected cell range | 02 Apr 2008 21:31 GMT | 1 |
I pasted in a table from a web page. Wanted to to work with the numbers in the web table, in Excel. Fine! But, it turns out there were also a bunch of little objects in the web page. Totally small, a few pixels i think. You don't even see them on the sheet, but i noticed them ...
|
| xlDynamic.com | 02 Apr 2008 21:07 GMT | 4 |
This site has been experiencing problems for a few days, but (fingers-crossed), it seems to be back up and running now.
|
| Graphing Question | 02 Apr 2008 20:59 GMT | 1 |
I am trying to graph a set of data in 'XY (Scatter)' and am running into a problem I've never seen before. There are only seven values for 'X' - numbers 0 through 6. 'Y' is a set of percentages ranging from '0.00%' to '13.00%'
|
| Excel Row as Header | 02 Apr 2008 20:42 GMT | 2 |
I am making a table and the top row has all the headings for each column. I want this row of headings to appear on each page, since the table extends to 3 pages and users will be adding rows frequently. Is this possible, and if so, how?
|
| Schedule a macro | 02 Apr 2008 18:34 GMT | 1 |
I would like to schedule a macro to run at 22 minutes and 52 minutes past the hour, so that the latest information available to the spreadsheet is updated asap (usually available by 21 mins and 51 mins past the hour) to remove the problem of the user forgetting to do so manually.
|
| Determining length of trend before significant retrace | 02 Apr 2008 18:18 GMT | 1 |
In range of data I need to find jthe largest numerical movement in one direction without (x) retrace. (x in this case being a specified whole number) Please help with a formula or direct me to where I could find this
|
| IF, AND, VLOOKUP jumble | 02 Apr 2008 17:48 GMT | 2 |
Just when I think I'm getting used to Excel, I come up against something that reminds me how much I don't know. I hope one of you good guys can help me out. Essentially I have two worksheet listing competitors in an annual race. One
|
| Visual Basic Code | 02 Apr 2008 17:32 GMT | 2 |
I am trying to write some visual basic code behind a macro and I want it to do the following. 1) Select the whole of coloum C 2) Activate the find box as in (CTRL + F)
|
| Sheet Tabs | 02 Apr 2008 17:28 GMT | 2 |
Can anyone tell me if you can alphabetize sheet tabs within a workbook?
|
| multi criteria filter | 02 Apr 2008 17:23 GMT | 1 |
If i want to filter a single column to only show A G, J, and P ( i choose these letters as they cant be lumped together as a range) how would i do that in a maro or VB Any tips appreciated
|