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
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS by JingleRock
My formula is in a sheet named "Values"; the only other sheet is named "Data". The workbook contains EXCEL VBA code; Automatic Calculation is selected. The...
(Multi-page thread 1 2 3)
March 14th, 2009 03:39 AM
by T. Valko Go to last post
28 296
Return Unquie Values by Javier Diaz
So guys, heres another one Say in CElls A2:A10 I have values like so; food food test trial trial test
(Multi-page thread 1 2 3)
August 10th, 2007 04:09 AM
by Harlan Grove[_2_] Go to last post
27 351
MATCH Multiple Criteria & Return Previous / Penultimate Match by Sam via OfficeKB.com
Hi All, I am using a dynamic range called "Data", spanning many rows and columns. The range holds TEXT data and starts at row number 12, column "H". The...
(Multi-page thread 1 2 3)
October 6th, 2007 01:39 AM
by Sam via OfficeKB.com Go to last post
27 339
Rule of 75 Retirement Calculation by BAD
I need a formula to give me the date of when someone's age and years of service equals to 75. I have the birth date and the date of hire but have no idea...
(Multi-page thread 1 2 3)
October 21st, 2008 03:40 PM
by ~L Go to last post
27 393
Counting Unique Values by RJL0323
Hello All, I have a question related to counting unique values in a column of data. I will try to illustrate my question. I have a column of data with 1000...
(Multi-page thread 1 2 3)
February 19th, 2006 10:12 PM
by Aladin Akyurek Go to last post
27 594
multiple worksheet help by darkbearpooh1
sure this has been asked before but wth =) ok... trying to figure out if i create two work sheets one will have something similiar to a person's name in one...
(Multi-page thread 1 2 3)
February 17th, 2006 07:03 AM
by darkbearpooh1 Go to last post
27 382
Deleting by date automatically by Bryan De-Lara[_2_]
Jan-08 2 1 Jan-08 3 2 Jan-08 4 3 Jan-08 7 4 Jan-08 8 5 Jan-08 9 6
(Multi-page thread 1 2 3)
November 1st, 2008 07:35 PM
by David Biddulph Go to last post
27 274
How do I link cells from one excel worksheet to another? by stb
I want to link the totals of certain columns of several worksheets to a summary worksheet in the same workbook. I keep seperate worksheets of the circulation...
(Multi-page thread 1 2 3)
March 1st, 2010 11:16 PM
by Buckeroo Go to last post
27 517
assigning a unique value by Dino
I have a spreadsheet of names, and I need to assign a unique number to each of the names. Some entries are repeated, so each duplicate should have the same...
(Multi-page thread 1 2 3)
May 7th, 2005 12:12 AM
by Harlan Grove Go to last post
27 356
How do I remove the #div or N/A and make it 0 when using VLookup? by JeaneIsaac
I have a very large worksheet that I am using the following vlook up...
(Multi-page thread 1 2 3)
February 10th, 2010 06:15 PM
by Flcnmech Go to last post
27 482
VBA Code; need linked cells to change color if condition met by JVANWORTH
This calls for VBA Code knowledge I don’t have. I’m revisiting an old High School Scheduling project with a clearer objective. Microsoft Office EXCEL...
(Multi-page thread 1 2 3)
September 13th, 2007 01:01 PM
by Dave Peterson Go to last post
26 154
Weighted Averages by Chad Fields
Is there a way to calculated weighted averages in Excel? Lotus has a function called WEIGHTAVG, this is what I am looking for in Excel. Thanks
(Multi-page thread 1 2 3)
September 22nd, 2003 08:27 PM
by Aladin Akyurek Go to last post
26 773
ALTERNATIVE TO SUMPRODUCT NEEDED by Rog
I need to use two columns and search for two things and count how often the two occur together. In col X will occur the word "warranty" and in column AD will...
(Multi-page thread 1 2 3)
August 2nd, 2007 08:50 PM
by Rog Go to last post
26 297
Excel 2003 SP2 computes the power of a negative number wrong. by Giovanni Ciriani
A1 contains -4. B1 contains the expression -A1^4 The result is supposed to be -256, but instead it is 256. ---------------- This post is a suggestion for...
(Multi-page thread 1 2 3)
October 27th, 2006 02:43 AM
by Roger Govier Go to last post
26 268
Find value in array by Brook6
I am trying to do something that seems simple, but not sure how to do it... I want to have a table of text where the first column is a category and the...
(Multi-page thread 1 2 3)
January 30th, 2007 10:40 PM
by Harlan Grove Go to last post
26 279
NETWORKDAYS calc with 3 columns of dates by Mendz5
I have 3 columns of dates (A1, B1, C1). Several different scenarios: 1. If A1 is blank, but B1 & C1 are populated, I want to put the result in D1. 2. ...
(Multi-page thread 1 2 3)
August 18th, 2006 09:21 PM
by Bob Phillips Go to last post
26 193
where text wraps in a cell, how can the row height be auto set? by Stephen Sandor
I have merged a number of cells and included text that wraps in the cell. Is it possible to set the cell so that the height is automatically adjusted to the...
(Multi-page thread 1 2 3)
May 10th, 2010 07:57 PM
by Angie Go to last post
26 639
Average of top 3 numbers. by Belzbub
Hi, im making a worksheet for our shooting results. I need the average of the top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can anyone...
(Multi-page thread 1 2 3)
November 29th, 2005 12:45 AM
by Ron Coderre Go to last post
26 301
Significance of =+ in formulas by Frank Kabel
Hi it's the same as '='. Possible a user who has used Lotus Notes did enter this combination of '=+' So you can just delete the '+' sign in these...
(Multi-page thread 1 2 3)
March 26th, 2004 07:44 PM
by Bob Phillips Go to last post
26 307
INT defect: Please try this on 2007 for me by JoeU2004
Would someone who has Excel 2007 running on an Intel-compatible computer (i.e. not a Mac) please try the examples below and post your results here? I posted...
(Multi-page thread 1 2 3)
October 16th, 2009 03:15 PM
by Charles Williams Go to last post
26 546
Post New Thread


Display Options
Showing threads 61 to 80 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 05:02 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.