| Thread | Last Post | Replies |
|
| Can Excel create a conditional Comment on a cell? | 16 Feb 2007 17:05 GMT | 4 |
Can Excel create a conditional Comment on a cell? i.e. if cell value is above a value, create a comment ("Value is Very High = 'Cell Value' ")
|
| IF statement | 16 Feb 2007 15:31 GMT | 3 |
Hi I would like to know if it is possible to run an IF statement and if the condition is FALSE. It will leave the value that was previously in the cell? Thanks in advance
|
| Message pop up | 16 Feb 2007 15:22 GMT | 1 |
I have a list where they can select complete, partial or no. If they select partial or no I want them to fill in some narrative to explain why in the next cell - is there anyway of getting a message or something to show this when they select either of these options so it is ...
|
| RE cell wont update with new link | 16 Feb 2007 15:13 GMT | 1 |
Maybe this is simple but I have a link in a cell A1 on sheet2! which refers to sheet1! A1 When I goto manually change this link by typing the link in and press enter it wont take in the cell. the formula shows.
|
| Is it possible run code when a cell is doubleclicked? | 16 Feb 2007 14:26 GMT | 2 |
Is it possible run code when a cell is doubleclicked?
|
| Will excel generate one-tailed confidence intervals for Poisson distribution? | 16 Feb 2007 13:17 GMT | 17 |
OK, I understand why it makes more sense to use the normal distribution, on our hundreds of thousands of records, but my boss is not convinced - mabye because he knows the Poisson distribution is skewed to the left, and he said something about getting higher probabilities than ...
|
| Text question comes up even if cell is blank | 16 Feb 2007 13:02 GMT | 2 |
I have in G43 the following formula which counts all variations of the word bank, Bank,Banking,Banked,banked well it seems to work. it does count them. =COUNTIF(G$5:G$40,"*bank*")
|
| Chart format question | 16 Feb 2007 12:55 GMT | 1 |
I am gathering some research data and putting it into charts. My prof wants me to put some data above the bars on the graph. I think their called needles. They are small T looking extentions above the bars that have data attached to them, like standard deviations. Perhaps ...
|
| function used to get 30% of sale of $5000.00 | 16 Feb 2007 11:27 GMT | 2 |
I'm taking a class in excel 2003. One of the quiz questions is: B3 cost of sales equals 30% of sales. Create a formula in cell B7 to calculate the cost of sales for January. Use an absolute reference to cellB3 in the formula.
|
| create a macro to search an excel spread for duplicates | 16 Feb 2007 10:58 GMT | 4 |
I have a 55k line item spreadsheet and want to search thru it to find duplicate seriel #'s and once found populate a new spreadsheet with only the duplicates.
|
| calculate a part of a worksheet | 16 Feb 2007 10:22 GMT | 2 |
I have one calculation the creates a random number. I have another calculation that compares an input number to the random number. The problem is that when the spreadsheet is calculated the random number changes and is therefore always different from the input number. Is there a ...
|
| Help!!! End of Month Calculation | 16 Feb 2007 09:07 GMT | 4 |
I need some help. I am writing a formula to calculate my asset depreciation schedule. The rule is, the new purchased asset will be depreciated for the full in current month, no matter what date the asset purchased within the month, the depreciation will be calculated for full ...
|
| V lookup and H lookup together | 16 Feb 2007 08:57 GMT | 4 |
Is it possible to do a v lookup and an h lookup at the same time? For example I want to find the data that matches the row and column of the cell I'm in?
|
| I WANT TO COUNT HOW MANY TIMES A CERTAIN LETTER APPEARS IN A ROW | 16 Feb 2007 08:39 GMT | 13 |
I am trying to figure out sales from an existing spreadsheet. The spreadsheet containes packages (A-V) sold. Each cell may contain more than one of each letter so I can't just use the CountA function because that only counts the cell. I need something to actually count the ...
|
| day and time concatenate | 16 Feb 2007 06:19 GMT | 4 |
I have days stored in a column, and dates associated to them in other. Whe I try to concatenate them in a single cell, the numbers are converted and I get something like this: day time concatenate
|