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
Comment boxes by Martina
Hello experts, If you have a large spreadsheet set to view at say 60% how do you make the comment boxes readable?? kind regards Martina
September 15th, 2003 06:51 AM
by Jon in Ohio Go to last post
1 1,446
how do i winsorize data in excel by Samira Pimentel
I have some outliers in a set of data, and would like another method, besides the TRIMMEAN to smooth the outliers. Trimmean "eliminates" the outliers... how...
September 10th, 2008 04:33 PM
by SCrowley Go to last post
1 1,418
Does date fall between two ranges? by MR
Hi, Having a bit of difficulty constructing a formula to work out the following: We have a table of dates and a 'category' roughly as follows: Start Date #...
January 14th, 2004 05:08 PM
by Daniel.M Go to last post
4 1,406
Date fomula not working by FangYR
I have use this last year, it's fine until now. the formula is now new to...
(Multi-page thread 1 2 3 ... Last Page)
February 19th, 2009 12:13 AM
by Max Go to last post
43 1,401
Using a cell reference for Sumif Criteria by Kevin
I am using the following formula to get an average for a column of data where the values are greater than or equal to the value...
May 25th, 2004 06:20 PM
by Go to last post
3 1,401
Formula to Return the next 1st Tuesday of a Month by Sean
How can I construct a formula that will relate TODAY to the 1st Tuesday of each month. For example as today is 01/12/07, my formula should return...
(Multi-page thread 1 2 3 ... Last Page)
December 3rd, 2007 09:22 AM
by Sean Go to last post
42 1,397
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
MS.Excel vs Works Spreadsheet by Excel Gure
I am confused, why does Microsoft have two excatly alike products on the market? Office XP and Ms. Works? Works is is around $50 and MS Office XP sells for...
September 15th, 2003 11:30 AM
by Chip Pearson Go to last post
3 1,395
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" by Timothy L
I'm PHP/JavaScript programmer, so please bare with me as I'm not all to fimilar with Excel's way of doing IF and ELSE, MATCHing and such. I rarely use Excel by...
August 27th, 2004 02:28 AM
by Jerry W. Lewis Go to last post
5 1,380
sumproduct formula returns #name error by Todd
Hi. I am trying to get a sumproduct formula that will look at the date in one column and if its the correct month, total values in a second column. I am...
July 6th, 2004 07:25 PM
by Peo Sjoblom Go to last post
3 1,351
Set Cell format using VB.NET by Hugh
Hi, I want to open a exsiting CSV file and set the Data Format of column A (Date and time) to Date (m/d/yyyy) and column width to certain number. I can open...
(Multi-page thread 1 2)
March 4th, 2010 12:06 PM
by babu p Go to last post
10 1,343
Need Help with Sumif Function including dates by KDenise
Hi, I need some assistance with tracking my commissions that are due to be paid each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by...
May 31st, 2010 04:47 AM
by Max Go to last post
6 1,337
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
On opening a spreadsheet. by Pinda
On opening a excel workbook, is it possible to have a default way of opening? For example, I want to display a certain worksheet everytime on opening that...
September 30th, 2003 09:36 PM
by LD Go to last post
7 1,326
split worksheet by patrick072040
Can you split a worksheet in half vertically, but scroll vertically on both?. For example, have cells j1..l8 stay put, when scrolling up cells a1.I100 ? It...
September 15th, 2003 01:00 PM
by Jim Rech Go to last post
3 1,325
Hyperlink from Excel to a specific slide in PowerPoint by Charlie A
Does anyone know an easy way to hyperlink from Excel to a specific slide (say Slide 59) in a PowerPoint file using the hyperlink worksheet function. Thanks for...
December 8th, 2008 05:46 PM
by Bob W Go to last post
5 1,315
Paste Link Grayed Out by Steve M
I have successfully used paste link several times before. I now have a destination worksheet into which I was able to paste link one value successfully. Since...
October 16th, 2003 09:20 PM
by Felipe Go to last post
4 1,314
Counting Unique Values by Bob
I have a column with the following dates: 11/23/05 11/23/05 11/23/05 11/25/05 11/25/05 11/28/05 12/1/05 12/1/05
(Multi-page thread 1 2 3 ... Last Page)
November 1st, 2006 10:00 AM
by Jamie Collins Go to last post
38 1,314
Summing a non continuous range by fabio
Hi From a previous post I was provided with a formula to provide a year to date total from a table based on the month I entered in...
June 2nd, 2010 04:23 PM
by fabio Go to last post
7 1,313
almost DSUM, but is there another database - criteria funcion? by Lance
Have you tried Sumif() sumif(b1:b100,"=A",c1:c100) Lance -----Original Message----- I have a problem with excel. I have a list of expenses, sorted by...
September 15th, 2003 08:05 AM
by beppe005 Go to last post
1 1,306
Post New Thread


Display Options
Showing threads 81 to 100 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:54 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.