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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Finding lowest count in any column by Sarah H.
Hi, group, I'm interested in knowing the lowest count of non-zero numbers in any column on my sheet. Columns are from B through I. Actually, I want to add 1...
May 20th, 2009 05:10 PM
by T. Valko Go to last post
7 210
Calculation Speed by ColleenK
I post this before and implemented the suggestions, to no avail, so I am asking for further ideas. This is Excel 2003 and I have a workbook with 15 tabs,...
(Multi-page thread 1 2)
May 20th, 2009 05:06 PM
by T. Valko Go to last post
14 383
Error problem by Ayo
I have this formular: =SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes")) but it is showing as an error. Iknow...
(Multi-page thread 1 2)
May 20th, 2009 04:52 PM
by Ayo Go to last post
11 330
Erase same content in all cells in Excel by S1L1Y1
I am sending a sample of contents I have in the cells. I am trying to erase everything but the URL address. How can I do it? I have in one line when I copied...
May 20th, 2009 04:18 PM
by S1L1Y1 Go to last post
0 193
Dates by lightbulb
Is there a way to have a formula look at a cell and if the date in that cell is between two certain dates to display it, otherwise leave blank...for...
May 20th, 2009 04:01 PM
by David Biddulph Go to last post
3 164
comparing 2 sheets by rodchar
hey all, i have 2 sheets that contain a column of names on both s1 john amy s2 john
May 20th, 2009 03:38 PM
by rodchar Go to last post
2 163
SUMPRODUCT by ColleenK
Hi There, I am new to using the sumproduct formula, would someone be able to tell me why the following is not working: =SUMPRODUCT('Detail...
May 20th, 2009 03:23 PM
by David Biddulph Go to last post
3 171
How do I count a range of times and link it another worksheet. by Jay C
How do I count a range of times and link it to another worksheet. For example I am trying to count all the start times between 6:00am and 6:59am on Monday...
May 20th, 2009 03:14 PM
by Luke M Go to last post
3 149
Rounding off by ace
Guys, I have a question. Suppose I have a column which has values ; 300 315 330 390 Now i want these values rounded off to the nearest quarter,
May 20th, 2009 03:12 PM
by ace Go to last post
3 152
Text to Columns help by Martin ©¿©¬ @nohere.net
Hi I have a column with name like below McAllister Mr & Mrs E. Hay Mrs E. Farquhar Rev. G. & Mr M. Russell Mrs M. Cuthbert Mr & Mrs J. Cuthbert Mr R. Cuthbert...
May 20th, 2009 02:42 PM
by Martin ©¿©¬ @nohere.net Go to last post
4 206
Another Text to Columns question by Martin ©¿©¬ @nohere.net
Hi I have the name McAllister Mr & Mrs E. When I use text to columns it becomes Mr & Mrs E.McAllister However, I want it to be Mr & Mrs E. McAllister (with a...
May 20th, 2009 02:36 PM
by Martin ©¿©¬ @nohere.net Go to last post
4 189
Excel 2002: Auto Filter Sub Total formula by Mr. Low
Hi, I wish to sum up the filtered data by using =Subtotal (109,E6:E125) but it returns with #VALUE, may I know how to solve this problem ? Is this formula...
May 20th, 2009 02:23 PM
by Mr. Low Go to last post
2 172
send excel sheet to email recipient as hyperlink by Cyndi
Hi, My working files always comes with photo and thus creates a big file. So instead of sending it as "Send to Email recipient (as Attachment)", is there a...
May 20th, 2009 02:15 PM
by PJFry Go to last post
2 188
Automatically updating cells when opening workbook by SPISO
I am working on a primary worksheet "Dashboard" where information in column B associated to today's date in a secondary worksheets "Scheduled" is copied to...
May 20th, 2009 02:11 PM
by SPISO Go to last post
0 184
Tring to save header & footer change causes an error message by Anniethefish
I have excel 2002 - on a worksheet that come in Excel 2003, if I try to go to page setup, I remove the header and footer and attempt to save, I get an error...
May 20th, 2009 01:59 PM
by broro183[_3_] Go to last post
1 160
how to change old data source reference from copied pivot tables by arun
Hi All, I wanted to change the old datasource reference from my copied sheets having pivot tables and charts. I copied the sheets from other workbook. ...
May 20th, 2009 01:13 PM
by Eduardo Go to last post
1 187
Formulas by Donna
I need a basic formula as soon as possible! I know that I have done this type of work before however, it has been so long since that I cannot remember how to...
May 20th, 2009 12:55 PM
by Pete_UK Go to last post
2 143
Problem with Deserialization by Gaurav Nanda
Hi, I am creating a excel plugin, where i have to create a Tree on Excel worksheet, so while saving i also want to save the tree in serialized form as a...
May 20th, 2009 12:34 PM
by Gaurav Nanda Go to last post
0 163
Proteção com macro by macros
Tenho um arquivo que tem varias macros, este arquivo é protegido com senha, no excel 2003 ele funciona normalmente, ja no excel 2007 ele não funciona,...
May 20th, 2009 12:32 PM
by macros Go to last post
0 174
IF then else VB code help by Lost
Ok I dont know how to start with this or if its possible but here is my delema & idea. I have WorkbookA.xlsm that opens hidden when I open WorkbookB.xlsm...
May 20th, 2009 12:31 PM
by Dave Peterson Go to last post
1 151
Post New Thread


Display Options
Showing threads 19841 to 19860 of 139764
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 08:45 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.