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 Replies Reverse Sort Order Views
REPORTING unique values by jane
here is my data: Mary Sally Sally Mary John John David I used the following to COUNT the unique values:
(Multi-page thread 1 2 3)
January 25th, 2008 10:34 PM
by Blue Max Go to last post
26 421
if formula #value by dan dungan
Hi, In Excel 2000, I'm converting a company's part number to our part number. Company part number with band 440HS030NF2107-3B 440HS030NF2107-3K our part...
(Multi-page thread 1 2 3)
November 19th, 2008 08:55 PM
by Harlan Grove[_2_] Go to last post
26 341
Worksheet Formula Returning Sum of a Series by monir
This is a cross-post Hello; The following is a failed attempt for the sum of a simple series: The series formula is: f(X) = Sum a(k)*X^(k-1) Example:
(Multi-page thread 1 2 3)
July 6th, 2008 11:28 AM
by Dana DeLouis Go to last post
26 239
How to time-limit an Excel file installation by Colin Hayes
Hi I need to have an excel file 'expire' 3 months after first installation. Is it possible to build something into the program so that it will read the date...
(Multi-page thread 1 2 3)
January 6th, 2008 05:20 AM
by Harlan Grove[_2_] Go to last post
26 225
Determining the Sunday date of the third "full" weekend of a month by Bob
For a given month number (in column A) and year (in column B), I need to determine the Sunday date of the third "full" weekend. A "full" weekend is defined...
(Multi-page thread 1 2 3)
September 13th, 2009 07:26 PM
by Bernd P Go to last post
25 331
How can I change the tab but keep the row and column constant when by MG
How can I change the tab but keep the row and column constant when filling in equations? I'm orgainizing a excel spreadsheet in which I have many...
(Multi-page thread 1 2 3)
June 20th, 2007 01:51 PM
by Bernie Deitrick Go to last post
25 191
Name - relative reference doesn't calculate by Werner Rohrmoser
Hi, I use a mane with a relative reference to sum 3 cells to the left or in another case the 3rd, 6th, 9th and 12th cell to the left. The syntax for the name...
(Multi-page thread 1 2 3)
January 29th, 2008 01:45 PM
by Lori Go to last post
25 291
Macro to apply parsing rules for strings and list the substrings by Luciano Paulino da Silva
Dear All, I'm looking for detect and list the substrings (bellow cell "A3") for a given string (on cell "A1") that must be generated for one or more general...
(Multi-page thread 1 2 3)
May 3rd, 2009 11:53 AM
by Ron Rosenfeld Go to last post
25 239
Wat formula shuld i use to find the details in the cell? by Cloud Strife
Hi, I'm currently stucked in my assignment, coz i need 2 do smtg like this. Currently I have a cell is General Manager, so I need to use a formula to find...
(Multi-page thread 1 2 3)
July 8th, 2009 08:46 PM
by Glenn[_6_] Go to last post
25 196
Countif funtion by Dot
I'm trying to bring three columns together that checks for a condition of a persons name and counts how many items were processed. I have the first function...
(Multi-page thread 1 2 3)
November 16th, 2008 06:43 PM
by T. Valko Go to last post
25 206
Sumproduct issues by SteveDB1
Hi folks. I use sumproduct to sum columns of values after testing against 2 criteria. At first it was working great, and then it stopped working once one cell...
(Multi-page thread 1 2 3)
June 3rd, 2009 04:58 PM
by RagDyeR Go to last post
25 200
Sumproduct Help by Biff
Hi Sandy, As an alternative to Normans fine reply: =SUMPRODUCT((A1:A7={"CAT","FISH"})*B1:B7) Biff -----Original Message----- A B
(Multi-page thread 1 2 3)
April 16th, 2004 01:05 AM
by gilbert Go to last post
25 308
Sum of named ranges conditional to date? by SleazyBreezy
Hi all, Say I have a spreadsheet listed as follows: A1 = 03/31/05 A2 = $5.00 B1 = 03/31/05 B2 = $10.00
(Multi-page thread 1 2 3)
June 24th, 2009 10:46 AM
by Nigel P[_2_] Go to last post
25 1,079
Is it possible? by DakotaNJ
I have a workbook with several tabs. The top tab is the main spreadsheet were I enter all my gathered data. The other tabs are the same spreadsheet, the same...
(Multi-page thread 1 2 3)
September 18th, 2006 09:30 PM
by Gord Dibben Go to last post
25 719
Conitional copying of a serie of rows from one spreadsheet to another by david
I have a large worksheet with data in it. I want to copy only those rows that meet certain criteria to another worksheet. For instance - If there is a certain...
(Multi-page thread 1 2 3)
July 6th, 2006 08:40 AM
by Max Go to last post
24 281
Combin by Andreas
If I use =Combin(40,6) I get the result 3838380. I would like to know which combination the numbers 3,12,17,24,32,36 represent without having to create all...
(Multi-page thread 1 2 3)
July 25th, 2006 05:59 AM
by Max Go to last post
24 240
To Fran Kabel by LEB
Sorry. I lost track of the thread in which I asked the question about dashes in a SUMPRODUCT function. You responded the dashes forced Boolean values...
(Multi-page thread 1 2 3)
March 22nd, 2004 11:46 AM
by Russ Go to last post
24 265
how do I email amacro? by leo
I have a macro for excel that I use on a xl file that I download from a server. How do I email that macro to a friend? thx
(Multi-page thread 1 2 3)
August 9th, 2006 02:47 PM
by leo Go to last post
24 211
Formula needed by Bob Vance
-- If B2 0 "OVERDUE" 0 "CREDIT" But If B1 = B3 " VERY OVERDUE" Thanks in advance for your help....Bob Vance
(Multi-page thread 1 2 3)
January 19th, 2004 10:48 PM
by Ken Wright Go to last post
24 283
Replace =RAND() with =ABS(RAND()) by Don
I recommend you change every instance of =RAND() in your spreadsheets with =ABS(RAND()) as Excell 2003 gives values of =RAND() from -1 to +1. Unless you want...
(Multi-page thread 1 2 3)
December 11th, 2003 09:56 PM
by Harlan Grove Go to last post
24 489
Post New Thread


Display Options
Showing threads 81 to 100 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 02:53 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.