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 Reverse Sort Order Last Post Replies Views
Formula Help by dbray01
I have a small problem what i want to do is have excell subtract 8 from a cell only if the value in that cell is greater than 8 in other words i don't want any...
July 18th, 2006 01:11 AM
by JE McGimpsey Go to last post
2 134
subtotal function using criteria by dbroc
I'm trying to use the subtotal function to total figures in a list based on a technician's name. For example, use the subtotal function instead of the...
January 10th, 2010 02:46 AM
by Ashish Mathur[_2_] Go to last post
5 107
Double lines by dbs
I have quite a few shared worksheets in my office, and for some reason, practically every morning the last line on the worksheet is doubles (i.e. it is on...
July 13th, 2007 03:50 PM
by dbs Go to last post
0 64
Select the most recent date by dbs
I have an Excel file in which three columns contain dates. I would like a function to select which date is the most recent. Any help you could provide would...
May 10th, 2007 04:59 PM
by Don Guillett Go to last post
4 61
Move/Copy Worksheet -- does not work by dbsavoy
When I right-click a tab in a worksheet and select to copy it into another workbook. Nothing happens. What could possibly cause Excel to fail to move/copy a...
October 2nd, 2007 11:45 PM
by Pete_UK Go to last post
4 68
Use both ISNA and ISERROR in a long formula by dbsavoy
I am working in Excel 2003 with a formula which has one ISERR and a total of six vlookups. I am trying to have one cell look up values from other worksheets...
October 23rd, 2007 10:45 PM
by Chip Pearson Go to last post
2 94
How can I change all negative values in a column to = 0? by dbsavoy
I'm trying to calculate an average of data, but need to ignore negative numbers in the range from which I'm taking the average. I'd like to either format...
August 21st, 2006 08:14 PM
by DKS Go to last post
3 61
How do I write a VLOOKUP function that returns 0's, not neg vals? by dbsavoy
I need to write a VLOOKUP function that will return a value of "0" if it finds the number for which it had searched is negative. My thought is to use an IF...
August 24th, 2006 05:26 PM
by dbsavoy Go to last post
4 77
Help needed! by DBsWifeLB
I have a multiple page workbook and I need to consolidate all the information on one page. Problem is that some of the pages have different information...
March 14th, 2006 09:23 PM
by Duke Carey Go to last post
3 100
Random alpha generator by DBuche
I need a way to generate over 1200 unique two letter combinations. I've been reading past posts that explain ways to use the MATCH and VLOOKUP functions to...
April 27th, 2005 11:46 PM
by Bernd Plumhoff Go to last post
1 132
If statement by dbuck9333
Is it possible to use an if statement to enter information in one field automatically when certain info is entered in another field? for example when the...
August 21st, 2007 09:28 PM
by dbuck9333 Go to last post
4 48
Custom Functions saved as addin by dbutcher
I have a few custom functions I wish to save as addins. Can anyone tell me how to do this? -- dbutcher Posted from - http://www.officehelp.in
April 7th, 2006 05:24 PM
by Peo Sjoblom Go to last post
2 81
STDEV function in VB scritp for excel by dbwells
I am writing a VB script in excel and I am trying to use the STDEV function. I have worked through several errors but I am stumped on this last one: "Run...
July 22nd, 2008 06:28 PM
by dave88 Go to last post
4 54
IF Formulas by DBYRON
If any one can help with this query would be much apprieciated i'm very in need of it thanks; Simple example of what i need; on my work sheet i have a row...
October 6th, 2005 12:21 AM
by Zack Barresse Go to last post
2 61
Two criteria for CountIf? by DB_Bill
I have two columns of cells that need to be evaluated and determine if the criteria are met in order to be included in a count. The first column needs to have...
June 1st, 2006 04:33 PM
by DB_Bill Go to last post
6 83
Using IF function when "#value!" is present. by [email protected]
I have a problem. I think it can be solved with the IF funciton. I need to choose between the greater value in two cells to appear in a third cell. Because...
September 5th, 2006 10:32 PM
by Biff Go to last post
3 76
Text String Seperation. by [email protected]
I need to take a text string that has a Stock Option description in a text string (i.e. ADM Dec 2006 40.0000 put). I want to divide up the text string and...
September 5th, 2006 09:04 PM
by [email protected] Go to last post
2 98
Creating a dynamic list based on a minimum common variable. by [email protected]
I want to create a lits based on a minimum common variable. I use a program that generates a data table in a specific order. In 'COL A' are names of clients....
February 20th, 2007 07:26 PM
by Max Go to last post
3 113
Posting lowest values in a seperate worksheet. by [email protected]
I have a worksheet that has over 900 values that are dynamically updated in row D. I want to have a seperate worksheet that has the 50 lowest values update...
September 6th, 2006 03:22 PM
by [email protected] Go to last post
2 67
remove protection from previous employee no known password by dc
I am trying to remove the protection placed on an excel workbook by a previous employee who failed to leave a password. No way to reach him. Any...
December 13th, 2006 12:47 AM
by Jim Thomlinson Go to last post
1 80
Post New Thread


Display Options
Showing threads 20361 to 20380 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 06:09 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.