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
Date question by Ziggy
Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS
April 18th, 2010 03:22 PM
by T. Valko Go to last post
3 130
Linking to other worksheets by Cav
I have 12 worksheets (Jan - Dec) each containing data for each month. I also have a summary sheet that i would like to link to the monthly data. On the...
April 18th, 2010 11:41 AM
by Ashish Mathur[_2_] Go to last post
3 141
What does this formula mean [$-F400]h:mm:ssAM/PM by Glenn
What does this formula mean h:mm:ssAM/PM I am using Excel 2007. I have a spreadsheet I'm trying to understand and when I custom format on a time value in the...
April 18th, 2010 10:53 AM
by Jacob Skaria Go to last post
2 127
What happened to setting up a constant using F4? by Stan
I used to be able to merely use F4 in a formula to keep a cell constant. Now it seems it doesn't work. What did they change it to?
April 18th, 2010 07:07 AM
by Ziggy Go to last post
2 129
Top half of covariance matrix by aaronmsl
Hi So I've used data analysis to produce a covariance matrix, however it only generates the bottom half of the matrix. Since I want to use the matrix with...
April 18th, 2010 05:15 AM
by Mike Middleton[_2_] Go to last post
1 125
Sorting by Father John
Hi I have a spreadsheet with numerous addresses in col. A 1-999 15 Smith Street Jonestown 21 George Street Blacktown etc. In col B. 1-166 I have the name of...
April 18th, 2010 02:05 AM
by JLatham Go to last post
1 126
Lookup Question by MJ
I have a worksheet that has Zip codes that needs to be matched with a master zip code list with assigned names. One worksheet has a column called “Ship...
April 18th, 2010 12:26 AM
by JLatham Go to last post
1 149
m4=b4 only if by Derek
I want to copy data from on cell to another cell, but only if a third cell has data in it.
April 17th, 2010 11:51 PM
by Joe User[_2_] Go to last post
2 165
Linking Totals Across Multiple Worksheets by snowboardbaltimore
I am trying to sum the totals (in accounting number format) across multiple worksheets onto a single worksheet. I have tried manually creating the necessary...
April 17th, 2010 06:28 PM
by snowboardbaltimore Go to last post
3 164
Store formulas in Vlookups? (another try ;) by patbarb
Is there a way to store formulas as text in a Vlookup table and then retrieve and activate them? For example, below I do a lookup on "Dog" (A1), return the...
April 17th, 2010 06:12 AM
by patbarb Go to last post
6 138
updating cell range depending on input value by handicapper
I'm creating a spreadsheet to process golf scores and calculate handicaps. I've identified the best 10 (AD4:AD13)scores from the past 20 (AB4:AB23). What I...
April 17th, 2010 05:50 AM
by handicapper Go to last post
3 125
annuity calculation for monthly payments but quarterly compoundin by JayM
I see the "Future Annuity Calculator" template but what I'm trying to do is calculate the FV of annuity based on monthly payments with quarterly compounding....
April 17th, 2010 03:56 AM
by Joe User[_2_] Go to last post
5 146
If function help by Pam
I have a current formula that I need to nest with another IF formula.... =IFERROR(VLOOKUP(B15,D40:E42,2,FALSE),"Invalid Shipping option") D40:E42 are shipping...
April 16th, 2010 11:16 PM
by Joe User[_2_] Go to last post
6 129
Maybe too hard to do? by LSSTOC Black Belt
Good Day, I have to take (certain) data from one sheet to another if a particular cell is not blank dynamically. F400 PROJ...
April 16th, 2010 11:03 PM
by LSSTOC BB[_2_] Go to last post
2 114
Use Vlookup to store formulas? by patbarb
Hi, I'm trying to figure out if it's practical to use Vlookup to bring back complete formulas to a spreadsheet when you have a ridiculous number of formula...
April 16th, 2010 10:20 PM
by patbarb Go to last post
6 127
Add text automatically by recognized value by Peter Gonzalez[_2_]
I'm trying to create a formula where it recognizes the first three digits of an item number at the same time entering the department name in the cell next to...
April 16th, 2010 09:21 PM
by Per Jessen[_2_] Go to last post
4 126
counting groups of words by Seller Smith
I have a column of cells that I would like to count the occurances of duplications of each group of words. Example: AMIN500S 1 AMIN400EC 9 ...
April 16th, 2010 08:32 PM
by Ron Rosenfeld Go to last post
4 147
Converting PDF or HTML to Excel by JPalmer
Is there a way to take the information in this link: and convert it into an excel spreadsheet that separates the...
April 16th, 2010 08:26 PM
by Don Guillett[_2_] Go to last post
2 98
Autogroup then sum - can it be done? by Jessica Robinson
This is what I would like to do, if possible: Sum the values of column B that correspond with a set of unique row entries in column A. The sum should go on...
April 16th, 2010 08:16 PM
by John Go to last post
5 137
If & Vlookup statement by Sarah
I am trying to lookup 2 separate ranges based on the IF statement. For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2) But if B3...
April 16th, 2010 08:13 PM
by Mitch Go to last post
3 147
Post New Thread

Display Options
Showing threads 1201 to 1220 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 11:57 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.