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
Countif with 2 or more data ranges in same column by Doug
Does Excel have a function that will allow me to count only the data range for a specific title when there is more than one data range in the same column? I am...
July 4th, 2004 08:57 AM
by Aladin Akyurek Go to last post
1 1,019
Formatting (General to Number) by Tom R
Does anyone know if there is a way to change the number formatting from General to Number in one shot? I have an entire column that is in general formatting,...
September 17th, 2003 08:49 PM
by Ken Wright Go to last post
5 1,017
Help PLEASE! Not sure what answer is: Match? Index? Other? by baz
Please post response as email is bogus to prevent spam. I have posted this query to the misc board also. I just need some direction. I am using Excel 2003. I...
September 3rd, 2005 03:47 PM
by Conrad Carlberg Go to last post
7 1,016
Multiple SUMIF Statements by Gary Thomson
I want to do a SUMIF that will add amounts from either column C, D or E based on the following criteria: For each cell in the range F2:F200, if there is a "y"...
October 28th, 2003 12:16 PM
by Paul Go to last post
4 1,016
Question on LOGIC ?? - PLEASE HELP by PM
I have the following worksheet setup: Column A = Origin Column C = Destination Column E = Airline Cell A2: DTW Cell C2: IAH Cell E2: CO Cell...
(Multi-page thread 1 2)
November 28th, 2003 10:13 AM
by Max Go to last post
17 1,016
How to count the maximum number of consecutives? by JP
I need to determine the maximum number of consecutive negative numbers in a column. The column contains formulas that evaluate to a positive number, a...
January 3rd, 2010 12:19 AM
by JLatham Go to last post
9 1,016
Add asterisk to excel cell by jblack35
How do you add an asterisk to the begining of a excel cell? or replace the zeros with a asterisk? For example, data come in the cell as 01222 but I want it...
March 8th, 2005 07:25 PM
by Bob Tarburton Go to last post
1 1,016
Lookup in an Array by Steve
Can somebody tell me how to look up a list of items in a column from an array and then return the information in a cell that is in a column which is the same...
(Multi-page thread 1 2 3 ... Last Page)
November 6th, 2003 03:52 PM
by Steve Go to last post
36 1,014
Moving Column data formula by Puzzled
I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed....
June 6th, 2010 01:48 AM
by FSt1 Go to last post
1 1,012
macro in excel 2003 by constance
I need to create a macro for unpaid rent with gray backgound red text and border and in bold style unpaid rent is listed as no in worksheet in paid colum.I...
March 21st, 2005 10:50 AM
by Bob Phillips Go to last post
1 1,011
Linking Columns between worksheets by Malcolm
I have a workbook and I would like to do the following: sheet 1 named “End Bal” has 8 columns. In 2 of the columns; cells B5:B22 and H5:H21 contain one...
May 27th, 2010 11:42 PM
by Otto Moehrbach[_2_] Go to last post
6 1,007
Finding Asymptotes from a set of data in Excel by WAYNEL
Hi Can anyone help me find asymptote from a set of data in two column x and y that show the frequency responce of a say a freq. responce in Excel? Finding it...
January 7th, 2006 02:28 AM
by Barb Reinhardt Go to last post
1 1,004
Excel column headings by Wayne
EVery time I open EXcel for a new worksheet, the columns are shown as numbers, the same as the rows. How do I change it so that they are letters? Makes it much...
September 15th, 2003 03:01 PM
by Andy B Go to last post
1 1,002
How to know if a worksheet was unlocked by Mathieu936
Hi! I have a worksheet containing many formulas. This worksheet is locked without any password. Is there a way to see if somebody unlocked the worksheet to...
June 1st, 2010 07:30 PM
by Dave Peterson Go to last post
8 1,000
Any experts on "countif" formula using nested conditions by Chuck
I'm trying to get the count of the number of cells that contain a multiple condition using dates. Count the number of instances in cells A1 to A300 which are...
(Multi-page thread 1 2 3 ... Last Page)
April 8th, 2004 06:54 PM
by Chuck Go to last post
31 1,000
Workbook causes calculation errors by Luke M[_4_]
I've never seen this error before, and unfortunately, my Google searches keep bogging me down with the simple "Automatic/Manual" solution... I have Workbook...
June 4th, 2010 07:19 PM
by Luke M[_4_] Go to last post
2 999
"COUNTU" function in Excel to count unique entries in a range by WayneL
In order to count the number of unique entries in a range of cells, a very complicated nested set of functions (SUM, IF, FREQUENCY, MATCH, LEN, etc.)...
(Multi-page thread 1 2 3)
September 19th, 2008 03:50 AM
by T. Valko Go to last post
20 999
Insert Menu Greyed Out by SC-LS
I received a shared worksheet where certain features were unavailable (inserting being one of those). After saving and closing that spreadsheet and opening...
June 2nd, 2010 10:17 PM
by SC-LS Go to last post
0 997
difference between two time by Radhakant Panigrahi
Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...
June 3rd, 2010 01:41 PM
by Radhakant Panigrahi Go to last post
3 993
Formula Problem - interrupted by #VALUE! in other cells!? by Ted
Hi, The below formula =IF(OR(G23G$45,G23G$46),"",IF(G$480,(G23-G$45)/G$47,(G$46-G23)/G$47)) is used to generate data. If there is only one data in the...
(Multi-page thread 1 2)
November 25th, 2005 06:18 PM
by Roger Govier Go to last post
17 990
Post New Thread


Display Options
Showing threads 181 to 200 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 09:56 AM.


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