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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Formula to subtract a negative amount by hrbsh97
I have a problem with my spreadsheet as I can't get it to subtract a number that is in the negative .. can someone please direct me as to what I am doing...
December 11th, 2008 02:15 PM
by stew Go to last post
2 80
ActiveX Controls by leerem
Hi all, everytime I place an ActiveX Control on my spreadsheet my calender function ceases to work. The calender appears as soon as I click on the...
December 11th, 2008 02:11 PM
by leerem Go to last post
0 104
Can you change the text displayed on the labels a Pivot Tables'creates for subtotals? by alan82
Hi all, does anybody know whether or not you can change the text a Pivot Table uses to label subtotals? You can change the title of a field using the 'field...
December 11th, 2008 01:16 PM
by alan82 Go to last post
0 102
XL2002 - Disable 'clear all' when protected by Trevor Williams
Hi All Is it possible to disable the 'clear' options from the Edit | Clear menu? Even when I lock the sheet and workbook the user can still use...
December 11th, 2008 12:35 PM
by Trevor Williams Go to last post
0 65
X marks the spot by BlueFeather
I need help. I want to put an X in cell A1 when i put an x it will put the number 100 in cell B1. if i dont put an X it will remail blank. Is this posiable?
December 11th, 2008 12:18 PM
by Gary''s Student Go to last post
2 86
How to merge two cells? by Tippo22
Hi, I can't seem to finde any formula that makes it possible for me to merge two cells. My problem is that i have two cells with a persons name and with his...
December 11th, 2008 11:26 AM
by Max Go to last post
3 100
VBA - Need macro to find optimal placement of rows in pairs by Kasper
Hi I could use some help in programming a macro that calculates the optimal placement of elements. I have 50 rows with data. Coloumn B has numbers ranging...
December 11th, 2008 10:22 AM
by Kasper Go to last post
1 94
Please Help, Need a Formula by Craig
Hi I have a spread sheet as per below: What I need is a formula to search for a fund code from the top and from the bottom, if they match I need the Gain/Loss...
December 11th, 2008 09:34 AM
by Max Go to last post
2 102
View two sheets alongside? by Terry Pinnell
In an Excel 2000 file (workbook?) I have several worksheets. How can I tile two of them vertically or horizontally please? I want to be able to view both...
December 11th, 2008 09:32 AM
by muddan madhu Go to last post
2 133
is that bug or feature - magic passwords for Excell 2003/2007 by Vit
Hi, I'm just wondering is that "feature" or "bug"? I've found two sets of magic password's combinations: try protect sheet with "en" and you're able to...
December 11th, 2008 08:50 AM
by JE McGimpsey Go to last post
1 92
IF function + a formula by Cindyt
I am trying to figure out how I can use the IF function to identify a word, such as "Home". If it is true, I need to do a formula on that line of...
December 11th, 2008 08:22 AM
by Rick Rothstein[_2_] Go to last post
4 90
VLOOKUP Help Needed by blucajun
I've been working on updating a spreadsheet off and on for the last two months and can't get my VLOOKUP to work properly. Last month I asked for help here...
December 11th, 2008 04:48 AM
by Herbert Seidenberg Go to last post
3 105
How to highlight the lowest valued cell in a column in Excel 2003 by mapesii
I want to highlight the the lowest value cell in a column. How do I do this? I want to highlight the cell only if one cell in the column has this value. Also...
December 11th, 2008 04:44 AM
by mapesii Go to last post
2 155
Find first period from the right by David P.
Find first period from the right How do I do that? -- David P.
December 11th, 2008 04:09 AM
by Ron Rosenfeld Go to last post
2 93
PivotTable Multiple Consolidaton Ranges in Excel 2007 by cfreemaniii
Available in Excel 2003 thru the Pivot Table wizard. How do you do this in Excel 2007?
December 11th, 2008 02:54 AM
by Herbert Seidenberg Go to last post
1 125
OLAP Pivot Table Calculations by Malinda
How can you add a column to an OLAP pivot table to show the difference between values in two columns. We need to show data for two different dates and then...
December 11th, 2008 02:51 AM
by Malinda Go to last post
4 113
December 11th, 2008 01:19 AM
by Steve Yandl[_2_] Go to last post
1 104
Grouping and outline to the left or above by Stonewall Rubberbow
In 2003, I could reverse the direction of a group to have the summary column/row appear to the left of the columns or above the rows, rather than the default...
December 11th, 2008 12:53 AM
by Stonewall Rubberbow Go to last post
0 88
Copy/paste from other application without delimiting it? by Jennifer
When I copy a paragraph from another application and try to paste it in a cell in Excel, it automatically delimits it. Does anyone know how to keep it from...
December 11th, 2008 12:49 AM
by Gord Dibben Go to last post
2 99
Building a shipping label program by Lost in excel
I want to build a template that when the user keys in a customer number, it fills in the template with the shipping address and allows them to ask how many...
December 11th, 2008 12:40 AM
by Gord Dibben Go to last post
1 94
Post New Thread


Display Options
Showing threads 29861 to 29880 of 139764
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 08:00 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.