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
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,131
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 1,679
Count function seeing formulas as data by robinessex
How can you get around the count function seeing formulas in any cell referenced as data?
June 6th, 2010 04:10 PM
by Ron Rosenfeld[_2_] Go to last post
4 1,272
IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES by Alohalady
Does anyone know of a formula that will calculate how many days are from one date to another? For example from March 30 to April 8. This is for the purpose...
June 6th, 2010 12:50 PM
by Stan Brown Go to last post
2 789
HELP! having trouble matching info with excel, HELP! by gloriamar
Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File...
June 6th, 2010 11:16 AM
by Mike Go to last post
1 722
xdate in Windows 7 by Help with scheduling issue
I finally entered the world of Windows 7, albeit only because my laptop died. I am a historan who needs to calculate dates into the 18th century. Xdate...
June 6th, 2010 11:01 AM
by Hans Terkelsen Go to last post
2 795
Trying to get this if statment to work by Cerealkiller via OfficeKB.com
I have excel 2000. I am trying to get this formula to work. It does not give me any errors or anything It just will not return the number in the cell that it...
June 6th, 2010 08:41 AM
by OssieMac Go to last post
1 639
Calculating pay dates by BW
If a date is a friday, I want to display the previous Thursday (MM/DD/YYYY). If a date is a Saturday - Thursday, I want to display the Thursday as a date...
June 6th, 2010 04:58 AM
by BW Go to last post
4 559
Totaling columns by John
I was so impressed with the wonderful responses and spot on answers to my first question on this site I thought I would give this one a try. I did try to...
June 6th, 2010 03:15 AM
by John Go to last post
4 623
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 483
Weibull function in Excel by Barbo
I have a survival dataset (see below). I want to fit to Weibull function S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and gamma=2.32. If...
June 6th, 2010 12:19 AM
by Mike Middleton[_2_] Go to last post
3 583
Help using the LARGE function "WITHOUT" using an array by exceluser
Can someone show me how to accomplish the following by using the LARGE function "WITHOUT" using an array ? I'm trying to rank each product (most, second most,...
June 5th, 2010 11:17 PM
by exceluser Go to last post
6 695
Remove error notification X7/M7=0 when one or both cell values are by chipmac1
How to remove error notification when X7/M7=0 when one or both cell values are 0
June 5th, 2010 10:47 PM
by David Biddulph Go to last post
3 607
excel by benney
I have a spread sheet and in it i have data validation tables when i finish picking from them and email the sheet i then want to clear the info in the tables...
June 5th, 2010 08:19 PM
by Steve Go to last post
1 443
what tab for calculating percent and decimal? by Heidi
I want to find the percent for each column. Which tab do I click to get the drop down choice for percent. I found it once and forgot to remember it. I...
June 5th, 2010 06:50 PM
by Don Guillett[_2_] Go to last post
1 366
sum by rows in Pivot by Dinesh
Hi, see table below. Col A Col B Col C a 1 7 s 4 9 x 8 4 d 9 3
June 5th, 2010 06:12 PM
by Roger Govier[_8_] Go to last post
1 521
Simplify Weighted Average Formula by ferne
I have a s/s that has the months of the year across the top and below 3 categories for each month and I want a weighted avg for each product. eg: A B ...
June 5th, 2010 02:37 PM
by ferne Go to last post
4 348
How can i protect a formula and still allow copy and move data? by ALP
i have 12 columns with data on days and each new day i want to add a new day to the set of 12 columns without adding a 13th one. So the oldest day are...
June 5th, 2010 10:57 AM
by Tom-S[_2_] Go to last post
1 388
Create Formula for Weighted Average in non-consecutive cells by ferne
I have a spreadsheet which across the top has the months Jan to Dec and Total. Under each month is 4 categories Days/oil/gas and would like to simplify a...
June 5th, 2010 05:04 AM
by ferne Go to last post
0 408
Fill in Column with a series of repeating numbers by mimi
I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got...
June 5th, 2010 01:42 AM
by David Biddulph Go to last post
2 569
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 04:45 AM.


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