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
Formula returning an error by gotroots
Hi, The following formula works as...
January 4th, 2010 05:53 PM
by gotroots Go to last post
2 100
How do I tally numbers, of a specific expense category? by The Ambassador
I have all my expenses for 2009 listed in date order. I have assigned each one an expense category using a drop-down based on the "data validation" tool. ...
January 4th, 2010 05:47 PM
by ryguy7272 Go to last post
3 177
change default table style by Syl[_2_]
Hello, Is it possible to change the default table style in Excel 2007 in general and not only for the workbook you are working in? I want to use a certain...
January 4th, 2010 04:48 PM
by Bernard Liengme Go to last post
1 171
Cell update delay by Bob_hc
Hi, I have a spreadsheet with two cells that are linked to an external value. However I want one of these cells to only update every second. This is...
January 4th, 2010 04:21 PM
by Bob_hc Go to last post
5 166
First non-blank row in WS after hyperlinking by Jack Deuce
I have several ws I use as check registers. I'd like to be able to go to the last non-blank row in that ws when I click that register's ws from the index...
January 4th, 2010 04:16 PM
by ryguy7272 Go to last post
1 103
bsval by angela
have anyone used this formula in excel? BSVAL() I searched in the help but couldn't find an answer. thanks!
January 4th, 2010 04:01 PM
by ryguy7272 Go to last post
2 137
Focus On Open - Goto by chickalina
I am trying to figure out a way to do this in Excel. I would like the focus to be on the first cell of the first worksheet when the workbook is opened -...
January 4th, 2010 03:41 PM
by Mike H Go to last post
1 98
How to make different cells fill in automatically from one entry? by Coco212
Hi, I have a workbook with three sheets: Activity, Expenses, Income. I only want to enter data on the Activity sheet. I select the date, I select the...
January 4th, 2010 02:31 PM
by JLatham Go to last post
3 113
Exclude Weekends by JJ
How do I set up the calander to exclude weekends in my schedule calculation? Est Start Date 04/01/2010 Leadtime = 5 days Actual start date is 09/01/2010...
January 4th, 2010 01:16 PM
by Mike H Go to last post
4 141
Incrementing Part of an Address by Phil
Sorry about the title, I wasn't sure how to phrase my question... I'd like to increment a number which is part of a URL, for example img src=...
January 4th, 2010 12:49 PM
by Roger Govier[_3_] Go to last post
1 162
How to assign unique number to column duplicates? by Heather
Hi All, I need to assign a unique number to a set of duplicates all in one column in Excel 2007. so columnA will has about 9000 numbers, some of them...
January 4th, 2010 11:37 AM
by Heather Go to last post
3 98
deleting numbers in a column by Calvinator
One of my columns should be only text. I converted pdf file of 30,000 records to excel. One of my columns ended with some student id #s in the ethnicity...
January 4th, 2010 09:17 AM
by Ashish Mathur[_2_] Go to last post
2 145
A macro for deleting lines of text by melara
Hi I need to delete all lines except those containing the Text NMI, FromDate, To Date Can someone tell me where I'm going wrong with this Macro when I run...
January 4th, 2010 08:29 AM
by OssieMac Go to last post
1 117
check box by PDStar
I have created an Excel workbook listing all the CD's I'm suppose to have. Now I want to put a check box at the beginnig of each row. If the box is...
January 4th, 2010 08:28 AM
by [email protected] Go to last post
2 95
issue with IF and text by evilthorne
I'm trying to get this formula in cell T62 to show "X" if W62 is blank or less then 0 but add 3 to the value if "yes" is pulled down on a data validtion...
January 4th, 2010 06:49 AM
by T. Valko Go to last post
3 100
FORMULA HELP by cONfUSEd LADY
HI, MY PROBLEM IS THAT I NEED TO TAKE OFF 20% OF A SUM OF AN AMOUNT EXAMPLE: THIS IS THE SUM FORMULA =SUM(C1:C15) BUT WHEN I PUT =SUM(C1:C15) -...
January 4th, 2010 04:54 AM
by evilthorne Go to last post
1 88
How to insert lines into a workbook without changing references? by MICHAEL JONES
WORKING IN A MULTI REFERENCED DOCUMENT TRYING TO ADD LINE ITEMS AND GET REFERENCE ERRORS. HOW DO I INSERT NEW LINE ITEMS WITHOUT CHANGING THE REFERENCES ...
January 4th, 2010 12:19 AM
by Max Go to last post
1 100
Excel Formula Help? by kacmatt
Ok, I'm not all that familiar with Excel or it's formulas/functions. Let me say thanks in advance for the responses. Here's the situation: I have a...
January 3rd, 2010 11:36 PM
by David Biddulph Go to last post
7 127
Worksheet tab headdings by westcoms
In your Excel workbook, you have tab headdings that you can name. Is it possible to set these up in a double row so they don'w run off the right side of the...
January 3rd, 2010 09:41 PM
by Karin Go to last post
3 116
Xindex by denny
When I was using Lotus 123 I used a function called Xindex that would find the intersection in a named ranged. Is there a function in Excel that will do the...
January 3rd, 2010 09:10 PM
by B. R.Ramachandran Go to last post
2 92
Post New Thread


Display Options
Showing threads 4201 to 4220 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 01:05 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.