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
Microsoft Excel Total Values by gp
I have multiple instances on my spreadsheet of the same part number that I am tracking. In the differernt lines I have the different quantities of the same...
March 18th, 2010 12:25 AM
by Ashish Mathur[_2_] Go to last post
2 160
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 09:42 PM
by Billns Go to last post
5 150
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 09:36 PM
by Moonie66 Go to last post
0 171
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 09:35 PM
by Jethro Bodeene[_2_] Go to last post
9 197
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 09:01 PM
by Paul C Go to last post
1 223
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 08:05 PM
by Iriemon Go to last post
2 273
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 07:57 PM
by Fred Smith[_4_] Go to last post
2 197
March 17th, 2010 07:55 PM
by Fred Smith[_4_] Go to last post
2 215
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 07:48 PM
by Werner Rohrmoser Go to last post
0 199
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 07:26 PM
by trip_to_tokyo[_3_] Go to last post
3 240
Insert Picture by McCBeth
Can I insert a picture into a cell? How?
March 17th, 2010 07:20 PM
by Gord Dibben Go to last post
2 194
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 07:13 PM
by Gord Dibben Go to last post
1 136
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 07:11 PM
by Gord Dibben Go to last post
2 131
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 06:57 PM
by Constance Go to last post
0 174
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 06:54 PM
by JJ[_2_] Go to last post
0 177
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 06:34 PM
by Pete_UK Go to last post
2 148
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 05:23 PM
by Gerardo Go to last post
0 171
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 04:32 PM
by Max Go to last post
11 286
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 04:04 PM
by dloc Go to last post
2 173
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 03:51 PM
by Dennis Tucker Go to last post
6 238
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 11:53 AM.


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