|
|
Lookup multiple values by
richzip
On one worksheet, I have a "table" with a header column & header row, along
with data. ON another worksheet, I would like all of the data in the first...
|
|
4 |
224 |
|
|
Subtract colums in pivot table by
Domenick
I have a pivot table that has the following characteristics (Excel 2007):
-rows (down the left) are values: "# Employees", "Total Pay"
-Columns (across top)...
|
|
0 |
289 |
|
|
Command Buttons by
Command Button Calculations
I am trying to insert a command button so that when the user fills out the
form and clicks the button, an amount will calculate. For example, the sales
price...
|
|
4 |
296 |
|
|
|
|
2 |
412 |
|
|
Mysteries on msnews. by
James Silverton[_4_]
Hello All!
I note that m.p.excel.misc disappeared this morning from
msnews.microsoft.com. It seems to be alive and well on eternal-september
but I restored...
|
|
2 |
203 |
|
|
Excel 2003 accepting error message in macro by
BJ&theBear
This very short macro below creates a userform which can be searched
to find the required contract number.
However when it is "run" an error message appears...
|
|
2 |
322 |
|
|
Conditional Formatting an Entire document by
Conner
I'm doing financial reporting for an entire fiscal year different
distributors with over 49000 rows. First I would like to highlight cells that
have a higher...
|
|
1 |
278 |
|
|
|
|
2 |
277 |
|
|
|
|
3 |
297 |
|
|
|
|
1 |
236 |
|
|
hyperlink formatting by
Carrie_Loos via OfficeKB.com
I have a column, J, that has a mixture of hyperlinks and text or comments. I
want the hyperlink to remain blue with the double underline and the text to
be me...
|
|
2 |
279 |
|
|
|
|
3 |
238 |
|
|
|
May 25th, 2010 04:48 PM
by BB
|
0 |
257 |
|
|
Excel 2007 Compatability Checker by
BoRed79
I have a number of files which were created in Excel 2003 (and have only been
modified in Excel 2003).
I have now switched to Excel 2007 and when I am saving...
|
|
1 |
248 |
|
|
random sampling by
staciern
Hello
I have a list of 705 patients with four different columns with data in it.
I need a random sample consisting of 150 of those patients. Can someone...
|
|
5 |
248 |
|
|
Insert formula by
John
Hi all,
Is there a way to insert a row automatically in between a different number
when the number change?. Like creating a macro or something. I do not want...
|
May 25th, 2010 04:25 PM
by John
|
3 |
283 |
|
|
format cells depending on value range by
gashman
Using Excel 2003 and am trying to format cells depending on a range of values
e.g.
If the value is less than 50.999% then colour the cell red
If the value...
|
|
5 |
430 |
|
|
Excel 2010 Year Planner by
James
Hi,
I wanted to know if there is any way to create a 2010 excel year planner?
i.e. something that would be similar to a 2010 wall chart calendar.
Thanks...
|
|
1 |
280 |
|
|
Data validation by
Diddy
Hi,
I'm reusing a worksheet with a mixture of data validation and data entry
cells. The data validation is based on a list and the first cell in the list
is...
|
May 25th, 2010 03:31 PM
by Diddy
|
3 |
215 |
|
|
Need Help Search and Add by
tech1NJ
Have a 2 rows of cells (5 and 6) with data. Row 5 has letters A through S.
Row 6 has years 2001 through 2018. In addition, I have Cell A14 where I would
like...
|
|
2 |
223 |