|
looking for free barcode font for excel
please help...
|
3 |
17.08.2006 07:04:01 |
|
|
Count is not working
Okay, this is BASIC and I feel bad for asking, but I can not get my
count to work.
I have a spreadsheet with a list of doctors names and other
information, I tried to do a count on the column using the following
formula:
=count(D:D)
And Excel gave me 0.
I tried this on other columns, it worked, there is no formula in the
column, my spreadsheet is not on manual calculate, when using...
|
6 |
17.08.2006 07:00:01 |
|
|
Lookup match 2 items
I want to lookup 2 items for a match to enter 3rd item.
EPP 2.80 x? want A3 to have a lookup function
that matches both A1 and A2 to the array.
EPS 1.25 0.5%
EPS 1.5 0.5%
EPS 1.75 0.5%
EPS 2 0.5%
EPS 2.25 0.5%
EPS 2.5 0.5%
EPS 3 0.5%
Gcet 3 0.5%
Gcet 5 0.5%
Rmer 1.5 0.5%
Rmer 1.75 0.5%
Rmer 2 0.5%
Rmer 2.25 0.5%
Rmer 2.5 0.5%
Rmer 3 0.5%
Arcel 1....
|
5 |
17.08.2006 06:58:02 |
|
|
Default template wrong
I have Excel 2000, when I open a new workbook my column headers are labeled
A-Z and my rows are labeled A-Z. How do I get the rows to be labeled 1-?
again?, is this part of the default template, if so can I delete and will
Excel recreate it for me? Lastly, what is the name of the default template
for Excel?
Any help is appreciated...
|
2 |
16.08.2006 23:47:48 |
|
|
Financial Spreadsheet Help (2007)
I am trying to create a stock portfolio data spreadsheet for Excel 2007,
but I am encountering many problems.
Firstly, I am trying to find a formula that will divide the current
value of the stock with the initial price. However, I receive a #Value
error (or some equivalent) whenever I try to enter
=Quotient(G6:G100,F6-F100).
Also, can Excel automatically change the color of the text depend...
|
5 |
16.08.2006 21:34:27 |
|
|
Restore cell grid background
I'm working on a spreadsheet created by someone else. The cell lines are
not displayed. All I see is a white background. How do I restore the
cell lines so that I can see them?
--
km4hr
------------------------------------------------------------------------
km4hr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37615
View this thread: http://www.excelforum.com/showthread....
|
4 |
16.08.2006 20:57:58 |
|
|
excel doesnot print
...
|
7 |
16.08.2006 16:27:40 |
|
|
HELP with Macros
hi,
I need some help with recording a macro but every time I try to record
the macro in the personal macro workbook, I get a pop stating that the
personal workbook needs to be opened in the start up folder in order to
record, but I don't know how to open it. I would appreciate any
suggestions.
Thanks,
Calli
--
calli
--------------------------------------------------------------------...
|
8 |
16.08.2006 14:27:29 |
|
|
time table
I have a time table that I enter what time I come to work and what time I
leave. I didn't program it to add the total but when I put in total hours
worked "8" it puts in 0:00. When I double click to see if there is a setting
I get this 1/8/1900 12:00:00 AM I have tried to delete this but it still
shows up. What can I do to correct this problem? Thank you...
|
5 |
16.08.2006 13:59:02 |
|
|
how do i write formula for if condition in excel?
...
|
5 |
16.08.2006 12:13:10 |
|
|
find simillar variables in 2 different sheets
i have 2 different sheets with the same indentifier numbers am trying to
figuer out how to get the same numbers
...
|
2 |
16.08.2006 01:56:01 |
|
|
& in footer
How do I make an & appear in a footer.
...
|
3 |
15.08.2006 23:48:02 |
|
|
function to find if a number is whole
Does anyone know of a function to determine if a number is a whole integer
and not a decimal place?
I want to target a cell (that has a sum value in it) and create an if
statement if it's a whole number or not.
::CORY::
...
|
7 |
15.08.2006 19:29:32 |
|
|
B29 HAS JB# THATS IN OTHER CELLS IF I CHNG B29 WANT ALL TO CHNG?
CELL B29 HAS JOB# (& OR NAME) THAT IS REFERENCED FOR ALL CONSTRUCTION WORKERS
WHEN WE CHANGE JOB#'S I WANT IT TO CHANGE IN ALL CORRESPONDING EMPLOYEES
WORKSHEETS......
|
3 |
15.08.2006 19:08:49 |
|
|
How do I make fill-in-the-blank forms, with Excel?
I'm new to Windows, and I have no idea how to create a fill-in-the-blank
style program using Windows XP, and Microsoft Office (Excel). I think I'm
going in the right direction with Excel, but every time I protect a cell, I
can change the info with a double click. It's like the protection isn't even
there, What's up? I need HELP! Is there something that I'm doing, (or not
doing) that wi...
|
2 |
15.08.2006 18:15:51 |
|
|
Adding a loop to conditional delete code
Hello all,
I have the following code:
Sub DelOver16()
If ActiveCell.Value >= 16 Then ActiveCell.EntireRow.Delete
End Sub
What I need to do is have the code loop through cells F2:F10000 and delete
entire rows that have a value of >=16.
How would I do that?
Many thanks in advance
Mark
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/exce...
|
22 |
15.08.2006 15:11:11 |
|
|
Vlookup
I have a vlookup sheet,I want to add notes to the cells in the vlookup
table,but when i get the information from the vlookup table to another sheet
the notes will not go over with the information .CAN ANYONE HELP.
P.S I hope i have explained this correctly....
|
7 |
15.08.2006 11:13:01 |
|
|
how to create a tax return form using excel
...
|
3 |
15.08.2006 08:33:02 |
|
|
Not sorting as expected
I have a database some 10 columns wide and 1200 rows deep. When I sort by
one particular column it sorts BLANKS before text meaning that the data
appears at the bottom of the database although still in alphabetical order.
I have the formatting set to GENERAL for the whole column and do want the
blank cells. None of the other columns do this. I am totally perplexed as I
thought Excel sor...
|
5 |
15.08.2006 01:27:02 |
|
|
Soccor Tables
Hi, I have all the English football league results from 1890 to present day.
The data is in the format "20010821","P","home team ","1","away team ","0"
---- Date,Div,Hteam,Score,Ateam,Score.
I have for a long time wanted to use excel to format league tables for any
week or date. I feel I would be able to do this if I was pointed in the
right direction concerning methods pf programming or p...
|
2 |
14.08.2006 22:37:15 |
|
|
Seemingly random .tmp files
Seemingly random temp files are appearing in a directory where I maintain
three excel files that are accessed by multiple users.
I have three excel files stored in a single directory on my company's
network. The files are accessed by Store Managers through our VPN via Citrix.
I update these files in the mornings, and Store Mgrs add their comments
throughout the day to sections releva...
|
4 |
14.08.2006 22:17:11 |
|
|
lookup array
Sheet 1 below:
A13 is a lookup from Sheet 2. I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.
=LOOKUP(A13,A2:B11) but get this #N/A? What am I doing wrong?
PRESS SIZE Rate $
K68 250
K813 300
K1014 400
K1214 500
K13517 550
K13518 60...
|
4 |
14.08.2006 20:24:01 |
|
|
Displaying a percentage
Sorry if this appears to be a newbie question, but how do I display a
percentage figure of another cell. Example:
A1 £52.89
A2 17.5% of A1
Thank you
--
Timeferret
------------------------------------------------------------------------
Timeferret's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19170
View this thread: http://www.excelforum.com/showthread.php?thre...
|
6 |
14.08.2006 19:47:14 |
|
|
Cant make it work
I really need help with EXCEL. Here is what I want to do!
I want it set up so I can have my credit card balances in one column,
the APR in column 2, column 3 figure out minimun payment, column 4 is
what i actually pay, and column 5 figure my new balance.
Now my question is one is this possible? and 2 how do I go about making
this happen?
--
Bama_Buc
-------------------------------------...
|
3 |
14.08.2006 19:43:02 |
|
|
Getting a cell address and using it
I have a spreadsheet containing production information. I want to be
able to search by date (can do this using VLOOKUP), and extract
information from the same row as that date.
However, I also want to be able to extract the previous 10 entries as
well, for comparison purposes.
ie I enter a date and find that it is in B95, and the piece of info I
want is in C95. I also want to be able to pul...
|
2 |
14.08.2006 16:42:01 |