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
Microsoft Responds to the Evolution of Online Communities by [email protected]
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...
(Multi-page thread 1 2 3)
May 11th, 2010 03:40 AM
by GS Go to last post
22 1,043
Count Blanks in a Filtered Column by Gos-C
Hi, Is there a function to count blanks in a filtered column? That is, if I filter a column to show the rows that are blank, can I use the subtotal function...
(Multi-page thread 1 2 3)
March 23rd, 2006 08:21 AM
by Aladin Akyurek Go to last post
21 540
calculate a formula instead of returning text by Jonrey
I am compiling data from several different, variable, worksheets. I am using concatenate to add the name of each worksheet into a formula to pull...
(Multi-page thread 1 2 3)
April 9th, 2006 11:28 PM
by Harlan Grove Go to last post
21 355
Need help with Countif function by Mary-Lou
I need to count two different text values within two columns. Column A contains sentences and Column B contains various values. Example of small sentences in...
(Multi-page thread 1 2 3)
June 3rd, 2006 01:23 AM
by Mary-Lou Go to last post
21 327
COUNTIF problem with NOW() by Spreadsheet
=COUNTIF(ALL!AC2:AC1000,"NOW()-21") This is the formula I'm using. I'm trying to determine how many dates in column AC are more than three weeks ago. It's...
(Multi-page thread 1 2 3)
June 26th, 2006 09:47 PM
by SteveG Go to last post
21 466
SumIf query ... by muchacho
Does this function ignore invisible cells (autofilter) ? If not, what could be an...
(Multi-page thread 1 2 3)
June 28th, 2006 09:53 PM
by muchacho Go to last post
21 308
convert meters to feet/inches by Ann
i'm trying to convert from meters to feet and inches (not just feet or not just inches). so if i have 2 meters, i want the result to read 6 feet, 2 inches for...
(Multi-page thread 1 2 3)
February 17th, 2010 01:59 AM
by Dana DeLouis[_3_] Go to last post
21 306
Countdiff with more criteria by JP Ronse
Hi All, I would like to count a sort of diversity per person and per month. Sample data: Customer Engineer Date A JP 01/11/2009 A Bill...
(Multi-page thread 1 2 3)
December 22nd, 2009 01:07 AM
by T. Valko Go to last post
21 300
date from sheet name by JBoulton
I'd like to turn a sheet name into a date. Apr28 to 4/28/10 (as a date) and Apr28-30 to Apr28-30 (as text) TIA and thanks for any ideas. Jim
(Multi-page thread 1 2 3)
April 29th, 2010 07:34 PM
by T. Valko Go to last post
21 353
count colored cells? by DKY
I have a spreadsheet in which there is a calendar. On this calendar are cells for the days. In these cells for the days we use colors for Vacation (Purple),...
(Multi-page thread 1 2 3)
January 19th, 2006 10:47 PM
by [email protected] Go to last post
21 356
sumif with or by C Glenn
I'm trying to do this: =SUMIF(B5:B12,OR("=D*","=?D*"),D5:D12) It returns zero each time. (BTW, =SUMIF(B5:B12,"=D*",D5:D12) and =SUMIF(B5:B12,"=?D*",D5:D12)
(Multi-page thread 1 2 3)
October 17th, 2005 11:56 PM
by C Glenn Go to last post
21 265
Worksheet Naming by Andy Sandford
Hi All Is it possible to have the name of a worksheet change based on a value in a cell within that worksheet? e.g. data to be input in a cell relates to the...
(Multi-page thread 1 2 3)
February 15th, 2004 06:30 PM
by Tom Ogilvy Go to last post
21 339
Formula to rid of DIV/o! by Sean
hello, Say A2 = 5.00, B2=0 C2 = DIV/O! - I would like for this to be blank or show a zero...is this possible? Thanks, Sean
(Multi-page thread 1 2 3)
August 19th, 2004 11:04 PM
by Frank Kabel Go to last post
21 299
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,785
Averages and Counts from different columns by sonofroy
Hi I have a golf handicapping spredsheet set up like this B C Front 41 Back 30 Front 53 Back 43 Front 37 Back ...
(Multi-page thread 1 2 3)
May 6th, 2005 08:13 PM
by sonofroy Go to last post
21 356
Copy cell format to cell on another worksht and update automatical by kevinm
I have two worksheets, I have entered the formula for a cell on the 2nd worksheet so that the cell contents are copied from a cell on the...
(Multi-page thread 1 2 3)
May 19th, 2005 11:07 AM
by paul Go to last post
21 1,148
trying to write a formula ivolving data validation by melben
Is it possible to write a formula for my example below 1 cell has a list in it e.g. Beverage, food, Accomodation. If you select beverage, cells b15,c15,d15...
(Multi-page thread 1 2 3)
May 27th, 2005 04:59 AM
by mangesh_yadav Go to last post
21 308
3D Ranges by David
I am looking for a very simple piece of code illustrating the format for a "3D" range ie one that spans more than one worksheet. Can anyone help. the MS help...
(Multi-page thread 1 2 3)
June 9th, 2005 06:11 PM
by David Go to last post
21 363
Decimal to 24 hour clock please. by Steved
Hello from Steved 1.43 to 1343 9.52 to 2152 3.17 to 1517 I have the above in decimal please a formula to 24hour clock as above ie 3.17 to become 1517 not...
(Multi-page thread 1 2 3)
June 9th, 2005 07:16 AM
by Steved Go to last post
21 310
Excel function for tables by rbrownlee
I have a table that has been created in excel that lists mileage from one place to the other. The rows all have headers for starting points, and the columns...
(Multi-page thread 1 2 3)
February 19th, 2004 03:58 PM
by Jonathan Rynd Go to last post
21 244
Post New Thread


Display Options
Showing threads 161 to 180 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: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.