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
IF just STOPS WORKING by Gee
Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for...
(Multi-page thread 1 2 3)
August 6th, 2009 05:26 PM
by JoeU2004 Go to last post
21 230
countif on cells with formula's won't work correctly by JusMe
Using Windows XP and Office2003: In column AJ we have a formula .... =CONCATENATE(A97;G97;H97) =CONCATENATE(A98;G98;H98) .... the result of this is either 14...
(Multi-page thread 1 2 3)
August 16th, 2008 08:20 AM
by JusMe Go to last post
21 342
How can I extract the second half of addition ? by Gilbert DE CEULAER
I have lots of entries that have the form "+6+2", "+4+3", "+5+1". Is there any way to extract the second half, so the "+2", "+3", "+1" - part ? (Not all of...
(Multi-page thread 1 2 3)
September 28th, 2008 10:06 PM
by Bernd P Go to last post
21 278
average of 5 by mrbob16
I have a spreadsheet in cell b13 I start entering data till b59. I want to take a running average of the last 5 cells that contain data. Not all cells will...
(Multi-page thread 1 2 3)
December 22nd, 2008 06:43 PM
by Spiky Go to last post
21 294
Count If Column A = x and Column B = y by Trish
I am trying to use the count function where two conditions in different columns need to be satisfied and having no luck. Basically I want to look in the...
(Multi-page thread 1 2 3)
July 21st, 2009 04:41 PM
by Fred Smith[_4_] Go to last post
21 357
Copy line if by Kcope8302
I have a workbook with 4 Sheets(PTR,NMP,Reference data, Work Area). The first 2(PTR and NMP) are used to display the data from Work Area and Reference Data....
(Multi-page thread 1 2 3)
July 22nd, 2009 06:21 PM
by Kcope8302 Go to last post
21 252
Excel 2003 - Help writing a formula to get time (w, d, h, m) by Lady_Aleena
I have been going around in circles trying to write a formula to get weeks, days, hours, and minutes. (e38/h37)/2 is the amount of hours. The format I would...
(Multi-page thread 1 2 3)
July 20th, 2009 04:57 PM
by Glenn[_6_] Go to last post
21 204
Adding Round funciton to handful of numbers by Jamie
Hi, I have a sheet filled with raw data. I need to round each number and was wondering if there is a formula or macro I can run to accomplish this. All the...
(Multi-page thread 1 2 3)
July 25th, 2009 09:06 AM
by Bernd P Go to last post
21 203
Updating master workbook from source that may/may not exist by [email protected]
I am using Excel 2003 and have a master workbook that has many references (links) to various other workbooks that are in Excel 4.0 format. These source files...
(Multi-page thread 1 2 3)
April 7th, 2005 03:37 PM
by Dave Peterson Go to last post
20 652
Focus by David Unger
Hello, I wonder if someone can help me with this: I'm trying to confirm a valid time entry in a form field, and if invalid, clear the entry and put the focus...
(Multi-page thread 1 2 3)
March 21st, 2005 07:43 PM
by Harlan Grove Go to last post
20 245
Vlookup from 2 different sheets by WorkerBee
I would like my vlookup function to look for a value in one sheet and if it doesn't find it, look in another sheet. Is this possible? I was considering using...
(Multi-page thread 1 2 3)
February 21st, 2005 09:57 PM
by Ken Wright Go to last post
20 477
Excel 2003: RAND and RANDBETWEEN functions by Rita Nikas [MSFT]
Hi all. I just wanted to give you some information on this concern direct from Microsoft. In addition, this problem was mentioned in Woody's Watch, and...
(Multi-page thread 1 2 3)
February 14th, 2004 02:37 AM
by Norman Harker Go to last post
20 1,578
SumIf of SumProducts or summat... by RzB
I have a column of numbers and text Col A. The text is just a blanking "---" for zero values. I have a second, related column of numbers Col B. A third...
(Multi-page thread 1 2 3)
December 21st, 2003 08:08 PM
by Peo Sjoblom Go to last post
20 273
Separate Numeric and Text data by MG
Hi I have the following data in a spreadsheet, for example starting from A1: 1 2 3 14a 1ab
(Multi-page thread 1 2 3)
June 7th, 2004 07:31 PM
by Harlan Grove Go to last post
20 667
Lookup Q by John
I have a list of Raw Material items in Column A with their costs associated with them in Column B. I want to design a recipe module whereby I select...
(Multi-page thread 1 2 3)
June 3rd, 2004 12:01 AM
by Harlan Grove Go to last post
20 255
Is it possible to use wildcard characters in array formulas? by David
TIA for your help non working example: =sum(--(rng="XYZ"&"*") to find all cells in rng containing text begining with "XYZ" Is there a way? Thanks again -- David
(Multi-page thread 1 2 3)
June 18th, 2004 11:23 PM
by Domenic Go to last post
20 413
MAX function problem by Pat
When I want to find the highest number in a range the result returns the first 8 digits only (00000000) =MAX(A1:A9) returned 00000000 correct answer should be...
(Multi-page thread 1 2 3)
August 25th, 2004 06:23 PM
by hgrove Go to last post
20 447
geomean by JCallas
I am trying to do a simple geomean calculation and the #NUM keeps coming up. All my numbers are positive, above zero, and I have even eliminated the...
(Multi-page thread 1 2 3)
September 13th, 2004 01:24 PM
by Jerry W. Lewis Go to last post
20 300
Forulma Needed by PR
I am looking for a way to create a chart over a year period by each week, to let me now how many people where in my organisation over a year period,...
(Multi-page thread 1 2 3)
November 29th, 2004 09:16 AM
by PR Go to last post
20 275
O.T. - Bogus MS Patches by RagDyer
Just a Heads-Up ! Saw a post here, a day or so ago about someone complaining about getting a virus from Microsoft because, he thought, he posted to these...
(Multi-page thread 1 2 3)
September 23rd, 2003 04:38 PM
by RagDyer Go to last post
20 483
Post New Thread


Display Options
Showing threads 201 to 220 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 01:20 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.