|
|
File name Save by
Elton Law[_2_]
Dear Expert,
A1 has a text "Performance2009_"
A2 has a formula =Today()
A3 is day(A2) = 11 (in this case)
A3 is month(A2) = 4 (in this case)
A3 is year(A2) =...
|
|
4 |
76 |
|
|
|
|
3 |
53 |
|
|
Add rows depend on the number in a cell by
Elton Law[_2_]
Dear Expert,
In A1, it has a number 3.
In A2, it has a number 5.
In A3, it has a number 4.
I want to run a marco that add 2 rows if A1 contains a number of...
|
|
3 |
95 |
|
|
Add Rows depends on the number in a cell by
Elton Law[_2_]
Dear Expert,
In A1, it has a number 3.
In A2, it has a number 5.
In A3, it has a number 4.
I want to run a marco that add 2 rows if A1 contains a number of...
|
April 11th, 2009 12:04 PM
by Mike H
|
1 |
92 |
|
|
3 D reference of IRR formula. by
sirocco
Try as I may I have been unable to reference a cell containing an IRR
function to a cell in a different worksheet.
The problem is that in worksheet 3 (in a...
|
April 11th, 2009 09:08 AM
by sirocco
|
2 |
95 |
|
|
Cell protection short cut button by
Bert
I am using 2007 now insteat of 2003. I cant find a short cut button to lock
and unlock a cell. There was one in excel 2003 but as yet I can't find it in...
|
|
1 |
105 |
|
|
I need to know how to use the solver by
MS EUDORA
I HAVE A PROBLEM WHERE I HAVE TO USE A SOLVER AND I CANT GETIT RIGHT I HAVE
TO MINIMIZE THE VALUE OF ONE CELL BY CHANGING THE VALUE IN A RANGE SUBJECT TO...
|
|
1 |
86 |
|
|
|
|
4 |
118 |
|
|
|
|
5 |
98 |
|
|
|
|
8 |
107 |
|
|
|
|
1 |
94 |
|
|
Choosing Names From a List by
ppidgursky
I am working on a schedule. Our schedule changes often and I am trying to
simplify things.
I have the schedule with Location A & B, Monday thru Sunday, AM and...
|
|
1 |
100 |
|
|
|
|
6 |
74 |
|
|
Inserting page breaks by
Rich Mogy
I have written a macro that will insert page breaks in my workbook everytime
the word "Date:" is found.
How can I eliminate Excel's automatic page breaks and...
|
|
3 |
170 |
|
|
|
April 10th, 2009 09:26 PM
by AUCP03
|
2 |
92 |
|
|
Get cell reference address by
Vadims Podans [MVP]
Hi!
I'm interesting about this task. I have a table with data like this:
N.p.k. Nosaukums ID Svars Iepakojums Cena USD par 100m Cena LVL par 1m Cena
GBR par...
|
|
2 |
90 |
|
|
finding a number within a range by
Cathy Landry
Hello,
We have a PO log that tracks the PO number series and the clinic they were
issued
to. I have a vlookup that appears to work most of the time but for...
|
|
6 |
149 |
|
|
changing the vlookup col_index_num by
dawn
I have a spreadsheet where I update the col index number each week to reflect
the new weeks data for about 100 customers. At this point each week I go in...
|
April 10th, 2009 07:49 PM
by dawn
|
5 |
126 |
|
|
Multiple logics in one formula by
Sri Harsha[_2_]
I am working on creating an Effort Estimate Tool for Clients.
I have 5 products Affinity, Quantim, QES, Interlink and COPE. For each
product we have...
|
|
1 |
75 |
|
|
|
April 10th, 2009 07:29 PM
by Mike H
|
2 |
83 |