|
|
|
May 7th, 2010 08:02 AM
by yakir
|
0 |
175 |
|
|
|
|
1 |
231 |
|
|
what is ^ in a formula for by
DP[_3_]
full formula below where CJ 5 is a %age. Could do with knowing what symbol is?
=($CJ$5+1)^(1/6)*CI7
--
DP
|
May 7th, 2010 07:35 AM
by FSt1
|
2 |
162 |
|
|
Comment in every 11th row by
Radhakant Panigrahi
Hi,
can anybody help me...i have 3 columns and i need a comment "Audit" ini
column D in every 11th row.Is it possible to have any formula or VBA for...
|
|
2 |
199 |
|
|
select all non-blank cells by
johncaleb
I need a macro to select and copy all non-blank cells in Sheet1, then paste
these cells into sheet2 at Cell A1.
thanks much!
|
|
3 |
218 |
|
|
Combination of text in 2 columns by
eintpc5146
Have a list of names--
first cell contains FirstName, MI; second cell contains LastName;
Need to combine data into 3rd cell;
output of 3rd cell: ...
|
|
4 |
184 |
|
|
Text Color Changes By Itself by
Youngergirl44
I have been working on a workbook where I'm entering (by hand) a couple
hundred rows of data in three columns. When I reach a line of data that I do
not need...
|
|
3 |
217 |
|
|
Cursor location jumps automatically by
Vote America!
What makes the cursor automatically jump from one cell to another in Excel
when trying to change/enter either new/different alphabetical or numerical
data? ...
|
|
0 |
191 |
|
|
|
|
2 |
229 |
|
|
|
|
4 |
189 |
|
|
Linking sumif formula to the data by
Jarod
Is there a way to link a sumif formula to the data on a different worksheet
that makes up the sum of the formula. If I click on the cell that contains
the...
|
|
1 |
193 |
|
|
calculating percentages by
lindamac
I am new at excel. I have inputs done by group 1 of 5410. Inputs done by
group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the...
|
|
2 |
194 |
|
|
Change authentication in 2007? by
GD
How would one change a file from administrator (currently the default) to
Windows authentication? Ideally, I would like to make Windows the default...
|
|
1 |
210 |
|
|
adjust cell height by
johncaleb
Is there a formula to adjust cell heights in a cell so there's a certain
amount of pixels above and below the letters/numbers? This is so the numbers
aren't...
|
|
2 |
216 |
|
|
|
|
2 |
263 |
|
|
Uppercase by
Prashant
Hi All,
Need your help!!!
I need a setting/formula/Coding in such a way that whatever text I type in
sheet 1 it should automatically to be returned in Upper...
|
|
6 |
276 |
|
|
Opening Excel 2007 file with 2003? by
Al
What happens if a user with Excel 2003 opens an Excel 2007 file that has more
than the max number of columns as permitted by 2003? (up to column IV)
Do they...
|
|
2 |
313 |
|
|
|
May 6th, 2010 11:18 PM
by dza7
|
2 |
236 |
|
|
|
|
3 |
185 |
|
|
Can't lock cells by
BruceM via OfficeKB.com
I have a spreadsheet in which I have locked certain cells, then I protected
the spreadsheet (Tools Protection Protect Worksheet). However, I can
still...
|
|
4 |
166 |