|
All about numbers I have the following table: A B C D 3 1 0.5 0 2 2 0 0.5 3 2 0 0 0 1 0.5 0 1 0 0 0 2 1 0 1 1 2 0.5 0 4 1 0 1.5 The formula required is to: 1) check if any row in column C has 0 (zero) and see corresponding cell in column D also has 0 (zero). Table above shows row 3 and 5. 2) if matches, then check if (... 6 Jul 2008 23:12
Conditional Format - Identifying Highlighted Cells A brief explanation: I have 3 columns of data: X, Y, and Z. User inputs a high/low ranger (i.e. 4 +3/-2, i.e. 2 to 7). If the number is outside of that range, I have used conditional format to set the cell color to gray. Now here's where I have a problem. I'm attempting to add a fourth column, OK/NG column. I... 6 Jul 2008 23:12
Formula error - Excel 2007 Hi , I have used Excel for many years, but, for some reason, I am having a problem with what I thought was a simple formula. I am trying to work out a depreciation figure, and the net written down value. B35 Puchased 14/05/2008 B36 Private Use 50% B37 Cost $899 B38 Days owned: 47/365 B39 Depreciation Rate 3... 6 Jul 2008 21:10
Does anyone have a template for printing L7160 address labels? Hi Mackydees I've just seen your post; are the labels (L7160) an Avery product? the reason I ask is that you can download, for free, blank templates for all their products. If you go to http://www.avery.com/us/Main?action=software.BlankTPLHierarchy&catalogcode=WEB01&node=0 you might be able to find the temp... 6 Jul 2008 20:09
Time Formula Hi, I wonder if anyone can help with a formula for comparing two times and then returning a total, in hh:mm based on the result. I have tried to find a formula on the forum pages that I could adapt but I do not understand logic formula well enough to do that so I apologise if this has been explained already b... 6 Jul 2008 21:10
Pasting Spreadsheet into Word I would like to paste a spreadsheet into a Word doc for a report. I tried doing it with copy/paste, but the lines show. Is it possible? Thank you. -- Marianne ... 6 Jul 2008 22:11
Cell automatically copying to multiple sheets. Excel 2007: I have a spreadsheet with multiple sheets(20), each with similar account information for 20 individuals. When I start to enter data into one of the sheets, it is now duplicating this data in the other sheets as well. As far as I can tell, there is not a macro present, but I am new to 2007, so I am n... 6 Jul 2008 22:11
Moving Columns I have freeze pane the top 10 lines. How can I change the width of the column below the top 10 lines -- egrave ... 6 Jul 2008 19:07
check for value between 101 & 110 same value can't be repeated Bob & joeu2004 -- thanks for your responses. Both worked - great stuff. Thanks again John "Bob Phillips" wrote: First, ensure cell A1 is empty and goto Tools>Options and on the Calculation tab check the Iteration checkbox to stop the Circular Reference message. Next, type this formula into... 6 Jul 2008 22:11
Applying multiple distinct conditional formatting rules I have a table full of data (well, the results of formulae), where each row has nice points of comparison (either Y or N; or strongly disagree, disagree, neutral, agree or strongly agree). What I had hoped to do was use Conditional Formatting to highlight those values - within each row - that for each of the n... 6 Jul 2008 19:07
HOW DO I CREATE LABELS OR ADDRESSES ON ENVELOPES that was not the question. the question was in the subject above -- Val "ANYOAKTREE" wrote: the extra advice was noted so the cap locks are off and i break the rules. we use caps in both offices i work in so we are able to read third generation faxes and people over 50 appreciate reading larg... 6 Jul 2008 16:03
Converting a range of Excel 2003 Cells to a Single text string Hello, Would there be some way to use functions to convert a range of cells to a text string without writing a macro for it. I have tried the CONCATENATION function. But I would have type in each cell address in it sepetated by commas. I cannot select a range for this function. Thank you ... 6 Jul 2008 20:09
how to display error message? Hi all, I am using VC++ to develop some XLL file for use in Excel 2003. Of course there are bugs. The cell display "#NUM!". But in VC++ I've already thrown exception with error message: if (a!=b) throw Constructor ("a must be equal b.", "myclass")... Why couldn't I see the error message in Excel? ... 6 Jul 2008 16:03
newsgroups Anyone else having trouble with the private newsgroups? -- Biff Microsoft Excel MVP ... 6 Jul 2008 17:04 |