|
|
|
March 31st, 2010 08:23 PM
by tompl
|
2 |
204 |
|
|
|
|
3 |
366 |
|
|
|
March 31st, 2010 08:04 PM
by tdf2437
|
0 |
131 |
|
|
Sorting/Filtering Info by
KErin
Hi,
I have a 1500-row mailing list that includes the guests' account numbers in
one of the columns. Some guests have multiple addresses (work, home, etc) so...
|
March 31st, 2010 07:51 PM
by KErin
|
2 |
138 |
|
|
Excel On-line by
pivotman
I have been searching for a tool to take a dashboard i have created in Excel
and put it on a website for sharing.
I have built a complete dashboard in excel,...
|
|
0 |
116 |
|
|
SUBTOTAL A LIST by
Jim W
Hi - Is there a way to subtotal a list...once I create a list the subtotal
feature is not available. I also fail to see the difference between a list
and...
|
|
1 |
144 |
|
|
Look up, return value by
Katerinia
i have a list of job codes in Sheet 1 column V that need to be updated with
new codes listed in Sheet 2 column B.
Sheet 2 column A contains the old job...
|
|
5 |
194 |
|
|
reformat dates to yyyy/mm/dd by
Katerinia
I have a worksheet with dates of mm/dd/yyyy
I need to reformat them now to be yyyy/mm/dd
Whats the formula for that?
|
|
5 |
196 |
|
|
|
|
1 |
194 |
|
|
Double If Statement help by
Brad Robinson[_2_]
Hi
I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan
then if the answer is Jan, then look in column...
|
|
2 |
133 |
|
|
Limit on Pictures? by
Dav1d
I've built a picture display in excel using the (widely recommended) link:
http://mcgimpsey.com/excel/lookuppics.html
It works superbly! But once I reach...
|
|
9 |
153 |
|
|
Compare 2 worksheets by
Candida
I have two work sheets that contain bill of material information of about
3000 component items required to build a system. There have been updates to
the...
|
|
1 |
150 |
|
|
Adding hours and minutes by
Phippsy
Hi
When adding for example overtime I format the cells to be :mm and this
will add beyond 24 hours. However for any value over 24 hours the formula bar...
|
|
1 |
189 |
|
|
Hyperlinking images by
[email protected]
I have a worksheet with several columns. One of the columns is entitled
image which I've hyperlinked to image files.
I thought that if I were to email...
|
|
5 |
201 |
|
|
|
March 31st, 2010 05:00 PM
by JLatham
|
5 |
150 |
|
|
Forumal writing for imported sheets by
Curt J
I would like to move sheets from one Excel workbook into another. Currently,
I have a template that requires me to copy and paste one sheet at from one...
|
March 31st, 2010 04:59 PM
by Curt J
|
0 |
124 |
|
|
email a worksheet by
Nadine
Is there a way to email, just one worksheet froma workbook, don't want to
send entire workbook,
right now have to do alot of copy/paste into an email with...
|
|
1 |
175 |
|
|
INDEX and OFFSET Formulas by
Kiley
If I have a set of veritcal data for each employee, but each set of data
could range from 1 to 4 vertical values, is there a way to change the
following...
|
March 31st, 2010 04:49 PM
by Kiley
|
0 |
143 |
|
|
|
|
2 |
230 |
|
|
OFFSET Formula by
Kiley
I am working with an OFFSET formula that was provided to me to help move
vertical data to horizontal data. In the original formula,...
|
March 31st, 2010 04:11 PM
by Kiley
|
5 |
157 |