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
An oddity if not a bug by Harlan Grove
A1: =FACT(9)/FACT(6)/FACT(3) returns 84, as it should A2: =COMBIN(9,3) returns 84, as it should A3: =A1=A2 ...
(Multi-page thread 1 2 3)
July 17th, 2006 05:36 PM
by Harlan Grove Go to last post
21 253
The 4th column D to be filler. by Steved
Hello from Steved Below I've Columns A,B,C, What I would like please is a formula the would find the Duplicates, if none found the put the number 1 in...
(Multi-page thread 1 2 3)
August 8th, 2007 04:56 PM
by ryguy7272 Go to last post
21 199
Date + 365 in New Column by ace214
I have a column of dates, F. I want to have the dates plus a year in column M. I figured out that you can add 365 to a date but I'm not sure how to process...
(Multi-page thread 1 2 3)
August 14th, 2007 04:39 PM
by Sandy Mann Go to last post
21 249
adding numbers with letters by [email protected]
How do you add numbers in a cell with letters mixed? such as: 160grn+4wht+17grn Thanx in advance for your help!
(Multi-page thread 1 2 3)
January 10th, 2008 11:34 AM
by Rick Rothstein \(MVP - VB\) Go to last post
21 333
Average a list with high and low ignored by Shu of AZ
In the example below, there are 8 of a possible 10 numbers. The amount varies but never more than 10. These numbers represent a value of an equation...
(Multi-page thread 1 2 3)
February 7th, 2008 08:00 AM
by T. Valko Go to last post
21 152
days of the week formulas by Bob
I'm looking for formulas that will give me the first Monday and last Sunday of a period. For example The First Monday of February 2008 would be February 4...
(Multi-page thread 1 2 3)
March 7th, 2008 10:16 PM
by Bob Go to last post
21 210
"IF" Function by Boblink
Hi, I am using Excel MSOffice Xp (2002) and would appreciate help with the "if" function. I am trying to create a Retirement formula and running into all...
(Multi-page thread 1 2 3)
May 22nd, 2008 05:27 PM
by Boblink Go to last post
21 304
Counting Items by Jakobshavn Isbrae
How can I count the number of items in a column whose length exceeds zero? -- jake
(Multi-page thread 1 2 3)
June 22nd, 2008 09:27 PM
by Harlan Grove[_2_] Go to last post
21 134
Counting by Civette
I have a spreadsheet containing thousands of records (each row is a different record) and 20 different data columns. I want to count the number of records...
(Multi-page thread 1 2 3)
July 10th, 2008 09:32 AM
by Pete_UK Go to last post
21 164
Need Period After Initials by Susan
I imported a database into an Excel spreadsheet. The middle initials in the names don't have periods after them. Is there a wildcard character that I can...
(Multi-page thread 1 2 3)
May 15th, 2007 09:45 PM
by Susan Go to last post
21 199
Concatenate values IF() by Nikki
Hello group, we meet again: I have values returned, in Column W25:41; either a number (formatted as text) or nothing (""), depending on checkboxes selected...
(Multi-page thread 1 2 3)
May 12th, 2007 11:06 PM
by Ron Rosenfeld Go to last post
21 333
IF AND OR functions by Rondia
I have looked everywhere for help. This should be a simple formula, but never works for me. I have a main worksheet that I entered dated data into. I want...
(Multi-page thread 1 2 3)
August 21st, 2006 04:02 PM
by Bearacade Go to last post
21 297
Copying forumla for vlook up but changing the column Index # by klafert
I have a spreadsheet that I use the vlookup command. However, I have 23 lines per payroll check per employee - I am getting the data I want. However it has...
(Multi-page thread 1 2 3)
September 4th, 2006 07:56 PM
by Biff Go to last post
21 119
One of lifes little mystery? by JethroUK©
IF function if you omit the false parameter, the function returns "FALSE" =IF(A1="Bob",TRUE) so why doesn't it return "TRUE" so you can omit the true...
(Multi-page thread 1 2 3)
October 11th, 2006 11:12 PM
by PBalmanno Go to last post
21 112
Sum totals based on product name by jana
I have a large worksheet that has a product name and then in the next cell a sum, how do I sum only those equal to a specific product name. I have a list of...
(Multi-page thread 1 2 3)
May 28th, 2008 04:52 PM
by T. Valko Go to last post
21 195
Bob P. and Roger G. -- IF(and(...IF(OR( vs. IF(Boolean by Epinn
Hi Bob and Roger (in alphabetical order), I just want to let you know that gradually I am detaching Boolean from SUMPRODUCT and I am learning to use Boolean...
(Multi-page thread 1 2 3)
November 19th, 2006 09:38 PM
by Epinn Go to last post
21 329
Array help Part 2 by driller
Almost got it ! from previous question of Luke "Array Help" yesterday, where the checked answer is : on...
(Multi-page thread 1 2 3)
November 24th, 2006 03:49 AM
by Max Go to last post
21 273
If Then Dilemma by Excel Confused
I am trying to solve this problem: If a value in cell D4 is from 1 to 50 then I want a certain celll to show $2000 if the value in cell D4 is 50 to 100 then...
(Multi-page thread 1 2 3)
December 29th, 2006 01:11 AM
by JMB Go to last post
21 158
how to count easily by dribler2
With all formulas i gathered, i am still unable to do what my boss need. my boss is never satisfied maybe this is the last he will ask me something like...
(Multi-page thread 1 2 3)
January 1st, 2007 06:33 AM
by dribler2 Go to last post
21 243
Using VLOOKUP with a reference to a different file... by beeblemonster
Hello. I'm using VLOOKUP to grab data from a different file... that part is pretty simple. The problem is the file name gets changed a lot. I need to have...
(Multi-page thread 1 2 3)
August 14th, 2008 11:11 PM
by Peo Sjoblom[_2_] Go to last post
21 245
Post New Thread


Display Options
Showing threads 181 to 200 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:16 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.