|
|
|
February 4th, 2010 02:39 AM
by grrts
|
4 |
208 |
|
|
|
|
1 |
208 |
|
|
|
|
1 |
208 |
|
|
Returning every 7th row of a column by
bondjel
I have a row of 1836 consecutive dates in a column and I want a new column
with only every 7th row's date (the date beginning each week). How do I get
Excel...
|
|
8 |
208 |
|
|
|
|
2 |
208 |
|
|
To find the same price in another sheet by
pol[_2_]
I have a column with name 'Item' which contain the code of the product.
Another sheet ( same file) contain code and profit.
Sheet1
item
A1
200
300
400
500
|
|
2 |
208 |
|
|
#Name problem by
Senthil Ganesh
While retriving data from a plugin. Instead of calculated values #Name
appears in all cells.
Thanks for the help
|
|
1 |
208 |
|
|
Left Function by
AJ[_10_]
I am trying to pull certain characters based on a criteria for the third
position character.
In Column A, I could have a code such as BB11 or a Code such...
|
April 20th, 2010 06:01 PM
by Mike H
|
1 |
208 |
|
|
charts with percentages by
Mar
I have made a chart in word with percentages in a data label, when I change
my figures in my excel worksheet it changes the pie chart shape, but not the...
|
April 21st, 2010 01:33 PM
by Mar
|
0 |
208 |
|
|
|
February 22nd, 2010 08:30 PM
by JLatham
|
3 |
208 |
|
|
|
February 3rd, 2010 04:33 PM
by JP[_5_]
|
1 |
208 |
|
|
Conditional Formatting - Losing Values by
Dana
MS Excel 2007
I set up conditional formatting looking for certain values. The formatting
works as expected; when I save, close, then re-open the worksheet,...
|
|
7 |
208 |
|
|
Contextures Order Form by
MAC MAN
Hi,
I have been using your Order form for 1 year and it's great however I have
run into a little problem.
Up until July I was using the form on a PC but...
|
|
1 |
208 |
|
|
I'm getting the #DIV/0! error by
Reverand Mooney[_2_]
When I'm calculating for a % I entered the IF formula =IF(B10=0,"",B10/C10)
and it worked ok when B10 was 0 but how would you modify this formula if
either...
|
|
2 |
208 |
|
|
|
November 17th, 2009 02:25 PM
by MrsRose
|
0 |
208 |
|
|
EXCEL 2007 -INSERT WORK SHEET ICON by
Asoka Walpitagama - Brandix College IT
When the number of sheets increases, the INSERT WORK SHEET ICON is not
displayed.
Why not you keep it visible always.
----------------
This post is a...
|
November 18th, 2009 02:24 PM
by Bob I
|
1 |
208 |
|
|
AVERAGE WITH DUPLICATE NUMBERS by
bhutchinson
I need to average a list of data that has duplicate values. john smith
account number 1 has a value of 5. mary smith also on account # 1 has a
value of 5...
|
|
5 |
208 |
|
|
Preventing copy/paste on validated cells by
mbp
Hi
I've got a column of cells with validation.
If a user instead of typing values into the cells, copy/paste from another
cell, the origial validation...
|
|
2 |
208 |
|
|
|
January 15th, 2010 06:41 PM
by Luke M
|
1 |
208 |
|
|
Conditional formatting by
k11ngy
I have been asked if it is possible to identify cells that have conditional
formatting? is this possible?
Thanks
Steve
|
April 22nd, 2010 12:38 PM
by Mike H
|
1 |
208 |