|
|
subtotal function using criteria by
dbroc
I'm trying to use the subtotal function to total figures in a list based on a
technician's name. For example, use the subtotal function instead of the...
|
|
5 |
110 |
|
|
auto sum by
Pat
I added a row under the coloumn I want to add. I used the auto sum key, and
all it does is show the formula, not the actual totals. What am I doing
wrong?
|
|
2 |
146 |
|
|
hyperlinking email addresses by
CharlesZ
I have a list of email addresses that have hidden text before the first
letter of the email address. I tried all the functionalities to get rid of
this...
|
|
1 |
127 |
|
|
|
|
5 |
86 |
|
|
|
|
1 |
190 |
|
|
How to average values based on time period by
Peters48
I have a table with several columns: two of which are labeled Date and Value.
I want to extract the average from the Value column based on a date
criteria. ...
|
|
6 |
115 |
|
|
|
|
7 |
179 |
|
|
|
|
1 |
129 |
|
|
6 Day working week (friday holiday) by
Dan Johns
Hieveryone,
I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every...
|
|
2 |
170 |
|
|
formula for local time and GMT? by
hsg
I would like to display time in LOCAL time as well as GMT.
Whenever LOCAL time is entered in A1, B1 should automatically
display GMT. Both cells to use format...
|
|
1 |
153 |
|
|
Fill Handle by
Leeba
I need Excel 2007 to do the following:
23493-A
23493-B
23493-C
I entered the alphabet as a new list. It works alone, but when I put a
number and dash before...
|
|
6 |
149 |
|
|
|
|
2 |
122 |
|
|
@which function to use when by
Sandeep Lohchab
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25,...
|
|
5 |
110 |
|
|
|
|
4 |
119 |
|
|
VLookup with multiple conditions by
mr tom
Hi,
Happy New Year, all.
I need to lookup based on both of two conditions being satisfied.
We have a number of financial advisers in regional offices, and...
|
|
9 |
97 |
|
|
|
|
1 |
72 |
|
|
How To Protect Sheet For SHIV by
trip_to_tokyo[_3_]
SHIV I cannot reply to your posting but this is what you need to do:-
To lock all the cells in a Worksheet in EXCEL 2007 take the following action:-
1. Hit...
|
|
0 |
119 |
|
|
Two types of Data Validation in a cell? by
Lakeville
I want to ensure that the data in a cell is either a capitalized Y or a
capitalized N. I understand how to do the data validation of a list with Y &
N. And I...
|
|
8 |
106 |
|
|
|
|
4 |
144 |
|
|
Vertical page breaks - one per column by
Staceyglow
I have a spreadsheet that is 40 columns wide, and except for the 1st column
(which will be repeated at the left), I want a page break after each column.
Is...
|
|
1 |
126 |