excel formulae
i'm creating invoices from cost sheets.
in order to hide the 'true' mark up (profit) i have to inflate the labour
(time taken) however how more oftenthan not i end up with a figure that is
not divisible by a time unit such as, 3 hours, or 3.25 hours, 4.75 hous
......must be quarter of an hour increases etc.
what formulae might one create, to make a monatary figure relate to a time
figure in .25 units (15 minutes)
example a sum of £88.23 divided by labour rate of £27.00 = 3.26666666
ideally this time figure should be 3.25 hours or, 3.5 hours....
ideas?
regards
Dean
|
3/11/2010 6:46:02 PM
|
1
|
=?Utf-8?B?dmFsbGV5Ym95?= <valley...@discussions.microsoft.com>
|
|
VBA menus at side
I suspect this is a generic windows issue, rather than one specific to
Microsoft Visual Basic 6.5 on Microsoft Office Excel 2003 (11.8320.8221)
SP3 on Microsoft Windows Vista Business 6.0.6002 Service Pack 2.
I would expect
File Edit View Insert Format Debug Run Tools Add-Ins Window Help
to run horizontally at the top of the VBA window, just below the title.
It runs vertically on the left hand side of the window.
I've finally got sufficiently irritated with this to ask if anyone will
say how to control it?
Thanks!
--
Walter Briscoe
|
3/11/2010 12:40:06 PM
|
2
|
Walter Briscoe <wbris...@nospam.demon.co.uk>
|
How to convert a ($200) cell to a written amount(Two hundred doll
Is there way to convert dollar amount in a cell to a written amount like
$250.00 to two hundred and fifty dollars and 00/00 cents.
|
3/11/2010 12:44:02 AM
|
2
|
=?Utf-8?B?YXR2cmlkZXI=?= <atvri...@discussions.microsoft.com>
|
Can I do a global find and replace on the tabs in Excel 2007
I'm trying to create a template in which each tab has a month designation,
and on the worksheet the colums would have the daily date. Is there any
quick way of doing this? I have already created a couple of months, and have
tried to do a global replace the the dates, but get a dialog box stating no
matching info. Help
|
3/10/2010 6:15:01 PM
|
1
|
=?Utf-8?B?U2FuZGk=?= <Sa...@discussions.microsoft.com>
|
fill a color to a row
Hi,
I want to check a column (lets say H) if there is a 1 value i want excel to
color the row.
lets say there is a 1 on H6, I want to fill a color to row 6. It can be full
coloring or if i can i might like to range it to A6:J6
thanx in advance
|
3/10/2010 4:30:06 PM
|
9
|
=?Utf-8?B?bW5z?= <...@discussions.microsoft.com>
|
Making first column number in order
I am very unfamiliar with Excel or databases in general. My first column/row
is numbered by Excel. However, when I delete fields, the numbers don't move
up to account for that. So let's say my first row has a 1 in front of it.
After I delete fields/rows 2-6, Excel shows that column as 1, then the next
number is 7. I am probably not using the correct terminology here, but
basically, after I delete fields, I cannot look at the last number to see how
many I have. I have to manually count them. I'm sure there's a simple button
to push to fix it, but I haven't found it.
Thanks! Terry
|
3/10/2010 4:04:02 PM
|
2
|
=?Utf-8?B?VGVycnk=?= <Te...@discussions.microsoft.com>
|
rows & columns height & width
Hello,
Is there a way of forcing the row height and column width to be equal , and
to remain equal, so that all cells are square ?
Thanks
KK
|
3/10/2010 12:20:23 PM
|
1
|
"KRK" <tre...@yeleek.nospam.freeserve.co.uk>
|
Question for JLatham
Hi J,
I responded with answers to your questions on my post titled 'could someone
write me a VB code? thanks' dated 3/4/2010. Have you had time to have a look
at it yet?
--
thanks
|
3/10/2010 3:15:01 AM
|
1
|
=?Utf-8?B?TW9yZ2Fu?= <Mor...@discussions.microsoft.com>
|
multiple files open upon startup
Every Time when I open Excel 2007 after updating from 2003 - multiple files
(140 to be exact) open before I can even select open file to get the one I
want. I went online and download updates today, now it opens 243 files. I
have closed each one, tried to close group (it won't let me), deleted files
all to no avail. How can I stop files from opening automatically upon
starting Excel? It's very frustrating HELP PLEASE I have tried getting
ahold of microsoft directly and can't get any help here either. I'm stuck
without help. Can anyone please help me?????
|
3/9/2010 10:42:01 PM
|
1
|
=?Utf-8?B?Vmlja2kgQg==?= <Vicki ...@discussions.microsoft.com>
|
SUMIF non-blank cells?
We have been able to conditionally sum a column of cells (sum_range) based
on the blank cells in another column (range) using
SUMIF(A$8:A20,"",B$8:B20). Nevertheless, we actually need to sum the
NON-BLANK cells in the sum_range column. How do we create a formula that
will sum the non-blank cells?
Please note that we have tried several iterations of the formula 'criteria'
argument including NOT(""), NOT(""""), "NOT("")", "NOT("""")", ISBLANK(),
"ISBLANK()", and so forth. We have most likely failed to understand the
proper syntax for the 'criteria' argument, but there surely
|
3/9/2010 6:18:17 PM
|
5
|
"Blue Max" <mailrich...@msn.com>
|
SORTING HELP!
If I sort my table alphanumerically by one of the columns in the middle, how
to I make sure all the info in their respective rows follows them? I need to
alphabetize my document by information in the 5th row, but when I do that,
the rest of the information gets all out of order, how do I get it to sort
that way without loosing the corresponding info in the rows?
Thanks
|
3/9/2010 6:07:01 PM
|
2
|
=?Utf-8?B?cGVld2VlZGVsaXZlcnk=?= <peeweedeliv...@discussions.microsoft.com>
|
Cell formulas display "0" (zero's)
How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want to
have to make the entries white to hide them. There's gotta be a way to not
show this value.
My thanks
Lenny
|
3/9/2010 5:47:01 PM
|
3
|
=?Utf-8?B?TGVubnk=?= <Le...@discussions.microsoft.com>
|
EXCEL files and Windows - - an open and shut case?
Hi
I posted this on the Win 7 technet forum and was told to post it here. so,
---
I’m using windows 7 64bit and Office 2007
Please can someone explain how I can open 2 Excel files in separate Windows?
Currently when you open 2 files they both open in the same window but
different tabs.
I have searched around and found the following answers for XP and Vista
“Open Windows Explorer
Select "Tools"
Select "Folder Options"
Select the "File Types" Tab
Scroll down to find and select the XLS extension
Click the "Advanced" Button
Select the "Open" action from the
|
3/9/2010 5:10:03 PM
|
0
|
=?Utf-8?B?TWFudGFyaQ==?= <Mant...@discussions.microsoft.com>
|
Spelling options
I want to add Hi-Build (with a non-breaking hyphen) to a custom dictionary
in Word 2007 (UK spelling). The spell checker will neither add it to my
dictionary nor ignore it.
I have tried editing the dictionary directly and I can get as far as Hi-Buil
but then the Add button is greyed out.
Can anyone help please?
|
3/9/2010 8:41:40 AM
|
0
|
"janey" <ja...@newsgroup.microsoft.com>
|
Text To Date Conversion
Hi
I run Excel 2000
I download information from a mainframe into Excel.
In cell F5 the data looks like this: 19.11.2007
This is formatted as text and is left aligned.
When I try to reformat it to a date (19/11/2007) it does not change.
I would like to have a formula in cell N5 that changes the original data to
a datevalue. (eg: 19/11/2007)
Thanks
|
3/9/2010 1:23:01 AM
|
2
|
=?Utf-8?B?Sm9obiBDYWxkZXI=?= <JohnCal...@discussions.microsoft.com>
|
One column to another
I am looking to make a number equal from one cell to another number. EX:
43=1, 42=2, 41=3, etc. going 43 to 1. here is how i have done it so far:
=IF(C13=43,"1",IF(C13=42,"2",
IF(C13=41,"3",IF(C13=40,"4",IF(C13=39,"5",IF(C13=38,"6",
IF(C13=37,"7",IF(C13=36,"8")))))))) I have used 6 cells to complete it and I
know that is not the best way to do it.
|
3/9/2010 12:37:01 AM
|
2
|
=?Utf-8?B?TWFrZSBvbmUgY29sdW1uIGVxdWFsIHRvIGFub3RoZXIgbnVtYmVy?= <Make one column equal to another n
|
looking up a value only if it returns a value in another list
I have two data tables in Excel 2007.
Table A holds a bill of materials with parent and child parts laid out
suitable for use with vlookup.
Table B holds a selected list of raw materials which are child parts.
I want to lookup a parent part from a cell and search for one of its child
parts in table A if the result of the search matches one of the raw materials
in table B.
I can do simple vlookups but this is outside my knowledge.
Can anyone please point me in the right direction?
Thanks
--
Richard
|
3/8/2010 11:49:01 PM
|
5
|
=?Utf-8?B?UmljaGFyZA==?= <Rich...@discussions.microsoft.com>
|
how do I specify a date range = date(2010,4,1 thru 30)
I am trying to use a header in a formula. In A1 I have the month and year
(April 2010). I want to bring in a calculation result from a second page
(Daily Log) So I want to know how many guest in the month of April visited.
But it has to look up April from the year list.
I guess this is what I am trying to accomplish Lookup (A1) April (1-30) 2010
from April Stats sheet on Daily log sheet (A column) add guests logged in (D
Column) and result to April Stats B5
I record numbers daily and want to have the totals from one page brought to
another page, but need the data to be found
|
3/8/2010 9:28:01 PM
|
1
|
=?Utf-8?B?Y2FycGVyMTk3NQ==?= <carper1...@discussions.microsoft.com>
|
EXCEL - NEW PAGE
HOW DO I INSERT AN EXTRA PAGE IN EXCEL?. THERE ARE NO BUTTONS ON THE TOOL
BAR TO DO THIS. I HAVE WINDOWS 7 WHICH IS NEW. ALL THE DATA FROM MY OLD
MACHINE HAS BEEN TRANSFERRED TO THIS NEW MACHINE. I DO NOT HAVE
'FILE,EDIT,VIEW ETC' ACROSS THE TOP OF THE PAGE.
PLEASE HELP
|
3/8/2010 11:34:01 AM
|
3
|
=?Utf-8?B?TElaWklF?= <LIZ...@discussions.microsoft.com>
|
pictures
pictures of
pictures of
'pictures of jackson rathbone' (http://www.no-pictures-2010.info)
picture of
pictures of
--
raismisuaween
|
3/8/2010 10:09:26 AM
|
0
|
raismisuaween <raismisuaween.5da9...@officefrustration.com>
|
Conditional format
Dear All
I, create conditional format related to one column data range showing the
staff ID, I want when I enter the staff ID if it is available in my data
range, it will apply my conditional format, so my formula it is working for
ID Like 1070, or 1470 But when I inter ID like B1101 It is not working, my
formula in conditional format like this =VLOOKUP(A1,$K$2:$K$65,1,FALSE) >
Please Help
Thanks
|
3/8/2010 7:30:01 AM
|
1
|
=?Utf-8?B?WW91c29mdA==?= <Yous...@discussions.microsoft.com>
|
Problem with Auto fill
I am using Excel 2003 and W XP.
I have the height of my rows at 12.75. Some rows are larger because
data in a cell on those rows needs 2 lines. When I am entering data
in a row that is only 12.75 high and I type a couple of characters
Auto Fill kicks in and shows me the entire contents for the cell. I
then hit Enter and Auto Fill completes. The problem is that even
though the data is only 1 line in length the height of the row is
doubled to 25.5. I do not want this to happen, how can I stop it?
This also happens if the data I want is in the cell above mine and
that cell is only 12.75
|
3/8/2010 1:30:47 AM
|
3
|
trvlnmny <trvln...@yahoo.com>
|
Organizing rating scale information into a narrative paragraph
I have teachers complete a teacher rating scale with four colums. The first
3 columns are: above average, average, below average. The fourth column is a
descriptor for a behavior (completing homework). There are about 20 rows of
behaviors. Question: I would like for all behaviors rated 'below average' to
automatically move from the rating scale to a narrative paragraph such as:
The teacher rated the student 'below average' in the following behaviors:
completing homework, [then all other behaviors rated below average followed
with a comma and the narrative paragraph ending in
|
3/7/2010 8:14:01 PM
|
1
|
=?Utf-8?B?Tm9q?= <...@discussions.microsoft.com>
|
Create a button with a macro vba
I'm trying to create a button with a macro vba.
I have a button that show a form in a sheet, when the user fill the
form and click submit the macro receives data from AS400 and create
some sheets, one every agent. I'd like to have a button in every sheet
for call the inizial form!
Have somebody a sample or a link where I can see?
Thanks
|
3/7/2010 7:53:52 PM
|
0
|
franco monte <mont...@gmail.com>
|
Formula in a coloum
I have this code
UltimaRiga = Range("A65356").End(xlUp).Row
For i = 3 To UltimaRiga
Range("G" & i).Value = (Range("D" & i).Value - Range("I" &
i).Value)
Range("G" & i).NumberFormat = "0_ ;[Red]-0 "
Next i
but I think is better (faster) without loop, is it possible?
Thanks in advance!
|
3/7/2010 4:43:29 PM
|
8
|
franco monte <mont...@gmail.com>
|
Formulas
How do I create a formula that would alow me to select a value in one cell
and subtract it from a value I enter in another cell.
IE a product with 3 versions cost me 1.00, 2.00 or 3.00 depending on the
version
I want to create a forumla that alows me to select one of the build costs
then enter a selling price in another cell and the 3rd cell would subtract
the value of the build cost from the sales price and give me my margin.
|
3/6/2010 7:17:02 PM
|
2
|
=?Utf-8?B?Q3BpcnQ=?= <Cp...@discussions.microsoft.com>
|
How can I change worksheet direction from right to left
I want to change the direction of the work sheet in Excel 2007 from left to
right and vice versa
|
3/6/2010 6:12:01 PM
|
2
|
=?Utf-8?B?SGFpdGhhbQ==?= <Hait...@discussions.microsoft.com>
|
Excel: Combine contents from identical cells on multiple sheets.
How do you combine contents from indentical cells on multiple sheets into one
cell on a different sheet? I am working on a work schedule for partime
workers who will each have a sheet assigned to them to enter their name in a
cell next to the days they can work. I want their names to then appear in a
master calendar in list form under the date they can work for that month.
|
3/6/2010 4:48:01 PM
|
1
|
=?Utf-8?B?TWlsYW4=?= <Mi...@discussions.microsoft.com>
|
copying/sorting data with blank spaces in between?
I have a membership list I need to update for a club. I have used Excel very
little.
I have been trying some different things to see if this will work before I
get the data file (which I will back up before hand)
In 3 columns to the right it has year dates in them. I need to change them.
depending on the person, the first column would all be the same changed from
2007 to 2008. The problem is, there are spaces between some of those
particular columns. (see below) when I try to highlight them individually and
past, say 2008, it will not allow me. Is their a way to do this? It says I
|
3/6/2010 4:11:01 PM
|
1
|
=?Utf-8?B?YnJ1Y2VmbA==?= <bruc...@discussions.microsoft.com>
|
Data change as scrolling
Hi,
Just been told how to use Freeze pane option so my days of the week scroll
down the worksheet. My A column has the months in it. I.E I have January in
A1 and April in A10. B1, B2 etc has the days of the week. How do I get the A1
cell to change to a different month as the row scroll down to it? Thanks
|
3/6/2010 10:27:01 AM
|
2
|
=?Utf-8?B?U21pZmZpZTcy?= <Smiffi...@discussions.microsoft.com>
|
Floating Column
Hi,
I'm making a speadsheet of my shifts over the next year. I've put the days
at the top but would like the column to scroll down with the page. How do you
do this? Thanks
|
3/6/2010 9:48:01 AM
|
2
|
=?Utf-8?B?U21pZmZpZTcy?= <Smiffi...@discussions.microsoft.com>
|
Cells in spreadsheet are in edit mode.
Hi All,
Whenever i open up a spreadsheet, if i select any cell it appears in edit
mode, also all the icons in on the tool bar are inactive. As per my
understanding only if i double click on particular cell then it should be in
edit mode. Please help me get this....
Thanks in advance
Ganesh
|
3/5/2010 8:23:15 PM
|
0
|
=?Utf-8?B?R2FuZXNo?= <Gan...@discussions.microsoft.com>
|
printing excel 2003 spread sheet
i need to know how i can print my spread sheet it has several rows and colums
and i was all the information to appear as it does on the spread sheet with
the borders incuded how do i do this. i tried print preview and it shows the
information on two pages and with no borders
|
3/5/2010 7:26:11 PM
|
1
|
=?Utf-8?B?dG1tNTg5OQ==?= <tmm5...@discussions.microsoft.com>
|
VBA copy cell to another worksheet
Hello, I am trying to copy text information from one worksheet to
another.
I open only the first sheet then I have a comand button by where I
want to say transfer the values.
La macro give an error at ObjWorshett.Cells(Riga, 1).text =
oDO.GetText
Errore di run-time '1004'.
Errore definito dall'applicazione o dall'oggetto.
Thanks in advance!
Franco
Dim oDO As New DataObject
oDO.SetText [B2].Value
oDO.PutInClipboard
Dim ObjWorshett As Worksheet
Dim strNomeFile As String
strNomeFile = "\\srv01\Dp\ANTONELLA\sblocco.xls"
Set ObjWorshett = Application.Workbooks.Open(strN
|
3/5/2010 5:02:44 PM
|
5
|
franco monte <mont...@gmail.com>
|
Reverse naming of file
Hi,
I'm copying data relating to an engineered part into a sheet.
The format is constant and the name of the client and part appear in
specified cells. Is it possible now to rename the xls file as
(constant+ partname)? I mean automatically, not cutting and pasting.
thanks
|
3/5/2010 4:05:17 PM
|
2
|
kenppy <a...@anon.com>
|
Converting string to number
hi,
I have a set of data that is to be cut and pasted from an external
source.
A typical cell reads '32813.58 sq mm', without the speech marks.
The cell could be formatted before the pasting; but how do I strip off
the units to leave the number only? The number could be any size.
thanks
|
3/5/2010 1:48:32 PM
|
9
|
kenppy <a...@anon.com>
|
Keys to access the tabs and commands on the screen
The problem I’ve got is that I activated them (don't know even how) and it
appear on my ribbon the keys not just when I press ALT but also (end this is
the main problem) when I press the button ?.
How can I deactivated all those and be free to work with the keyboard
without activating the ribbon pressing some button?
Cheers,
|
3/5/2010 11:31:02 AM
|
0
|
=?Utf-8?B?THU=?= <...@discussions.microsoft.com>
|
Insert Comments on a Protected Worksheet
hi - I have a worksheet with areas that are locked, and a range B5:H23 that
is not locked. Protection has been applied to the sheet. The user is
allowed to SELECT unlocked cells.
My problem is that I want to be able to INSERT COMMENTS in the unlocked
range. I can't seem to do this while protection is ON. (Comments can only
be added when Protection is OFF) What am I missing?
thanks in advance
--
cinnie
|
3/4/2010 11:28:02 PM
|
1
|
=?Utf-8?B?Y2lubmll?= <cin...@discussions.microsoft.com>
|
could someone write me a VB code? thanks
hi, i have 2 cells, V17 and X25, these cells get values in them depending on
what is entered into on other cells, no data is directly entered into these
cells. Is it possible to have the values that appear in these cells captured
and put into a list on a sheet called 'graphs'? below is what the 'graphs'
sheet would look like.
A B
2 7
3 6
1 3
4 9
5 3
--
thanks for your help
|
3/4/2010 9:49:01 PM
|
6
|
=?Utf-8?B?TW9yZ2Fu?= <Mor...@discussions.microsoft.com>
|
Change format to mm dd yyyy hh mm ss
I am currently trying to convert my cells from this format 11/9/2009
08:26:21:523 to just mm dd yyyy hh mm ss, format. if anyone knows how to do
this, Your Help would be greatly appreciated.
|
3/4/2010 7:49:01 PM
|
1
|
=?Utf-8?B?VGhvbWFz?= <Tho...@discussions.microsoft.com>
|
Database fields in Excel?
I have an order sheet system set up in Word which uses merge fields in tables
to fill in store names, dates, etc. The "database" linked to the tables is
an Excel sheet which I update manually each week.
On every page, below each table, is an OLE spreadsheet from Excel which has
the actual items on the order form.
I'm wondering if I can "eliminate the middle man" and just put the merge
fields into the OLE sheet. Is it possible to insert merge fields into an
Excel sheet and link one sheet to another?
|
3/4/2010 7:27:02 PM
|
0
|
=?Utf-8?B?SmFtZXMwMDA3?= <James0...@discussions.microsoft.com>
|
Count with formatting
Hi,
I have used to styles which are pre-defined in office 2010 :) one of them is
greeny one named Good and yellowish one named Note.
I would like to count the rows styled/formatted with these ones.
I want to spesify the range( lets say $E1:$E256) then want to see
how many cells are formatted with Good style or Note Style.
thank you in advance
|
3/4/2010 3:40:04 PM
|
1
|
=?Utf-8?B?bW5z?= <...@discussions.microsoft.com>
|
How do I delete a "function" from a cell in MS Excel?
When I type a number into a cell, and move on, the number inside the cell
turns to "###". I just want the number to appear in the cell without any
functions.
|
3/4/2010 2:20:01 PM
|
2
|
=?Utf-8?B?Q2hyaXM=?= <Ch...@discussions.microsoft.com>
|
Formula
What is a formula?
|
3/4/2010 3:30:01 AM
|
2
|
=?Utf-8?B?cmVteTUzMjM=?= <remy5...@discussions.microsoft.com>
|
Excel View
When I am using Excel I can not see my fill colors in Normal View. I can hit
print preview and see the fill colors and the doc will print correctly,
however I would like to see my fill colors as I am creating my spreadsheet.
How do I get the program to do this?
|
3/3/2010 11:34:02 PM
|
1
|
=?Utf-8?B?aXBob25lYWRkaWN0?= <iphoneadd...@discussions.microsoft.com>
|
test
--
George
|
3/3/2010 5:30:03 PM
|
0
|
=?Utf-8?B?Z2Vvcmdl?= <geo...@discussions.microsoft.com>
|
Workbook back up
Hi,
Is there a way to have excel create a backup file saved somewhere each time
the workbook is either opened or closed? I know there is the auto recover but
it doesn't really save a back up file that I could open when ever I need to.
Thanks,
|
3/3/2010 1:17:01 PM
|
2
|
=?Utf-8?B?QXJpcw==?= <A...@discussions.microsoft.com>
|
get Cell to not display ( $ - )
hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they display ($ -) and so i have those symblos everywhere and would like the
cell just to be blank and then show up with the dollar sign when a value
appears in it.
Any ideas?
thanks
|
3/2/2010 11:08:03 PM
|
3
|
=?Utf-8?B?TW9yZ2Fu?= <Mor...@discussions.microsoft.com>
|
Column widths change with each new import from Access 2007
I am using an invoice template I designed that pulls records from an Access
2007 query. The number of records imported changes each time the template is
used for a new workbook. I've managed at last to get the results I want from
the import, but the column widths for the data changes each time to widths
other than what I'd saved them as. It is totally screwing up the formatting I
want for the worksheet. How can I lock the widths of these columns at what I
want them, regardless of what data is imported?
|
3/2/2010 6:18:01 PM
|
0
|
=?Utf-8?B?bWhteWVyczQwMjQx?= <mhmyers40...@discussions.microsoft.com>
|
Count Cells with alphanumeric data
Hi,
I'm just trying to count the cells in a range that have alphanumeric data.
example: asd, we, rty, 22r, 45aa, 1s, wer, tyu.
I need to count all cells in that range that have numbers.
|
3/2/2010 5:09:02 PM
|
8
|
=?Utf-8?B?QXJpcw==?= <A...@discussions.microsoft.com>
|
Save as Template
I have a workbook which I would like to save as a template but can't find
how to do this in Excel 2007. Can anyone help, please?
|
3/2/2010 11:11:47 AM
|
2
|
"janey" <ja...@newsgroup.microsoft.com>
|
Sort list
I have a table which I need to sort, e.g.:
2000
2039B
2026
2167
2239
2242
When I run Sort, I get
2000
2026
2167
2239
2242
2039B
Why does 2039B come at the bottom rather than between 2026 and 2167?
|
3/2/2010 11:09:36 AM
|
2
|
"janey" <ja...@newsgroup.microsoft.com>
|
incremental counting?????
I am workinging on an .xls spreadsheet with this numbering scheme in Column A.
1
1.1
1.1.1
1.1.1.1
1.1.1.2
1.1.1.3
1.1.1.4
1.1.1.5
1.1.1.6
1.1.1.7
1.1.1.8
1.1.1.9
1.1.1.10
1.1.1.11
how do I get the fourth node to increment on its own, i.e. 12,13,14, once I
add data to the next cell over or column B.
|
3/1/2010 4:59:01 PM
|
2
|
=?Utf-8?B?U0JvZXJz?= <SBo...@discussions.microsoft.com>
|
I do not want to allow third party cookies. I want to learn tips
Is there a different way to get the extra tips and trips without allowing
third party cookies.
|
2/28/2010 5:05:01 PM
|
2
|
=?Utf-8?B?S2F0aGxlZW4gRA==?= <Kathleen ...@discussions.microsoft.com>
|
Using the "if" function, the "and" function and the "or" function
I am not sure if or how to use all three in a formula. For example:
=if(b2="red", and c3="blue", d6="green")
if that makes sense at all.
|
2/28/2010 12:56:01 AM
|
1
|
=?Utf-8?B?U3VwZXJibG9uZGU2NA==?= <Superblond...@discussions.microsoft.com>
|
Excel 2007 Compatibility Mode
I am working in a file, it is in Compatibility Mode. I want to "Convert" it
to a full Excel xlsx file. I have done SaveAs|Excel Workbook and it stays
in Compatibility Mode.
Help tells me to select Convert on the Office button menu. There is no
Convert command on that menu. I search the Excel Options screens and couldnt
find a setting turn it on. I may have missed it????
How do I activate Convert on the Office button menu or at the very least get
the file into a mode where all the new features are in place?
Thanks
Marsh
|
2/26/2010 4:57:01 PM
|
1
|
=?Utf-8?B?TWFyc2g=?= <Ma...@discussions.microsoft.com>
|
MS Excel 2003 - Advanced Features Add-In
The Advanced Features Team is pleased to announce the release of the
first version of their Add-In for MS Excel 2003.
Part of this realease are the following functionalities:
* Easy and powerful connection between MS Excel and MS Access
* K-Means clustering algorythm
* Additional User Defined Formulas
* Deeper Query and Pivot Tables Manipulation Tools, including easy
redirecting MS Olap cubes and Database Queries
* Fast and Easy Worksheet Formatting and Management, including
functions for Hiding and Grouping, changing worksheet visibility, get
available workshee
|
2/25/2010 1:11:29 PM
|
4
|
RobinRoot <emiliano.ma...@gmail.com>
|
number
the error is :"the number in this cell is formatted as text or preceded by an
astrophe", It means we must convert it to number and we can do, but I don't
want this error appear in other excel file again.How can I do?
|
2/25/2010 11:50:04 AM
|
1
|
=?Utf-8?B?aHVuZ2F5dW4=?= <hunga...@discussions.microsoft.com>
|
sumif
I need to add the total in cell H6 if the following condition is met
If H6<>0 and A6 contains the word "total" (where A6 can contain alpha
and numbers) i.e. the formula must only find the total if a6 contains
the word "total" and not if it simpy contains other figures or alpha
is this possible?
--
Barny
|
2/25/2010 10:42:09 AM
|
4
|
Barny <Barny.5cc3...@excelbanter.com>
|
Is it possible to use a formula in the middle of a sentence in exc
If so, how?
|
2/25/2010 4:21:01 AM
|
1
|
=?Utf-8?B?a3Jpc3N5?= <kri...@discussions.microsoft.com>
|
copy row to different tab
Creating a SS with 6 tabs(master,A,B,C,D,E) each having 5
columns(doc#,category,date,box,folder).
"Category" can have 5 different values, A,B,C,D,E
According to which value in 'category' is entered in master I want to copy
the row and move it to corresponding tab.
Can an IF statement do this?
thanks,
L.
|
2/24/2010 6:46:11 PM
|
7
|
"L.S." <notg...@yahooie.com>
|
Worksheet printing
Can I set sections in a worksheet? I have a Job Record to keep track of all
labor / equipment and materials per Job in worksheets.
The problem I am having is when I print the worksheet I print the entire
worksheet, sometimes 5-6 pages and really only have data I need on 2 of them.
I know I can set print areas, but it is not always the same areas I need, and
I have to set that every time I print.
I guess what I am trying to do is make sections - and just print that
section if possible. Or if there is any other suggestions, that would be
great as well.
Any other suggestions
|
2/24/2010 6:44:01 PM
|
2
|
=?Utf-8?B?dGI=?= <...@discussions.microsoft.com>
|
in xcell, how do I select on 1 cell? my cursor selects multiples
While this problem doesn't always occur, it causes me problem when for some
reason while working in a spreadsheet, it starts pickup up multiple cells
whenever I move around with the cursor.
|
2/24/2010 4:13:01 PM
|
1
|
=?Utf-8?B?RHdpZ3RodCBMIEhvbG9iYXVnaA==?= <Dwigtht L Holoba...@discussions.microsoft.com>
|
Functions
Hi, I am new to Excel 2007 and have done all the 'training' offered on the
Microsoft website.
I am now interested in learning about the different functions. I have been
reading the posts on here, especially the ones asking about formulas.
As I don't find the Excel Help files very easy to understand, can anyone
recommend a website which explains things clearly, like "$" "!", etc.
Thanks.
|
2/24/2010 8:30:42 AM
|
4
|
"janey" <ja...@newsgroup.microsoft.com>
|
one code to do multiple things
hi, i have the code below which takes the value in cell U17 everytime it
changes, and places it in column A on a sheet called graphs thereby forming a
list down the sheet of all the values that appear in cell U17, for charting
purposes.
What i would like to do is to be able to duplicate this for different cells.
ie have the cell values of W25 appear in a list in column K on the graphs
sheet, and so on. this code was written for me by someone else as, could you
please give me some code that will enable me to capture the values for two or
three cells in sheet1 into the sheet cal
|
2/24/2010 7:09:01 AM
|
4
|
=?Utf-8?B?TW9yZ2Fu?= <Mor...@discussions.microsoft.com>
|
open excel file
i have problem with a excel file. the file is not to big. its has 5 tabs
only. and when i click on to one of the "tabs" the excel gives me a error
message as "not reponding". and this happens with this particular tab only.
any help
|
2/24/2010 6:23:01 AM
|
2
|
=?Utf-8?B?Um9oaXQ=?= <Ro...@discussions.microsoft.com>
|
How to apply Macro on a same type of format but columns no. r chan
HI,
First of all i 'd like to explain what problem i'm facing.
See i've data in three Rows and three Columns.
I've recorded macro & i applied the same macro in same formation.
like three Rows & Three coloumns.
But the question here is now i've Five Rows & Five coloums. Now if i apply
the same macro here then it overrides the data over three rows and coloumns.
Please let me know can i do apply the same macro because the formation is
same only data is in more no.
Looking forward to hearing form you.
Thanks,
Manmohan Singh
|
2/24/2010 6:02:01 AM
|
1
|
=?Utf-8?B?TWFubW9oYW4gU2luZ2g=?= <ManmohanSi...@discussions.microsoft.com>
|
ignoring text data in a cell when summing values in the same cell
I have entered text in cells along with a numerical value as a note pertainig
to the values example, "2 - exist". Is there a way to tell Excell to ignore
the text data in order to sum the values..do you place the text in brackets
or parathesis or something similar?
--
FM
|
2/23/2010 10:51:02 PM
|
2
|
=?Utf-8?B?Rk0=?= <...@discussions.microsoft.com>
|
IF/ISBLANK formula
When using this formula =IF(ISBLANK(B2,"",VLOOKUP(B2,D2:E20,2,1)) I am
getting the #N/A error or incorrect data if the value in cell B2 starts with
a 0 eg 07934.
Any suggestions as to fix this?
Thanks
|
2/23/2010 9:50:10 PM
|
3
|
=?Utf-8?B?TWlzc2lsZQ==?= <Miss...@discussions.microsoft.com>
|
how do you flip a column containing different text in each cell
column contains from top to bottom: A,B,C,D,E
and i want a column conatining after flip: E,D,C,B,A
|
2/23/2010 2:36:01 PM
|
4
|
=?Utf-8?B?Y3liZXJtaXg=?= <cyber...@discussions.microsoft.com>
|
Constant required
Hi,
I have two sheets 'cost' and 'materials' on which the constants are
placed
A cell on 'cost' has this formula =C9*materials!D37
I now need to copy this down any number of times, the first repeat reads
=C10*materials!D38, whereas I want it to read =C10*materials!D37
I've tried this =C9*materials!$D37 but get =C10*materials!$D38
How do I keep the cells not increasing?
thanks.
|
2/23/2010 10:47:05 AM
|
4
|
Ken Poberezny <a...@anon.com>
|
pivot table
Hi
i have a pivot table and i have extracted data from another file.
Now i want to hide details of those numbers. that is when i double click it
gives me the full detail of the number. eg names, location etc etc.
i have send my file to other users but i dont want them to know all these
personal deatils.
any help
Thanks
|
2/23/2010 1:09:01 AM
|
3
|
=?Utf-8?B?Um9oaXQ=?= <Ro...@discussions.microsoft.com>
|
importing text as a URL
hi all,
I need to import a csv file where every row has an URL such as
.....,http://www.something.something,....,.....
When I import it the URL is considered as text by Excel, i.e. no
hyperlink is automatically created.
How do I tell excel to create the hyperlink when importing?
thanks
|
2/22/2010 9:07:07 PM
|
1
|
mariob <...@ma.b>
|
vb macro format is wrong
I am using Excel 2007. I have a question. I recorded a macro which enters in
A1 the value 1
B1 the value 2
C1 the value 3
the code looks like this.
Sub Macro2()
+OnAction <= VB_VarUserMemId1VB_VarUserMemId
Range& VB_VarUserMemIdB1VB_VarUserMemId '+AxisGroup
+OnAction <= VB_VarUserMemId2VB_VarUserMemId
Range& VB_VarUserMemIdC1VB_VarUserMemId '+AxisGroup
+OnAction <= VB_VarUserMemId3VB_VarUserMemId
Range& VB_VarUserMemIdD1VB_VarUserMemId '+AxisGroup
End Sub
I thought it should be this kind of format--ish
ActiveCell.FormulaR1C1 = "1)"
Range("B1").
|
2/22/2010 8:45:02 PM
|
5
|
=?Utf-8?B?d2hhdCB3aGljaCBpcyB1cA==?= <what which is ...@discussions.microsoft.com>
|
Sum of product
I am trying to find a formula to total a specific product from a list into
another worksheet for totals.
Can i use a LOOKUP formula to look for that specific product and give me
totals for the year in another worksheet?
Thanks;
|
2/22/2010 6:01:01 PM
|
2
|
=?Utf-8?B?dGI=?= <...@discussions.microsoft.com>
|
how to stop data shifting into new cells every time workbook is o.
Some of my Data remains the same in my workbook but then columns H- shifts
into different cells after I've saved the sheet and then I reopen to work in
it again.
|
2/22/2010 3:57:01 PM
|
1
|
=?Utf-8?B?SmFuZSBH?= <Jane ...@discussions.microsoft.com>
|
help with inputting code
hi there,
i have some code (below) that takes the value of cell U17 every time it
changes and then lists it in a column on the 'graphs' sheet for charting
purposes. i would like to duplicate this code for another cell W25 having it
form a list on the 'graphs' sheet in column K, when i copied the code below
then pasted it into VB and amended the values it came up with a compile error
:(
it must be something simple that i'm doing wrong, any ideas?
Private Sub Worksheet_Calculate()
Dim Dest As Range
With Sheets("graphs")
Set Dest = .Range("A" & Rows.Count).End
|
2/22/2010 6:18:01 AM
|
3
|
=?Utf-8?B?TW9yZ2Fu?= <Mor...@discussions.microsoft.com>
|
column heading label
The column label heading has change from an ABC format, to 123 format just
like the row format of 123 rows. I am not sure if I changed this setting how
I did it or how to change it back to column A, B, C, ect. from 1, 2, 3, ect.
Thanks for the help,
Ron
|
2/22/2010 4:41:01 AM
|
1
|
=?Utf-8?B?Um9u?= <...@discussions.microsoft.com>
|
Delete worksheets in Office Excell 2007?
How can I delete worksheets in Office Excell 2007?
|
2/21/2010 8:56:01 PM
|
1
|
=?Utf-8?B?VHdlZXR5IEJpcmQ=?= <Tweety B...@discussions.microsoft.com>
|
VLOOKUP Range_lookup TRUE
Why don't my tests work?
http://img716.imageshack.us/img716/4035/vlookuptest.gif
http://img525.imageshack.us/img525/5245/vlookuptest2.gif
|
2/21/2010 8:14:28 AM
|
6
|
Pekka Numminen <p.nummi...@suomi24.fi>
|
Sum and If
I am wanting to add numbers in Column B,d,f etc only if it equals the text in
Column A,c,e etc
--
Shirl, NZ
|
2/21/2010 2:52:01 AM
|
4
|
=?Utf-8?B?U2hpcmw=?= <Sh...@discussions.microsoft.com>
|
Column Sorting
I am using W XP & Excel 2003. I would like to know if there is a way
to sort on more than 3 columns? If so how is it done?
Thanks for the help.
|
2/21/2010 12:59:16 AM
|
1
|
trvlnmny <trvln...@yahoo.com>
|
How does "Search For" By or Subject work?
(This is a question about how to use the Forum; not how to use Excel. I know
it doesn't belong here. Please accept my apologies. I can't find any other
place to ask it and the Contact link at the bottom of the page appears to be
broken.)
The Help for the Forum says that Search For searchs the By and Subject
fields as well as the message bodies. I can't figure out how to search the By
and Subject fields. For example, I entered my first post on 2/19/2010 in the
Excel General Questions forum. My user id is "SVanDee". The Subject is "2007
Structured Reference auto-completion not w
|
2/21/2010 12:03:01 AM
|
4
|
=?Utf-8?B?U1ZhbkRlZQ==?= <SVan...@discussions.microsoft.com>
|
Visual Basics Error - Goto
Please help. I keep getting an error from my visual basics code. Click on a
button on a sheet takes you to another sheet within the same workbook then
directly to specific cells. Don't know whats wrong with the code.
Private Sub CommandButton1_Click()
Application.Goto ActiveWorkbook.Sheets("WGTN & KAPITI").Activate
ActiveSheet.Range("Garry").Activate
End Sub
--
Shirl, NZ
|
2/20/2010 9:55:01 PM
|
1
|
=?Utf-8?B?U2hpcmw=?= <Sh...@discussions.microsoft.com>
|
Making actual projects with Excel 2007
I have read several books and so far have basic and general understanding of
the mostly use features of Excel 2007.
However, I am wondering if there are resources that can help me do actual
projects.
I learn quickly by doing practical stuff rather then reading a 1000 page
book about features and why I should use a certain program.
Were can I find tutorials on actual projects? Example: How to make a spread
sheet for a grocery store.
Any ideas or recommendation will be highly appreciated.
Thanks everyone.
Ai
|
2/20/2010 8:10:01 PM
|
1
|
=?Utf-8?B?QWk=?= <...@discussions.microsoft.com>
|
How to hide a vaue
I am trying to hide a value of 351 in a cell until the 351 is used in a
calculation. How do I do this. Example:
b3 is 351 I would like to subtract b2 which is 345 and show the sum of 6 in
b3. Until I fill b2 with a value, b3 is showing 351. I want to hide the 351
until the value is calculated.
|
2/20/2010 3:45:01 PM
|
1
|
=?Utf-8?B?QmlsbCBC?= <Bi...@discussions.microsoft.com>
|
how do i use the daye function to insert a serial number
how do i use the date function to insert a formula that inserts a serial
number for a specific date
|
2/20/2010 2:17:01 PM
|
2
|
=?Utf-8?B?c3RlcGhhbmlleWxhbG8=?= <stephanieyl...@discussions.microsoft.com>
|
OR within Criteria of SUMIF
Is it possible to use the logical function OR within the "Criteria"
argument of SUMIF? If so, how?
|
2/20/2010 12:28:19 PM
|
2
|
Pekka Numminen <p.nummi...@suomi24.fi>
|
just need to display formulas nothing appears
I am a student and it says to display the cell formulas in the worksheet. I
have tried EVERYTHING and can't figure it out??? Please help
|
2/20/2010 5:27:01 AM
|
3
|
=?Utf-8?B?U2lzc3k4MQ==?= <Siss...@discussions.microsoft.com>
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 09625
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M
Pre�o: R$ 1900.00
Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar!
Audi a3 automatico
Audi a3 1.8 t automatico
Audi a3 1.8 turbo automatico
VW Golf gti automatico
VW Golf 2.0 automatico
VW Golf 1.8 turbo auto
|
2/20/2010 3:08:00 AM
|
0
|
kit solenoites audi solenoid.chicote<kit.solenoites.a...@solenoid.chicote.com>
|
Excel 2007 won't print spreadsheet
New HP computer with Win 7 and MS Office 2007. Printer is Dell V505, and I
have installed correct printer driver for Win 7 and the Dell prints
everything OK until I tried Excel 2007 spreadsheet which the Dell will not
print. I get error note (no message) in Start/Control Panel/Printers. Is a
special printer setup needed for Excel 2007? Hope you can help.
Thanks...
|
2/20/2010 12:23:01 AM
|
1
|
=?Utf-8?B?TWFjOTk=?= <Ma...@discussions.microsoft.com>
|
Excel 2003 Drop Down Box
I am attempting to create a drop down box in Excel, I have created a list in
a separate range but when I copy that range, it isn't the same in the Drop
Down box. Sounds like a formatting issue, but I can't seem to get the
correct symbols in my drop down box. help!
|
2/19/2010 3:51:02 PM
|
2
|
=?Utf-8?B?QnJvb2tseW4=?= <Brook...@discussions.microsoft.com>
|
Where is Excel 2007 on my computer?
I use Excel and Word 2003. My new computer -- new about six months
ago -- came with MS Office 2007 pre-installed and I activated it.
However, I never use the 2007 tools -- Word, Excel, etc. -- I find
them too confusing and the 2003 versions work for me.
A friend sent me a database in xlsx format, or something like that.
When I clicked on OPEN, it opened in Excel 2007.
However, I can't find an Excel 2007 icon anywhere on my computer.
I tried Start->All programs and looked in every folder -- no Excel
2007 icon.
Used Windows Explorer and went to c:\Program Files -- nothing fo
|
2/19/2010 1:18:32 AM
|
3
|
Kickin' Ass and Takin' Names <PopUlist...@hotmail.com>
|
Excel 2003, Auto Filter Help!
I have a 21,000 row XML file that I pull into Excel every morning:
Data / Import Data / Select Data Source / OK ...and all is well
....until I updated to a new PC and had to reload Excel. Now I get
autofilters at the top of each column, and it won't load all the data.
I know I can go in AFTER I load and uncheck Data / filter / autofilter
and it will remove the filter queues on the top row, but I DON'T know
how to set up an option where it will not format with auto filters
from the get-go. ...so I can load this data completely.
What am I missing here?! Thanks!
- Hu -
|
2/18/2010 2:49:43 PM
|
0
|
...@zippy.com
|
find&press button
Hi everybody,
i'm using excel 2007,when i press the find&select button it dosen't sow me
the cell i'm looking for,it has been disabled,although when i look the rows
one by one i can find it,how can i able the find&select.
i'd appreciate if u'd let me know,cuz i'm in trouble here
|
2/18/2010 11:39:01 AM
|
1
|
=?Utf-8?B?QWxleA==?= <A...@discussions.microsoft.com>
|
DESCARGAS - ANTIVIRUS GRATIS 7743
Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
http://antivirus-gratis-descarga.blogspot.com/
Links de contenido del sitio web:
http://antivirus-gratis-descarga.blogspot.com/
http://antivirus-gratis-descarga.blogspot.com/2009/08/que-es-un-antivirus.html
http://antivirus-gratis-descarga.blogspot.com/2009/08/descarga-gratuita-de-antivirus.html
http://antivirus-gratis-descarga.blogspot.com/2009/0
|
2/18/2010 10:46:10 AM
|
0
|
=?Utf-8?B?YW50aXZpcnVzIGdyYXRpcw==?= <antivirusgra...@discussions.microsoft.com>
|
HOW DO I CHANGE THE COLOR OF THE EXCEL SPLIT LINE
HOW DO I CHANGE THE COLOR OF THE EXCEL SPLIT LINE
|
2/17/2010 10:09:02 PM
|
0
|
=?Utf-8?B?SklNMTIz?= <JIM...@discussions.microsoft.com>
|
Variable Frame Reference
I am in the process of creating a very large excel spreadsheet and am
hoping to find a workaround. My intermediate excel skills have let me
down!
Here is what I'd like to do. In the first worksheet "Sheet 1" I have
a list of users and corresponding data. I have a subsequent worksheet
for each user. What I'd like to be able to do is have the number of
the row change based upon the new worksheet. In other words, I'd like
to have Cell A1 in Sheet 2 reference Cell A2 in Sheet 1, Cell A1 in
Sheet 3 reference Cell A3 in Sheet 1, Cell A1 in Sheet 4 reference
Cell A4 in Sheet 1, and so
|
2/17/2010 8:24:55 PM
|
1
|
Branden Durst <durs...@gmail.com>
|
How do I convert text to "proper text"?
I am trying to convert the text from all caps to Caps and lower case better
known as proper text. I used the functions tab and then the formula auditing
box and then select show formula. After that I am lost. Please help
Thanks
Sunny
|
2/17/2010 8:18:01 PM
|
1
|
=?Utf-8?B?U3Vubnk=?= <Su...@discussions.microsoft.com>
|
Display ranges in a Pivot
Hi all,
I have a column called IncomeRange. I need to display the value in ranges
like 0 - 100, 101-200 etc., How can I convert a column in a pivot report to
display as ranges? Is this an option or do I need to do some kind of formulas
or macros?
Thanks for all help
|
2/17/2010 4:27:03 PM
|
3
|
=?Utf-8?B?TmV0TmV3Ymll?= <NetNew...@discussions.microsoft.com>
|