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
Help with INDIRECT by GoBucks
I have a column in one worksheet (Col A) with a list of names: Col A Jones Smith Williams James In another worksheet I am looking for a formula that will...
April 14th, 2009 01:25 AM
by Ashish Mathur[_2_] Go to last post
7 74
Sum or Average with #N/A cells by PaulinaDi
I'm using a formula to bring results from another worksheet but in some cases I get the #N/A result as I donĀ“t have data on the original worksheet. To get...
April 14th, 2009 01:25 AM
by T. Valko Go to last post
5 60
Excel 2002-7: Modifying Sub Total Function to allow insert blank r by Mr. Low
Hi, I have an idea to make use of the subtotal table to insert an empty row below a change of certain reference in column C as ilustrated below: ...
April 14th, 2009 01:11 AM
by Ashish Mathur[_2_] Go to last post
1 57
Bolean Logic with the Advanced Filter by leimst
I would like to use a Bolean formula to identify cells with a red background when performing filtering using the Advanced Filter. I recorded a macro where I...
April 14th, 2009 12:59 AM
by leimst Go to last post
0 79
Drop Down Starting Position by veggies27
I have a drop down list in a data validated cell with blank items at the bottom of the list (to allow for addition user-entered choices). Is there any way,...
April 14th, 2009 12:58 AM
by Gord Dibben Go to last post
2 73
How do I use a cell format to figure out a data? by vvenk
Hello: I have a spreadsheet that has different color fills do denote something: Blue: Planned Orange: Unplanned Grey: Suspended. Can somebody tell me how I...
April 14th, 2009 12:43 AM
by Gord Dibben Go to last post
1 99
Auto Sum by NRH
my coulum wont sum how do i turn it on
April 14th, 2009 12:38 AM
by Gord Dibben Go to last post
3 52
Count IF by Adam
Hey Guys, i Want to use COUNTIF function liek this.. (Range, Criteria, when you use count if, it will just let you do one if statement, (range,...
April 13th, 2009 10:55 PM
by Dave Peterson Go to last post
1 42
Calculate Months to Determine Length of Service by WilliamsDeLisle
I need to be able to input a beginning employment date, i.e., 10/12/1994 and calculate the number of months between this date and the current date to...
(Multi-page thread 1 2)
April 13th, 2009 09:51 PM
by WilliamsDeLisle Go to last post
11 98
linked workbook cell returns 0 is source workbook cell is blank? by Syd
EXCEL 2003 - If source workbook cells are blank, some cells are general and some are number, how come the linked workbook cells returns 0 insteand of blank. ...
April 13th, 2009 07:49 PM
by Syd Go to last post
4 99
Using multiple IF conditions by Jayceejay
I am having a difficult time with an IF statement. I have a value in cell A1 that triggers a response in cell A5. If cell A1 = 0, Cell A5 should =0 If cell A1...
April 13th, 2009 07:40 PM
by Rick Rothstein[_2_] Go to last post
3 47
April 13th, 2009 07:34 PM
by Susan Go to last post
1 77
IF by Susan
Hello, Having touble using the IF function with dates. IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the result in cell b1 to be...
April 13th, 2009 07:30 PM
by Rick Rothstein[_2_] Go to last post
2 39
Adding Rows by Cindy H.
How do I add multiple rows to a spreadsheet at once
April 13th, 2009 07:16 PM
by Sheeloo[_5_] Go to last post
1 47
Chart Data Table by Joe R @ AA[_2_]
On a YTD Chart, I need the data table to show blanks, not zeroes for future months. The data sheet which the chart references for the numbers are blank. The...
April 13th, 2009 07:10 PM
by Joe R @ AA[_2_] Go to last post
0 49
How do I count just the numbers in a cell, no spaces or comas? by bonair
I have dates (1, 15, 21) in various cells. I want to count JUST the dates, no spaces or comas.
April 13th, 2009 06:43 PM
by Dave Peterson Go to last post
2 74
Cells will not clear - if I type 1 it comes up as 100 know matter by musicgirl
I have tried everything to clear out the cells. Nothing is working. When I do right click -- Format Cells -- Number -- Data it says that it is "General"...
April 13th, 2009 06:26 PM
by musicgirl Go to last post
2 66
Formula for non matching items by henriques
Need a formula for the no matching items in a worksheet with the following data: Columns A, B and C are the data for 2008 Column A- Customer number Column B...
April 13th, 2009 05:53 PM
by henriques Go to last post
3 59
Import worksheets from another workbook? by bjwheeler
A coworker sent me his Excel workbook, and I want to import specific worksheets into my workbook, as if to merge them, so they're located in the same...
April 13th, 2009 05:24 PM
by Ron de Bruin Go to last post
1 53
HELP!! VLOOKUP, INDEX or MATCH?? by Kurt
I am trying to figure out how to get a piece of information into a cell needed for a calculation. This is what I have in one worksheet: 8 ...
April 13th, 2009 05:17 PM
by T. Valko Go to last post
8 87
Post New Thread


Display Options
Showing threads 12201 to 12220 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 11:37 PM.


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