| Thread | Last Post | Replies |
|
| find a sum number from 300 numbers in Excel | 21 Sep 2006 15:39 GMT | 3 |
I have 300 numbers and 1 number. I want to know whether that 1 number is the sum of the combination of those 300 numbers and which several numbers in these 300 numbers sum up to produce that 1 number. Some of these 300 numbers are same. Can I use Excel to work out that question?
|
| Can one set up a survey form on excel? | 21 Sep 2006 14:15 GMT | 2 |
Can one set up a survey form (questionnaire) on Excel? Janev
|
| basics? | 21 Sep 2006 12:37 GMT | 7 |
I am looking to multply one column by another in each row for a long set of data. Example: A B C
|
| Shared Workbook & permissions | 21 Sep 2006 12:32 GMT | 1 |
I have a shared workbook on a shared drive in the network in which two departments use.One department only needs to view transactions while the other requires to enter transactions. Is it possable to set up the the workbook in this manner tohave better control or is this better ...
|
| arrange sheets in alphatical order | 21 Sep 2006 12:28 GMT | 1 |
arrange sheets in alphatical order
|
| 1 excel file but 2 windows open | 21 Sep 2006 10:45 GMT | 1 |
I receive a excel file from my workmate when I open this file, the excel windows open and display the same content, but the file name shown are different, e.g 1 windows show abc:1, another windows show abc:2
|
| Where can I get some clear instructions about setting up forms on Excel | 21 Sep 2006 08:57 GMT | 2 |
Where can I get some clear instructions about setting up forms on excel? thanks, Janev
|
| Frequency ( ) | 21 Sep 2006 08:42 GMT | 2 |
I have been reading Excel Help and trying to learn how to use IF, SUM, FREQUENCY, MATCH, and LEN functions to count the number of unique values. I also read a thread (from years ago) which explained FREQUENCY( ) quite well. (Yes, *years ago* but it is still good info.) I have a ...
|
| Formula to find last used cell | 21 Sep 2006 06:35 GMT | 3 |
I want to populate a cell in sheet1 by going to sheet 2 column F and finding the value of the last filled cell that is not a zero
|
| sliding calculation | 21 Sep 2006 00:05 GMT | 3 |
I am trying to keep a log of Flight time and would always like to know what I've flown within the last 90 days of the current date in several different modes of flight. A B C D
|
| Reverse text | 20 Sep 2006 23:32 GMT | 5 |
I need a formula (or other method) to reverse the text in a cell? Eg "Paper clip" would become "pilc repaP". Any suggestions? Tod
|
| Chart plots #VALUE as 0, can this behavior be avoided? | 20 Sep 2006 21:57 GMT | 2 |
I have an X-Y scatterplot. In some of the cells in the range for Y values, the result is #VALUE. However, the chart plots this as if it were "0". This seems dangerously wrong to me, seems like it should be plotted as if that cell were blank. It is very misleading in the chart ...
|
| Sorting rows by colors (categories) | 20 Sep 2006 21:43 GMT | 1 |
I have rows with data in different categories, identified by three colors. (red, green and blue). How can I sort the rows by colors? Thanks,
|
| clustered stacked bar chart - format question | 20 Sep 2006 19:06 GMT | 2 |
Ok, I've googled the instructions for the side-by-side stacked bar chart. I've gone through it, and so far the only thing I haven't figured out is how to space the cluster of bars apart from eachother. So I have a cluster of stacks for 1 group, and a cluster for another.
|
| DeltaE formula | 20 Sep 2006 18:29 GMT | 5 |
can someone show me how to enter this formula in excel. =[(+11.1)^2+(-6.1)^2+(-5.25)^2]1/2 The answer is 13.71 it has to do with color L*a*b*
|