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 Views Reverse Sort Order
Combine values from different worksheets into a single worksheet. by jimmy2016
The worksheet 'job1' contains 6 workers named 'worker1'...'worker6'; The worksheet 'job2' contains 2 workers named 'worker1','worker3'; The worksheet 'job3'...
October 6th, 2016 05:20 AM
by jimmy2016 Go to last post
0 4,716
Question
Gregorian Calendar by ahailu
I have customers that use the Gregorian calendar ( it is 2003 now) while I keep my records in the Western Calendar (2010). Does any one know how I can convert...
September 29th, 2010 07:24 PM
by ahailu Go to last post
0 4,613
Can Excel automatically insert current date in a cell? by AdrianXing
Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?
(Multi-page thread 1 2 3)
June 3rd, 2010 09:42 AM
by steve Go to last post
21 3,795
Can I Use a Count Function for Text? by Joan NYC
I have been trying to calculate a column of Text in order to sum contents by certain criteria I have tried Count, CoutA and CountIF and cannot be able to get...
(Multi-page thread 1 2 3 ... Last Page)
May 22nd, 2010 07:17 PM
by Chris Reid Go to last post
106 3,781
September 14th, 2004 11:48 PM
by Jerry W. Lewis Go to last post
2 3,453
Checkbook calculations by MDS1267
I am trying to create an Excel worksheet to calculate my checkbook. I want to be able to enter different transactions and have them added or subtracted from...
June 6th, 2010 05:39 PM
by T. Valko Go to last post
2 3,334
VBA FORMAT(date,"YYYYMMDD") not working in Excel 2003 but works i. by JV
I have VB code in Excel Spread sheet that uses Format function to convert date to yyyymmdd format, it works in Excel 2000 but not in Excel 2003. Any info on...
September 16th, 2004 05:58 PM
by JE McGimpsey Go to last post
1 3,123
What is DBRW as used in Excel cell formula ie =DBRW( by Carlos
What is DBRW as used in Excel cell formula ie =DBRW(
June 4th, 2006 11:13 AM
by Gary''s Student Go to last post
1 3,089
Geometric Standard Deviation by Sandman
Can the geometric standard deviation of a dataset be calculated using Excel? I found the function for the geometric mean but have not been able to figure...
August 9th, 2009 06:44 PM
by JoeU2004 Go to last post
7 3,025
Complex AND OR Formula by Colin Hayes
HI I need to express something in a formula , and am having trouble with it. I need to say this : IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2...
June 6th, 2010 05:05 PM
by T. Valko Go to last post
9 2,984
QDE (Quick Date Entry) by Norman Harker
Hi Community of Excel Users! This is a joint posting from 4 of the "regulars" to these newsgroups: Bob Phillips, Frank Kabel, Ron de Bruin, and Norman...
(Multi-page thread 1 2 3 ... Last Page)
September 5th, 2004 01:24 AM
by Frank Kabel Go to last post
37 2,810
how to return mulitple corresponding values by MetricsShiva
i want to look up a name that occurs several times in one column of a spreadsheet and return corresponding values from each row the name occurs on. Vlookup...
(Multi-page thread 1 2 3 ... Last Page)
February 4th, 2010 11:03 PM
by T. Valko Go to last post
69 2,767
Delta E(cmc) formula by Michelle7890
Does anyone out there have the Delta E cmc formula for excel? I am trying to set up a spreadsheet that compares colors of test samples to a reference sample...
(Multi-page thread 1 2)
May 5th, 2009 02:46 PM
by Dana DeLouis[_3_] Go to last post
10 2,743
Finding roots of non-linear equations in Excel by TCO
I would like to find the first 20 or so POSITIVE roots of the following equation: A1=ATAN((2*A1*4)/(A1^2-16))/2 I have the "iteration" option turned on in...
(Multi-page thread 1 2)
August 4th, 2004 06:27 PM
by TCO Go to last post
14 2,647
How to calculate days:Hours:Minutes: by Kurewe
Greetings, I am working on a spreadsheet that performs several calculations on the data that is provided in another spreadsheet. The basic function of my...
(Multi-page thread 1 2 3 ... Last Page)
January 17th, 2005 12:11 PM
by Bob Phillips Go to last post
46 2,591
Incorporating Cell color fill in an "if" logical function? by George_Sky
I want to identify a specific cell by highlighting it with a cell fill color when an "if" statement returns a "ture" response. How do I do this?
(Multi-page thread 1 2 3 ... Last Page)
May 6th, 2010 06:42 PM
by Luke Go to last post
45 2,510
How can I lookup when match has more than one value? by bonot1
I am using LOOKUP functions to retrieve info from a list. Some of the lookup values have more than one match in the list. Is there a function that allows...
(Multi-page thread 1 2 3 ... Last Page)
May 24th, 2010 10:00 AM
by Roger Govier[_8_] Go to last post
55 2,502
How can I make a drop down box visible within a worksheet? by skittles_golf
I have created several Drop Down boxes in a worksheet but I want to make them visible so people know there is a drop down box there. Right now the arrow...
(Multi-page thread 1 2 3 ... Last Page)
May 19th, 2010 07:43 PM
by Cheers and Beers Go to last post
40 2,467
Count function seeing formulas as data by robinessex
Can you change the count function seeing formulas in cells as data. This makes the function completely useless. I have an array 1000 cells X 500 cells. I...
June 6th, 2010 04:12 PM
by Ron Rosenfeld[_2_] Go to last post
5 2,390
Bug in Excel's (not VBA's) MOD function by Harlan Grove
The value 12,345,678,000 is too large to store as a long integer but well within the range of integers that a double precision floating point real can store....
(Multi-page thread 1 2 3 ... Last Page)
August 30th, 2005 05:13 PM
by Harlan Grove Go to last post
41 2,294
Post New Thread


Display Options
Showing threads 21 to 40 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:38 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.