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
Referencing another worksheet by rmellison
I am using a text string to reference a block of cells in another worksheet. The text string is in a seperate cell, and I am using this string in a multitude...
(Multi-page thread 1 2)
September 15th, 2005 03:07 PM
by rmellison Go to last post
10 283
Superscript in custom format by Sloth
I have started to use custom formats to display units. For instance when I want a number to display as 24" or 58.2 lbf. I don't know if this is the proper...
September 15th, 2005 03:35 PM
by Sloth Go to last post
2 166
How do you write a T with a bar on it? by sheezyspearean
How do you write the notation for an average value? Sth like T with a bar on it. How do you get the bar on the T?
September 15th, 2005 03:43 PM
by Bernie Deitrick Go to last post
1 171
Summary of Data from a Range by Blobbies
I have a range of data, which is a weekly sports picking competition at work. Basically on the left it has the event, and along the top it has my...
September 15th, 2005 04:04 PM
by jeridbohmann Go to last post
3 197
Filter List by John Moore
I need to filter a list of data to be able to view each part and the customer for each part. The example below shows part 10P2345 appearing 4 times, with...
September 15th, 2005 04:04 PM
by Max Go to last post
3 167
Identical Name on multiple workbook pages by Peter Rooney
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when I get the answer to this, but here goes... I have a workbook containing a...
September 15th, 2005 04:28 PM
by Peter Rooney Go to last post
4 197
Footers/Headers in Excel by sls
Can I paste from Word to a custom header or footer in Excel?
September 15th, 2005 04:28 PM
by jeridbohmann Go to last post
1 124
Formula or UDF to add figures by code # by mikeburg
I have a list of figures in column A & each figure's 3 digit code in column B. What would be a cell formula that could be put in columns C & D to subtotal by...
September 15th, 2005 04:30 PM
by Max Go to last post
5 181
What is the shortcut for switching between worksheets? by DJALik
I would like to find out what is the shortcut for switching between worksheets in the same workbook
September 15th, 2005 04:55 PM
by Ellie Go to last post
1 184
how to calculate quarterly compounded interest in ms excel by Shreepad
How to calculate quarterly compounded interest on cumulative deposit with bank or company in ms excel
September 15th, 2005 04:59 PM
by David Billigmeier Go to last post
1 150
How do I stop Excel 2002 from autoformatting numbers into dates? by MyHeartPoursOn
When I type in a number such as "3/8" or "3-8", Excel automatically changes it to "08-Mar". I've tried changing the format of the cell to general, but that...
September 15th, 2005 05:01 PM
by Mike Go to last post
1 238
Lookup and Sum by Brent
How do I find multiple occurences of a value using VLOOKUP (or some other function) and then sum the values.
September 15th, 2005 05:34 PM
by Vincnet. Go to last post
1 95
greyed out button by M Zahedi
A while back I added a button to redo (ctrl + Y) to the standard tool bar. It was working fine for a long time, but now it is greyed out and I can not get it...
September 15th, 2005 05:41 PM
by M Zahedi Go to last post
3 120
E-mail addresses in Excel 2000 by David Williamson
I have an HR director who is copying and pasting e-mail addresses into a spreadsheet (Excel 2000). He wants to make these addresses links. I know how to do...
September 15th, 2005 05:42 PM
by Ron de Bruin Go to last post
1 121
How to calculate NPV of an infinite series? by Mike
I have a series of cashflows, forecast to grow at say 2% each year and go on indefinitely. Is there a formula or function I can use to get the value of the...
September 15th, 2005 06:10 PM
by Dana DeLouis Go to last post
2 624
Conditional Formatting and selection by Kristin N
I have one column that has both name/address(in one row) and telephone numbers(in another row). I'd like to move the name/address info into it's own column....
September 15th, 2005 06:27 PM
by John Moore Go to last post
2 118
Problem Deleting Check Boxes created from Forms Toolbar by Suzan
I managed to overlay about 200 checkboxes in one cell (long story). I have too much invested in this worksheet to just start over. Deleting the row doesn't...
September 15th, 2005 06:30 PM
by Suzan Go to last post
4 183
Formatting a number to look like a Percent without a percent sign by David Iacoponi
We often want a column of decimals to have a percent sign only on the first number in the column, so: ..553 ..554 (.345) need to be formatted to look...
September 15th, 2005 06:35 PM
by Mike Go to last post
2 119
How can I conditionally add up cells and display? by Marty
I'm new to excel...so sorry if this is simple.. I can't figure it out... I want to add up expeneses on one worksheet and display on another based upon what...
September 15th, 2005 06:41 PM
by Bob Phillips Go to last post
1 292
ignore missing values while ploting graph by Excel plot
what commands do i need to give in order to ignore the missing values when i am plotting the curve. By ignoring the missing values I will not get any breaks in...
September 15th, 2005 06:48 PM
by Mike Go to last post
2 93
Post New Thread


Display Options
Showing threads 20001 to 20020 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:25 PM.


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