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
Vlookup and Data Validation Q by Seanie
I am trying to use a DataValidation cell value to do a lookup and I get #N/a Cell N101 = a Data Validation list value Lookup formula in O101 =...
April 18th, 2010 04:33 PM
by Sheeloo Go to last post
2 201
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 216
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 251
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 257
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 230
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 255
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 200
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 236
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 242
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 229
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 235
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 170
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 198
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 231
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 174
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 174
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 215
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 211
Converting PDF or HTML to Excel by JPalmer
Is there a way to take the information in this link: http://204.65.203.5/public/441280noadd.pdp 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 165
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 202
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 12:58 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.