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
Man hours calculation by Mama Mia
How do I calculate man hours for a month?
April 20th, 2010 07:56 AM
by raj rajesh Go to last post
6 188
Multi NetWorkDays Calculation by Chris
I'm attempting to create a staff availability table by month. Each row is a person and each column is a month. Person | Apr-10 | May-10 | Jun-10 | John Doe |...
April 20th, 2010 07:52 AM
by Steve Dunn Go to last post
3 138
workday, networkday or something else? by AJ
I have two date and time fields, the Q column is the Ordered Date and the T colum is the Date Closed. We work 8 hours a day from 8-5. Im trying to figure...
April 20th, 2010 07:46 AM
by Bernd P Go to last post
5 154
COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard" by Courtney[_3_]
Hi all, I am trying to find a way to write the following formula in Excel 2003. I have tried SUMPRODUCT but it does not seem to work when both criteria have...
April 20th, 2010 03:01 AM
by T. Valko Go to last post
3 125
Finding duplicate addresses by Donna[_5_]
If you could help me with this it would be greatly appreciated. Column A Has client codes Column B Has client names Column C Has client...
April 19th, 2010 10:44 PM
by T. Valko Go to last post
5 127
SUM determined by drop-down list by RICH1B
HI, I have a product list with different products in each row, Column A is the number, Column B is the Description, Column C is the Quantity, Column D is a...
April 19th, 2010 10:13 PM
by L. Howard Kittle Go to last post
9 221
Custom Functions Available for all Workbooks by Diego Miranda
I have created some customized functions no the PERSONAL.XLSB file but I cannot use them in any other workbook i use. I have plenty macros on this PERSONAL...
April 19th, 2010 10:11 PM
by T. Valko Go to last post
2 172
COUNTIF Function by csmith13
I am trying to use the countif function by rows and it is not calculationg correctly. I try to drag the formula down and it just repeats the same value as...
April 19th, 2010 09:06 PM
by David Biddulph Go to last post
8 143
Getting a value by comparing 2 columns by NeedExcelHelp
Hi, I have a mailing list that I need to create but with a specific list of customers. Cust 1 in the example, is our current customer list. Cust 2 is the...
April 19th, 2010 07:59 PM
by Duke Carey Go to last post
1 116
Excel Toolbar by Nvrcmgbk
Somehow I lost the toolbar to edit cell contents. How do I re-insert that toolbar?
April 19th, 2010 07:44 PM
by Duke Carey Go to last post
3 112
Dynamic formula by Frank Pytel[_2_]
Hello; I know I have asked this question before but can not seem to find the answer. It may have been purged by now. I have done this before but can't seem...
April 19th, 2010 07:17 PM
by Luke M[_4_] Go to last post
1 110
Text from Referenced cell truncated by Jay
Good afternoon Everyone, my problem is that text from a referenced cell in a separate workbook is not showing up completely in a secondary workbook. I am...
April 19th, 2010 07:01 PM
by Jay Go to last post
2 132
single report on data in 20 tables by UKMAN
Hi In 1 sheet have 20 tables of holding the same except for col 1 in each that hold a unique id for that table. Each table can hold up to 50 rows, so some...
April 19th, 2010 06:49 PM
by Hugo Jorgensen[_2_] Go to last post
1 125
Help with formula by Iriemon
I am trying to solve the following equation for "X": Sorry, Discussion group formatting will not allow me to write in superscript! The last part is supposed...
April 19th, 2010 06:29 PM
by Luke M[_4_] Go to last post
2 124
Function to Use when compare sums another column by Heather
I have and age Field and a Column that contain counts. If the aging Column contains a number between =0 and =30 I want it to sum up the counts that...
April 19th, 2010 06:11 PM
by Bernard Liengme Go to last post
3 154
Font by way of function? by Copacetic
Hi guys... Is there a function that assigns the font for a given cell or range? Or am I required to code it in VB?
April 19th, 2010 06:11 PM
by Steve Dunn Go to last post
3 144
Too Few Rows to copy sheet to another book by snowboardbaltimore
What is the deal with the error message that I have too few rows to copy/ move one of my worksheets to another worksheet using the right-click function? Is...
April 19th, 2010 05:36 PM
by snowboardbaltimore Go to last post
2 136
Drop Downs and lookups from other sheets by TheDrescher
I have a workbook where the front sheet is a display page and the three sheets behind are reserved for data tables. What I want to do is have one cell in...
April 19th, 2010 05:28 PM
by Pete_UK Go to last post
2 129
formula similar to "countifs" function in excel 2007 by embee
I need a formula similar to the countifs function offered in excel 2007. I'm using excel 2003 and can't upgrade to 2007. I want to add together cars at a...
April 19th, 2010 05:19 PM
by Pete_UK Go to last post
2 132
automaticely highlight the row that I am working on by Cindy
Is there any function for me to set up color change for the row that I am working on, so, I won't mistype row for my worksheet?
April 19th, 2010 05:02 PM
by Luke M[_4_] Go to last post
5 143
Post New Thread

Display Options
Showing threads 1161 to 1180 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 01:54 AM.

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