|
make a spreadsheet with diagnal column headings
...
|
2 |
17.09.2006 08:17:38 |
|
|
I need a formula to do some calculations with time.
I need a formula to calculate time units for concurrency issues and for
descrepancies in an audit. What I need below:
1.) a formula to calculate the minutes in 10 and 15 min incriments.
This formula should divide minutes by 10 & 15 min incriments. We then need
it to round to the tenths, for specific insurances such as: Medicare.
2.) a formula to capture concurrency issues. (when time o...
|
3 |
17.09.2006 06:56:53 |
|
|
how do I obtain position of specific value in a row of numbers
I have a row of 10 binary values in a row (column a to J for example). an
example follows:
0010011000
I need a formula that will return the position (numerically) of the first
"1" and another that will give the position of the last "1".
for the above, the formulas would return 3 and 7 respectively.
Can anyone advise?
anand...
|
6 |
17.09.2006 06:32:51 |
|
|
Need dynamic name range in Excel for Outlook interface
I am developing an Outlook solution in which we read a log that is an Excel
spreadsheet that has a name range assigned to the data that is being imported
into Outlook for a list box display. Outlook has the capability of reading
the number of rows in an Excel named range and using that as a dynamic way to
read in continuously increasing data into an array that increases as the
range inc...
|
4 |
17.09.2006 06:21:11 |
|
|
Sumproduct values from two ranges
I have two tables, both with two columns.
the first column in each table is a key index number. I want to be able to
multiple the values in the second column off when each record has the same
key value and then and return the summed value for the whole population.
eg.
Table 1
Index Rate
1 .03
2 .04
3 .03
4 .04
5 .02
6 ...
|
5 |
17.09.2006 02:06:01 |
|
|
Microsoft EXCEL 2000 Formula
Hi
I have a mixed column of numbers between 0 and 75. From these numbers I
want a second column to predict a future score. eg 0-20 would produce 1A,
20-50 would produce 2A and 50- 75 would produce 3A. Is it possible to do
with a formula please?
Thank you
Lou...
|
8 |
17.09.2006 00:54:01 |
|
|
Inserting columns & rows in worksheets
How do I insert a column or row throughout all my worksheets in a workbook?
I want to repeat the exact same transaction into each worksheet, without
having to program each worksheet individually. Thanx...
|
4 |
16.09.2006 20:43:47 |
|
|
Adding a % value to a column of numbers
hello anyone how can help, i'm new to exel ,now in exel i have a column of
different number like 512.00,654.00,68.56, and so on down this colunm and i
want to add say, 25% to all the values in this column, how do i do it?
there are over 1000 different number combinations in this column.
Please help
Morefeus Direct.com...
|
10 |
16.09.2006 20:41:40 |
|
|
Saving a worksheet to csv with different separator
Hello, I want to save a csv or text file from excel 2000 but using | as
separator.
However I can not find option to chose the separator ...
any advise welcome and appreciated
...
|
4 |
16.09.2006 20:03:51 |
|
|
Counting Rows - Fill ???
I would like a formula tha will count columns. I was using the fill down in
series, its been a while, but I though I could tell it to start at 1 end at
27 and start over at 1 and goto 27 until all the lines that contains data or
in a range are counted.
When I use the fill down I put the stop value at 27 and in the 1st column I
have a 1 and that works. But I have to Manually do this ev...
|
2 |
16.09.2006 18:11:33 |
|
|
Formula
Can someone give me a formula for this scenario? If the Sum of A1 and A2
equals a 1, the result would give me a $15 answer. If that same sum equals a
2, then the result would give me a $25 answer...
|
3 |
16.09.2006 18:01:46 |
|
|
Information from one column then filtered(?) from another
Here is a brief example of what I am trying to accomplish:
A B
1 Don
2 Jim w
3 Don w
4 Bob
5 Jim w
I would like to count the number of times that Don's name is on the list,
then the number of times Don has a "w" in the next column. The COUNTIF
function works for the first one but how do I get the second amount?
The results ...
|
8 |
16.09.2006 17:47:00 |
|
|
How can I get Excel to print dashes right across a cell
In Symphony and Lotus 123 one could press two keys and repeat a dash or
underline right across a cell however wide. Can you do this in Excel? If
so how?
Please...
|
4 |
16.09.2006 17:15:09 |
|
|
Pull cell format across sheets as part of the fomula? Is it poss?
I want to use color coding from a master sheet for sorted info to go to
individual members of a band. This would greatly simplify set list with notes
for each player....
|
3 |
16.09.2006 15:59:02 |
|
|
Sorting UK Postcodes
I need to relaibly sort UK postcodes in a column
e.g. the codes BS1 0IAA, BS23 3EB, BS2 3XX, BS10 5GT
I need to sort codes as BS1.. BS2... BS3... not BS1... BS10... BS2...
--
David Green, UK...
|
5 |
16.09.2006 15:51:42 |
|
|
Excel - Copy and Paste Footer Data
I know how to copy and paste data in a Word document and also from cells
within an Excel spreadsheet. However, the ability to copy and paste header
and footer data requires a different command, which does not readily come to
mind and doesn't seem to be available in the Help section for Excel. It is
not your standard "C" and "P"....
|
7 |
16.09.2006 15:29:01 |
|
|
If then else....
Question...
How do I write a formula in cell A1 to make this happen:
If the cell A5 is blank or "0" I need Excel to return the value of cell B7.
Otherwise it should be the value og A5.
I know how to restrict making sure that the cell is never empty - if that
makes it easyere..
Please can anyone help me?
rgs Susanne...
|
3 |
16.09.2006 13:46:02 |
|
|
Superb new financial services. Track and Manage ALL of your wealth
Here's Your Answer!
http://www.honestwealth.umwealthsite.com
Finally a financial program that helps you professionally manage your wealth
while maintaining simplicity!
WealthTrack includes:
$25,000 Online and Identity theft protection with 0$ deductible.
Daily financial tracking with automated e-mail and cell-phone paging alerts.
Step by Step, Professional credit repair including quar...
|
2 |
16.09.2006 13:39:44 |
|
|
Sum Function Problem!!
I have created a worksheet with dates going down the left hand side and
various numbers on the right. There is a clear column between the two. I want
to use the sum function to add up the numbers on the right, but when I do the
answer is a date, not the sum of the answers!?!
Any ideas gratefully received!!...
|
2 |
16.09.2006 09:29:01 |
|
|
Calcualtion of renewal
I want to create an automatic renewal for calcualtion of depreciation
after x years. To explain
this is what I want it to look like. I want a formula for this
No; of Years Year 1 Year 2 Year 3 Year 4 Year 5...... Year 30
3 Years
4 Years
5 Years
7 Years
10 Years
If a asset is purchased in the first year it will have to be renewed at
the end of 3 years, or 4 year...
|
2 |
16.09.2006 09:15:48 |
|
|
Spillting a cel
I was able to import my text files into a spreadsheet, but here is what
I need to do next and I hope there is an easier way to do this through
the program. Her is what I have, I have a product spreadsheet that
includes item number followed by the description. the item number is
always first and needs to be broken out into its own column with the
description in the next.
What I am wanting...
|
2 |
16.09.2006 08:53:48 |
|
|
merging sheets
Hi, I have several xls files (worksheets files, right?), each with several
(between 10 and 80) sheets (sheet1, sheet2, ..., sheetn). Within each sheet
the information is in the first eight columns (from A to H) and from row 1 to
row 60, but the last sheet may have less than 60 rows.
I need a macro which copies to that sheet1all the content from sheet2 to the
very last sheet. Afterwards,...
|
1 |
16.09.2006 04:52:01 |
|
|
Record changing cell data into a column or range
I have a cell that takes in data via DDE.
I need a function, say, like =STORE(DDE_Cell,Range) that will store the
changing data from DDE_Cell into Range one cell at a time. When all the cells
in the range are filled, the next STORE will be back to the top cell. Then,
each successive change will overwrite the previous data.
A second, similar function is, say =FIFO(DDE_Cell,Range) that w...
|
1 |
16.09.2006 04:24:02 |
|
|
textbox font size
hi all,
i make my sheet font size to 8 but why when i enter text in my text box, the
font size larger than 8?
where can i define the font size so that it also 8?
thanks
...
|
4 |
16.09.2006 04:24:02 |
|
|
increment operator?
Is there a shorthand increment operator ?
eg something like :
Inc(long.variable.name)
which would be easier to read than
long.variable.name = long.variable.name + 1
Also decrement too.
...
|
3 |
16.09.2006 03:35:40 |