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
Checkbook calculations by MDS1267
I am trying to create an Excel worksheet to calculate my checkbook. I want to be able to enter different transactions and have them added or subtracted from...
June 6th, 2010 05:39 PM
by T. Valko Go to last post
2 3,288
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,979
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 2,386
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,836
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 1,396
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 1,225
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 1,485
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 1,331
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 1,213
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 1,144
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,010
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 1,195
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 1,547
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 1,115
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 861
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 807
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 1,123
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 777
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 894
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 862
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 09:06 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.