|
|
|
|
1 |
267 |
|
|
Cursor highlights the wrong rows in excel? by
Splashdown
I find that I have to select 3 rows above the row I want to highlight in
excel. This carries forward when selecting multiple rows. My mouse is always
about 3...
|
|
0 |
156 |
|
|
|
March 30th, 2010 03:11 PM
by Carine
|
0 |
136 |
|
|
Data collection Sum/Total by
Eduardo
Hi,
not sure what you need and example will help however if you have a column
with the 365 days and want to summarize each date with the information
entered...
|
March 30th, 2010 03:11 PM
by Eduardo
|
0 |
143 |
|
|
Data collection Sum/Total (correction 2) by
Michael_R
the SUMIF formula should read
=SUMIF($A$2:$A$366,D2,$B$2:$B$366)
"Michael_R" wrote:
Here's how I understand your setup:
Column A has 365 dates (01.Jan...
|
|
0 |
123 |
|
|
Data collection Sum/Total by
trip_to_tokyo[_3_]
EXCEL 2007
I have just put up a file for you at:-
http://www.pierrefondes.com/
- item number 82 (towards the top pf my home page at the time of writing)....
|
|
0 |
152 |
|
|
Doubt about pivot table by
diogobacon
Good afternoon,
I doubt the following staff:
I know that you can create a Pivot Table apart from others in the same
workbook (they share the cache).
But I...
|
|
2 |
165 |
|
|
countif 2 criteria by
BNT1 via OfficeKB.com
Hi
Struggling to get this to work, despite looking at the treads. Using excel
2003.
trying to count how many times 5710 in col G has "6" in Col H
col-G ...
|
|
9 |
251 |
|
|
Grouping dates on a Chart by
Duncs
I have a workbook with 12 sheets in it, one for each month of the
year. Each sheet has the day of the week in column B, several other
values in columns C -- J...
|
March 30th, 2010 09:15 AM
by Duncs
|
2 |
154 |
|
|
Problem using SaveAs method by
Sujata
Hi,
I'm running a perl script which uses Win 32 OLE package for Excel
operations. The script does some processing and populates a spreadsheet,
after which...
|
March 30th, 2010 07:21 AM
by Sujata
|
4 |
181 |
|
|
|
|
0 |
155 |
|
|
|
March 30th, 2010 12:20 AM
by JLatham
|
3 |
170 |
|
|
The Incredible Shrinking Chart by
LarryP
BACKGROUND: We are in the unfortunate situation of having some employees
still on Excel 2003/some upgraded to 2007. This will continue for at least
another...
|
|
1 |
170 |
|
|
Formatting a number as a date by
Loris
When applying the keyboard shortcut CTRL+SHIFT+# to a number, Excel formats
that number in the 29-Mar-10 format by default. How do I change that default...
|
|
2 |
193 |
|
|
Pivot table grand total location by
Rosemary
Is there a way to show the grand total column in a pivot table next to the
selected fields? Right now, my pivot table shows the grand total in the
right...
|
|
1 |
263 |
|
|
Formula Help by
sross002
I need a formula that will translate a percentage change into a word.
For instance;
if the percentage of cell a1 is negative 5% or greater I want cell b1 to...
|
|
4 |
153 |
|
|
Formula to select a # from a table by
casinel1
I have two drop downs in my spreadsheet one for the product line(IP, DP, Etc)
and one for the the period (001/2010, 002/2010, Total Year, Etc. Below is the...
|
|
3 |
101 |
|
|
|
|
2 |
208 |
|
|
Use icon sets relatively in a pivot table by
Darlene[_5_]
Hi All!
I can use icon sets for certain things, but am unable to figure out
how to use them with my existing data.
I have a pivot table that may list sales...
|
|
1 |
163 |
|
|
Template Help Task Pane is being a pain! by
Barry
I've got a Worksheet template and it's been saved.
Now every time I pull it up to work with it the Template Help Task Pane
opens up too!
I've looked around...
|
|
3 |
188 |