A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Print to file by DavidA
Excel won't let me print. When I try to print, it automatically comes up with "Print to file" and when I press cancel, it cancels everything. Print to file...
March 17th, 2010 08:42 PM
by Billns Go to last post
5 78
Excel merging and automatic edit of worksheets by Moonie66
I am a teacher in a department of 3. We all keep records of the results our individual classes achieve on identical Excel worksheets. I need to be able to...
March 17th, 2010 08:36 PM
by Moonie66 Go to last post
0 92
Need transpose? help.... by Jethro Bodeene
I have a spreadsheet with 151 columns by 49 rows of data. I need to transpose this data from its current state, to only 1 vertical column. How can I do...
March 17th, 2010 08:35 PM
by Jethro Bodeene[_2_] Go to last post
9 114
Auto calculate by Barb H[_2_]
I am trying to find a formula that automatically calculates multiples of 32. if it is not a multiple of 32 then I wnat he cell to be blank. Any...
March 17th, 2010 08:01 PM
by Paul C Go to last post
1 148
How to combine data from 2 separate workbooks onto 1 worksheet by Kristen
I am planning a meeting for 100 attendees. Our database contains a unique ID for each attendee as well as their name, mailing address, phone number, etc. I...
March 17th, 2010 07:05 PM
by Iriemon Go to last post
2 197
negative time summation calculation for a standard day by Glamb
I am trying to use calculations with time in the form hh:mm - hh:mm and EXCEL does not like negative time. The calculation is to accumulat over a week the...
March 17th, 2010 06:57 PM
by Fred Smith[_4_] Go to last post
2 117
March 17th, 2010 06:55 PM
by Fred Smith[_4_] Go to last post
2 127
Access to a series, when it is assigned to an empty range by Werner Rohrmoser
Hello, I'd like to get access to a chart series via vba. This works fine with ActiveChart.SeriesCollection(1).Values = "='" & ActiveWorkbook.Name & "'!"...
March 17th, 2010 06:48 PM
by Werner Rohrmoser Go to last post
0 125
Add comment in protected worksheet by Suju Thomas
Can we add a comment for cells in a protected worksheet. I wanted to allow feature to only add comment and not allow user to do any other modifications
March 17th, 2010 06:26 PM
by trip_to_tokyo[_3_] Go to last post
3 188
Insert Picture by McCBeth
Can I insert a picture into a cell? How?
March 17th, 2010 06:20 PM
by Gord Dibben Go to last post
2 128
How do I recover the autosaved file? by et
I closed a file I had been working on for a while, without saving. Can I recover that altered file?
March 17th, 2010 06:13 PM
by Gord Dibben Go to last post
1 93
How do you search within a document? by Me2020
I am woundering how you search with in a saved document. I want to make a spread sheet for my buisness on my supplies, my cost, and my mark up cost but there...
March 17th, 2010 06:11 PM
by Gord Dibben Go to last post
2 94
Problem with subtotal function by Constance
I've noticed since changing to Excel 2003 that when I have a spreadsheet that I want to do multiple subtotals on that if I have one grouping within a group...
March 17th, 2010 05:57 PM
by Constance Go to last post
0 113
Excel 2007: Conditional Formatting and Ribbon Data by JJ[_2_]
I have several cells have conditional formatting equations which refer to a date value in cell H1 (for example). I want to be able to move the value stored on...
March 17th, 2010 05:54 PM
by JJ[_2_] Go to last post
0 102
Formulas by B.G. - Canada[_2_]
I want to enter the formula =IF(Data!D18="","",Data!D18). Is there any way to have the fomula automaticaly capture the reference Data in the next cells...
March 17th, 2010 05:34 PM
by Pete_UK Go to last post
2 87
text as value in pivot table by Gerardo
I need to show some references in de form of A11_A11_1a in a table, and with the order given by each section of the references. I tried using pivot tables...
March 17th, 2010 04:23 PM
by Gerardo Go to last post
0 110
Summing Cells with Text and Numbers by Trevor Little
Is it possible to use the Sumif function to add numbers with a specific designator in front of it? Eg. A row contains strings like: S8, S10, V5, S5 Is...
(Multi-page thread 1 2)
March 17th, 2010 03:32 PM
by Max Go to last post
11 186
Help needed with a formula for dates in excel 2007 by dloc
I need help with a formula for dates in excel 2007 If Pay Date is from the 1st to the 15th of the month then Remit Date would be the 25th of the same...
March 17th, 2010 03:04 PM
by dloc Go to last post
2 111
Auto filter sort ascending not working while sheet protected by TommyB
I have a sheet with a couple of columns that contain formulas, so I have protected those columns and left the rest of the sheet open for data entry. The...
March 17th, 2010 02:51 PM
by Dennis Tucker Go to last post
6 141
placing people into age groups based on their DOB by JSAUS
I am trying to classify people into age groups in Excel based on their DOB. U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to...
March 17th, 2010 02:42 PM
by JSAUS Go to last post
3 125
Post New Thread

Display Options
Showing threads 2041 to 2060 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.