First

Prev 
Next

Last
Pages: 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122
In Excel, changing a range of cells to all caps. I would like to know how to change a range of cells from mixed or lowercase to all uppercase in Excel. ... 1 Apr 2010 12:24
How do I create a travel expense report by employee, by campus I have the same problem.. but different data (of course) 1. Employee 2. Travels to multiple countries 3. Dates of travel 4. actual days on a particular country Goal: get actual days match travel expenses billed. thanks "Pete_UK" wrote: You need to explain more fully what data you have, how it is laid out... 1 Apr 2010 10:10
Think I need a MAX / MIN formula here (help needed) Hi Again I need a formula that does the following A1 = 41 B2 = 39 C2 = 6 =IF(B2<A1),C2 BUT DO NOT EXCEED A1 Therefore this should return 2 Any ideas Thank you ... 1 Apr 2010 11:16
Range of values Excel 2007 How do I make a range of cells values from 100 to 500 with increments of 5, i.e., 100+5...(100 105 110 115 120...500) ... 31 Mar 2010 22:11
Consecutive numbering Hope someone can help. How can I get one cell (B35) on each of 100 worksheets to number consecutively? TIA Esra (**)< ... 1 Apr 2010 06:49
Remove Last x Character(s) in Selected Cells This formula works great! But, can you explain/translate the formula? "Barb Reinhardt" wrote: Here's an equation to do it in helper column =left(A1,len(A1)2) Do you need it in a macro? "rojobrown" wrote: How do you remove the last two digits in a cell using a macro? ... 1 Apr 2010 02:32
Unique filtering to another sheet ? I having difficulty with unigue filtering. Probably because it's too close to tommorrow. I have a range of numbers in a column. There may be up to a hundred rows. I want to copy only the unique numbers to another column on another tab. Is that possible ? 599 478 478 478 478 982 982 785 894 Thanks, ... 1 Apr 2010 14:39
IF formula not working Can anyone tell me why this IF formula isn't working? =IF(D5<E5<F5,"A",IF(D5>E5>F5,"B", IF(D5<E5>F5,"C",IF(D5>E5<F5,"D","F")))) It's returning "B" every time. D5, E5, and F5 are all derived from formulas. Is that the problem? I appreciate any help! ... 31 Mar 2010 16:37
Looking a value up for a Hi guys, Here's a challenge I hope you can help me solve. Say I have a table of values with X and Y headers and a 3 x 3 array hoding parameters that are a function of X and Y, call these f (X, Y) as below. Y 0.1 0.2 0.3 1 10 15 20 X ... 31 Mar 2010 16:37 