|
|
Excel 2007 custom views and tables by
Will Fleenor
Apparently when you have an Excel 2007 Table anywhere in a workbook the
"Custom Views" feature is disabled. Is this correct? Are there any...
|
|
3 |
291 |
|
|
Adding numbers based on Range by
Carla
In the C column I have categories and in the J column I have Hours
Is there a formula to where I can look up the category "Library" in C and
add only those...
|
|
2 |
586 |
|
|
|
|
2 |
623 |
|
|
|
June 18th, 2009 03:01 PM
by Denver
|
4 |
676 |
|
|
COUNTIF function for multiple criteria by
yorkshirelass
I hope someone can help me. I devised a s/sheet in Excel 2007 using the
COUNTIFS function. However, not all my colleagues like 2007 and have
reverted back to...
|
June 18th, 2009 01:45 PM
by Bernd P
|
8 |
987 |
|
|
Replacing only the empty cells. by
Colin Hayes
Hi
In column P I have cells which are blank , and cells which have word
content.
I need to replace all the blank cells with the words 'A-Z' , and leave...
|
|
3 |
679 |
|
|
insert muliple rows, every 4th row by
davisk
I have one column with data down the first 50 rows. I need to insert 3 new
rows for each of the existing rows of data. I failed an attemp using a
formula...
|
|
7 |
849 |
|
|
Excel 2003 by
RJ
Where can I find the Auto FIll Options Button in Excel 2003?
|
June 18th, 2009 01:22 PM
by RJ
|
2 |
672 |
|
|
Help with multiplication formula by
Josh W
1) I want to do the following calculation in cell E20: total of cells D1 to
D20 multiplied by 3. What is the correct formula?
2) Also if I want to add up...
|
|
3 |
622 |
|
|
|
|
3 |
673 |
|
|
|
|
3 |
907 |
|
|
transpose array of non-adjacent cells by
ignite ice
I have a range of cells in a single row. This range is C3:AD3. I am trying to
transpose this specific cells from that range into a single column, B34:B43.
In...
|
June 18th, 2009 09:58 AM
by Ragdyer
|
3 |
687 |
|
|
Hyperlinks to many Sheets within a Workbook by
hardeep.kanwar[_11_]
Hi! Experts
I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have
Names of the Sheets.
Now i want to insert Hyperlinks in the "UNIQUE LIST"...
|
|
5 |
779 |
|
|
|
|
3 |
669 |
|
|
Numbering by
Kumar
Hi there.
I would like to inquire on how to create formula for sequential numbering
for examples given below:
1. CMD/BCN/AMD/001
2. CMD/BCN/AMD/002
3....
|
|
3 |
665 |
|
|
Conditionally format entire worksheet by
JDesmarais
I want to format the worksheet to look in every cell for a letter and if that
letter is present, color the background a color. I cannot figure out how to...
|
|
3 |
607 |
|
|
margins keeping changing by
excel margins
everytime i try to print out a full work sheet on excel it keeps changing my
margins and not taking up the whole page...how do i fix that?
|
|
1 |
621 |
|
|
|
June 18th, 2009 02:07 AM
by Max
|
4 |
646 |
|
|
|
June 18th, 2009 01:52 AM
by Steved
|
2 |
597 |
|
|
I forgot how to duplicate SCH 051 by
Steved
Hello from Steved
With the formula below why is it not displaying "dup" for "SCH 051" "SCH
051" please.
=IF(COUNT(F3,B3)2,"",IF(F3=B3, "dup",""))
SCH 051...
|
June 18th, 2009 12:28 AM
by FSt1
|
3 |
611 |