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
How do I switch form annual events list to my orginal calender by Kirk Polson
My calender is stuck just showing me my annual events. How do I get back to my orginal daily calender?
August 7th, 2008 02:05 PM
by David Biddulph Go to last post
1 90
How to delete a hundred range names at once? by Dima
Hello! How to select many names in the "Define Name" window in Excel 2003 sp3 to delete them? I unintentionally copied a thousand range names into a workbook...
August 7th, 2008 11:26 AM
by Dima Go to last post
4 114
Working with Functions on French Computer by Cazzy123
Hi, I have just bought a French computer and can't get the simplest of formula's to work. I am trying to do an IF or Si statement but it won't work but if I...
August 7th, 2008 11:17 AM
by Niek Otten Go to last post
3 131
validation data by KE
I have set up a spreadsheet which requires drop down boxes with data pre set. I want to take the validation data from a separate work sheet. Can anyone help...
August 7th, 2008 09:56 AM
by Stefi Go to last post
1 82
Using two formulae by Kirsty_H
I want to use two formulae within one cell. =IF(A50="",260,NETWORKDAYS($B$4,A50)) and IF(B50="",260,260-NETWORKDAYS($B$4,B50)) are the general formulae I am...
August 7th, 2008 09:22 AM
by Kirsty_H[_2_] Go to last post
3 99
Display Zero only in Selected Cells using a formula by Steved
Hello from Steved Please using the bottom formula I would like the cell to display "0" What is required please to acheive this =IF($A50="Public...
August 7th, 2008 06:20 AM
by Max Go to last post
8 170
Need help creating formula to sum tables by Darren Ingram
Hi I have a massive table which has various departments in column C, services supplied by the departments in column D and the period invoiced in column...
August 7th, 2008 05:56 AM
by Piotr (Peter)[_2_] Go to last post
4 100
Error: Undefined or non-rectangular name by Conan Kelly
Hello all, (Office 2003 SP3 on Win XP Pro SP3) (Also tried the following on an Office-2003-SP3-on-Win-XP-Pro-PS2 machine) Has anyone seen this error before...
August 7th, 2008 03:29 AM
by Conan Kelly Go to last post
0 111
INCREASE COST COLUMN BY A PERCENTAGE by bill z
i have a spread shee with a column of my product costs i want to mark up the whole ncolumn by 25%. please help how do i dom this. bill z.
August 7th, 2008 02:32 AM
by T. Valko Go to last post
3 129
Filtering totals - Reps per Province by jvbelg
I have 3 columns: Provinces, Customer numbers, and list of reps servicing these customers. A 7213 3 A 8027 8 A 2230 4 B 3240 3 B 3148 3 B 2370 4 C 3121 3
August 7th, 2008 12:26 AM
by Teethless mama Go to last post
6 61
problem: "You entered too many arguments for this function" by Sam Giddy
Here's what excel is allowing me to use right now: =IF((COUNTBLANK(G6:G12))0,IF(T1240,IF(T1140,0,(40-T11)-H12),U12-H12),0) I need to have another...
August 7th, 2008 12:20 AM
by Pete_UK Go to last post
1 65
Simple Worksheet Protection by James8309
Hi everyone, I am just trying to lock the worksheet so no one can change anything for all the worksheets. I have 40 worksheets in a workbook and problem I am...
August 7th, 2008 12:14 AM
by James8309 Go to last post
2 82
Vlookup not returning correct value by Drebdog
Have a simple VLookup set up to retun a time value for a concantenated statement since the statement will not display the time in a readable format. ...
August 6th, 2008 11:29 PM
by Drebdog Go to last post
4 106
How do I reference a cell to another in the preceding worksheet by karl.sonja
When I create another worksheet (ie copy a sheet) I want to refer in the new worksheet to some cell values in the PRECEDING worksheet. How do I refer to that...
August 6th, 2008 10:31 PM
by Gord Dibben Go to last post
8 71
Counting colored cells by Joebeone
Is there a way to count cells that are a certain color. Like count how many cells are blue or how many are red
August 6th, 2008 10:20 PM
by Chip Pearson Go to last post
3 65
Counting numbers in an array by BRob[_2_]
I want to count the number of cells in an array (16x30) that contain a number rather than an alpha character. Is there an easier way than do 16 column...
August 6th, 2008 09:43 PM
by Ron Rosenfeld Go to last post
4 85
copy down by robzrob
B4:B9 is 04/08/08 B10:B15 is 05/08/08 B16:B21 is 06/08/08 B22:B27 is 07/08/08 B28:B33 is 08/08/08 ie Mon-Fri dates, then B38:B43 needs to be 11/08/08 B44:B49...
August 6th, 2008 09:32 PM
by robzrob Go to last post
4 58
transfering data in another column entering more sorted data by Kevin - Corporate Services
I have an Excel spreadsheet containing cities and regions, sorted by alphabetical order into 6 columns. I am trying to keep the layout to fit on a LEGAL...
August 6th, 2008 09:23 PM
by Kevin - Corporate Services Go to last post
0 68
Formulas/References by Josh
I have a spreadsheet where I add a new column every week and therefore have to change the formulas every week too. The new column is inserted in column H...
August 6th, 2008 09:06 PM
by Lars-Åke Aspelin[_2_] Go to last post
3 62
How to keep a set range in a Search function by Connie
I am using the following function to look at numerous worksheets and count how many times a certain number shows up: =SUMPRODUCT(--ISNUMBER(SEARCH(A2,'Site...
August 6th, 2008 08:24 PM
by Glenn[_6_] Go to last post
1 79
Post New Thread


Display Options
Showing threads 21961 to 21980 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:42 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.