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
Simplifying numerous checkbox procedures into 1 procedure by PJ Murph[_2_]
I have 400 checkboxes (beginning with cbCheck1 thru cbCheck400). How do I write code that doesn't have to repeat this procedure 400 times? Private Sub...
March 21st, 2009 10:32 PM
by PJ Murph[_2_] Go to last post
2 96
Ignoring formula results of #N/A by Capt. Bangs
I am working on a time-based spreadsheet (each row represents one period) and have written a formula that refers to data from a previous row, but I want the...
March 21st, 2009 10:06 PM
by Christopher770[_3_] Go to last post
1 77
Getting #ref error after row / cell is this a limit in excel 2003 tia sal2 by please_post_to_groups
Greetings All sorry if this the second post the first one never made it through...gremlins in the system I’m getting a strange #ref error message in excel...
March 21st, 2009 09:58 PM
by Shane Devenshire[_3_] Go to last post
4 216
Tracking information sheet by Juliebee
I am creating a sheet for tracking outcomes. I want to put the information into the sheet with a due date for outcomes. e.g data entered , outcome due when...
March 21st, 2009 09:38 PM
by Shane Devenshire[_3_] Go to last post
2 85
Help with SUMPRODUCT Function by MattyP
Hello - I'm in need of some help. I need to count the number of occurences (rows) in a Worksheet, based on two criteria (column entries) in that row. I've...
March 21st, 2009 09:30 PM
by T. Valko Go to last post
6 112
SUMIF partial string criteria by Fred Holmes
SUMIF(range,criteria,sum_range) Where string (cell formula) criteria is tested against the string in the "range". This test is a full string comparison. How...
March 21st, 2009 09:23 PM
by Shane Devenshire[_3_] Go to last post
4 111
Formula assistance column match sum by JB Akron[_2_]
Please take a look at this formula. ...
March 21st, 2009 09:15 PM
by Shane Devenshire[_3_] Go to last post
3 75
Worksheet with most rows by Jack Deuce
I have a workbook containing 100+ sheets. Is it possible to find which sheet has the most rows? The data columns in these sheets contain dates, coin grades...
March 21st, 2009 09:14 PM
by T. Valko Go to last post
3 78
incremental step by Jim
how do I set up and cell for incermental steps by 1 each time a spreadsheet is opened for quoting?
March 21st, 2009 08:45 PM
by Mike H Go to last post
2 103
VISTA working with OFFICE 2003,2007 both or which? by Robert Blass
$100 is expensive to me so bear with me a moment. I need an upgrade from OFFICE 97. I have it working on VISTA 64-bit which I'm told is amazing but I want to...
March 21st, 2009 08:15 PM
by Shane Devenshire[_3_] Go to last post
1 76
How to parse long spaced entry into multiple cells??? by Robert Blass
Using Execl 97' The labels for each piece of the line of data would be as follows. Year, Brand name, Length, Filter, Package, Strength, Flavor,...
(Multi-page thread 1 2)
March 21st, 2009 04:37 PM
by Robert Blass Go to last post
10 156
Using MATCH or ......? by timgiaiphap
Hi all of you, I need your help. I have a sheet with the follwonig data TABLE 1 TABLE 2 INDEX Q'TY PRICE TOTAL INDEX Q'TY TOTAL AVG 1 100 2 200...
March 21st, 2009 04:34 PM
by timgiaiphap via OfficeKB.com Go to last post
2 97
XIRR problem by Dkline
Below is the schedule that I am dealing with. The problem is that I cannot find a rate that does not return a #NUM!. I've tried both negative and positive...
March 21st, 2009 04:33 PM
by Dana DeLouis[_3_] Go to last post
5 78
How do I avoid repeating calculation in IF function? by Arthur
I use a calculation that sometimes (legitimately) returns the error code #N/A. When this happens, I want a blank stored in the cell. ...
March 21st, 2009 03:52 PM
by Stephen Bye[_2_] Go to last post
5 88
If Then with Today formula by JimG
I am trying to subtract one date from another using the Today() formula, but if the value is greater than 250 I want to return the value of 0. Can someone...
March 21st, 2009 01:37 PM
by JimG Go to last post
7 150
Formula Help to Extract Partial Data from a String by Steph
I have data that looks like this: S30 1M D C7D S30 1M D 5W I 4 2W I X AH1 I need a formula that will extract the third group of characters from each...
March 21st, 2009 01:29 PM
by Ron Rosenfeld Go to last post
4 84
slecting all entries to appear once by ron
On 12 Mar, 20:53, Resi wrote: sorry when i run the macro in excel the error says: compile error: invalid inside...
March 21st, 2009 01:26 PM
by Ron Rosenfeld Go to last post
1 69
Can Autofill be used for Hyperlinks by BushyII
When I create a hyperlink, to a cell in a distant column, on the same row, it works perfectly. However, if I try to then Autofill it down a range of rows the...
March 21st, 2009 10:14 AM
by Simon Lloyd[_165_] Go to last post
2 114
Conditional formatting by Norfolk Bill[_2_]
Help needed with Conditional formatting I have a spread sheet containing 10 major columns and 240 rows. The data shown is meteorological values relating to...
March 21st, 2009 08:23 AM
by Shane Devenshire[_3_] Go to last post
2 72
restricting access using a macro by Popeye the powerman[_2_]
hi there, Does anybody know of a method for restricting access to a workbook based on a list of people. My problem is I have a workbook that two groups of...
March 21st, 2009 08:16 AM
by Joel Go to last post
3 90
Post New Thread


Display Options
Showing threads 13001 to 13020 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 04:06 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.