|
|
|
|
3 |
443 |
|
|
|
|
1 |
460 |
|
|
Picture problem by
dwake
I want to have a picutre stay in the frame even while scrolling through the
worksheet. Is this possible?
|
|
1 |
364 |
|
|
Auto Page Numbering Question by
ChuckF
I have a 12 page pricelist. Recently we made changes to the last 4
pages of this sheet. I am not getting ready to have the last 4 pages
printed and sent to...
|
|
2 |
335 |
|
|
Sort Window Size by
EWJJET
My company recently upgraded to Windows7 and Office 2007. When I use the sort
command in Excel, the size of the sort window increases with each use of the...
|
|
1 |
315 |
|
|
Variable Range in Formula by
Gabe
I'm stuck on this one, hopefullly someone can help. I have the following
formula:
=SUMPRODUCT((B2=$B$5)*(B2=$B$6))
Well "B2" in this formula is supposed...
|
May 12th, 2010 06:42 PM
by Gabe
|
2 |
308 |
|
|
Refresh some not Refresh All by
PBISMaryland
Hello. I have a workbook with 10 sheets all of which have external data that
needs to be refreshed periodically. Most of the time I only need to refresh
8...
|
|
1 |
323 |
|
|
Need Macro to reset dependent list by
Bean Counter[_3_]
Hi All,
I have a set of 2 lists, one dependent on the other. If the value of the
list in column A changes AFTER the value of the list in Column C is...
|
|
2 |
260 |
|
|
Excel Column Renumbering Question by
clacount
If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to...
|
May 12th, 2010 05:49 PM
by dlw
|
3 |
338 |
|
|
Where is pivot table data? by
srpd
I created several pivot tables months ago, all linked to one master data
sheet. Now it's time to update and I can't find the master. The Field List
and...
|
|
1 |
313 |
|
|
MACROS by
Kevin
The last post ( separate lines)helped greatly.
Now how do I save my macros so that they open with all NEW Spreadsheets?
|
|
4 |
231 |
|
|
Conditional formula by
desmond1412
trying to construct a formula for the following for the same cell:
if a2 6, then e2 = 0
if a2 = 6, then e2 = 1
if a2 = 5, then e2 = 2
if a2 = 4, then e2 =...
|
May 12th, 2010 04:55 PM
by Brad
|
3 |
251 |
|
|
conditional formatting by
SuzyQ
I want to format column I (highlight cell) under the following condition
the value in same row column F is 0 and the cell in column I is empty. I
have put...
|
|
1 |
252 |
|
|
Edit with Microsoft Query - Menu Option by
Mike
I installed Excel 2007 and now when I Right-Click on an existing Microsoft
Query file(Excel 2000 or Excel 2003), I do not see the Menu Option to 'Edit
with...
|
May 12th, 2010 04:34 PM
by Mike
|
0 |
304 |
|
|
|
|
2 |
351 |
|
|
|
|
1 |
269 |
|
|
Binary Numbers by
Sanford Lefkowitz
This might be more of a math question than Excel.
I have an application for which I would like to know the number of "1"s in
the binary representation of a...
|
|
9 |
348 |
|
|
copy formulae in excel by
beginner
How do I copy a formulae to next rows without having Excel update the
formulae in relation to the new cell?
|
|
2 |
222 |
|
|
|
|
0 |
268 |
|
|
|
|
0 |
262 |