|
|
Inverting a set of data by
simac
Hi, I'm going through a large data base and need to invert the data so the
reverse route is shown.
A B A B
e.g. 1 2 ...
|
July 14th, 2009 02:23 PM
by Stefi
|
5 |
113 |
|
|
Hidden worksheets by
wally
In a workbook, a number of worksheets have been hidden. Periodically it is
necessary to ‘unhide’ and display all these worksheets. Is it possible to do...
|
July 14th, 2009 06:13 AM
by AltaEgo
|
1 |
129 |
|
|
Automating a Summary Tab by
H
I have a workbook that I need a summary page that will breakout 2 different
tabs and subtotal it
Is there a way that if 1 tab holds
Part #, Desc, and...
( 1 2)
|
July 14th, 2009 12:38 AM
by Max
|
10 |
251 |
|
|
|
July 13th, 2009 07:55 PM
by john
|
5 |
120 |
|
|
|
|
6 |
117 |
|
|
|
July 13th, 2009 06:52 PM
by Eduardo
|
1 |
130 |
|
|
|
|
2 |
178 |
|
|
How to add 99 before 10 digits? by
Raja[_2_]
Hi all,
Greeting for the day.
I have serial number in a column like 0123456789 that is 10 digits
however it has to 990123456789
The actual requirement is...
|
|
5 |
146 |
|
|
|
July 13th, 2009 10:34 AM
by Stefi
|
2 |
96 |
|
|
To JoeU2004 by
dindigul
Hello
I read that using PMT you calculate your instalment/EMI on particular amount
of Loan.
GoalSeek on the other hand finds out the max loan you can get if...
|
|
2 |
115 |
|
|
Goalseek gives incorrect results by
dindigul
Hello
Using =PMT formula, I input B1=pmt(14.5%/12,60,A1) and in GoalSeek, I set
cell B1 to 5000 by changing cell A1 and I get 212,510.21 as the result...
|
|
1 |
128 |
|
|
Drop-down boxes by
KRK
Hello,
I want to enter text into a cell, with the text chosen from a limited number
of options (probably listed in a separate sheet). I suspect I need a...
|
|
2 |
168 |
|
|
|
|
1 |
158 |
|
|
Area Test Figures by
Steve[_73_]
Hi Don,
As promised latest test figures by area these include David's latest tests.
--
Steve
|
|
0 |
97 |
|
|
|
|
2 |
135 |
|
|
|
July 11th, 2009 05:10 AM
by Pella
|
0 |
87 |
|
|
|
July 11th, 2009 05:10 AM
by Pella
|
0 |
108 |
|
|
Print Screen by
Question on print screen
I am trying to use the print screen key and paste it to excel, and I got an
error message"Microsoft Office Excel can't paste the data"
|
|
1 |
119 |
|
|
Dates in fomula showing as whole number by
Dave
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From...
( 1 2)
|
|
10 |
251 |
|
|
|
July 11th, 2009 01:49 AM
by Pella
|
0 |
73 |