|
|
|
|
3 |
418 |
|
|
|
|
1 |
433 |
|
|
Picture problem by
dwake
I want to have a picutre stay in the frame even while scrolling through the
worksheet. Is this possible?
|
|
1 |
342 |
|
|
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 |
311 |
|
|
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 |
294 |
|
|
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 |
285 |
|
|
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 |
304 |
|
|
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 |
237 |
|
|
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 |
316 |
|
|
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 |
291 |
|
|
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 |
212 |
|
|
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 |
229 |
|
|
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 |
233 |
|
|
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 |
282 |
|
|
|
|
2 |
327 |
|
|
|
|
1 |
250 |
|
|
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 |
346 |
|
|
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 |
199 |
|
|
|
|
0 |
246 |
|
|
|
|
0 |
240 |