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
sum of range containing formula in blanks by cc
There are numbers in a range of cells that i need to add up but within the range are "blanks" that are actually formulas like this...
August 29th, 2008 04:28 AM
by T. Valko Go to last post
1 84
IF + IF? by RoadKill
Is there a way to combine the IF Statement. I will be using a similar formula for six separate metrics so would be great if I didn't need to build a table...
August 29th, 2008 01:58 AM
by JMB Go to last post
7 66
IF question by Stuart
Hi, Can someone help with the following conditional IF question please: If value in C4 is numeric, then the formula for K4 is C4*J4 rounded to 2 places or...
August 29th, 2008 01:32 AM
by David Biddulph Go to last post
3 66
splitting and formating a number series into date/time by CMG8401
I have a data series that looks like: 20080127145747 (YearMonthDayHoursMinutesSeconds) I need to break that up into two columns Date (Month/Day/Year) and Time...
August 29th, 2008 01:27 AM
by David Biddulph Go to last post
4 111
Calculate hours worked minus a half hour for lunch by Danedel
I'm trying to find the formula to calculate the employee hours worked in a given day allowing for a half hour lunch. The time card entry looks like: Time in:...
August 29th, 2008 01:12 AM
by Peo Sjoblom[_2_] Go to last post
3 97
Offset formula by Joe_Hunt
I've been trying to find an answer to a question I think I should know the answer to with no luck. I hope someone can help me. I need to have a formula change...
August 29th, 2008 12:35 AM
by Joe_Hunt via OfficeKB.com Go to last post
2 133
Calendar List to Calendar format by Kristin
Please help! I have been asked to maintain a calendar which lists calendar items and sorts them by item type on one sheet and then links those items to a...
August 29th, 2008 12:20 AM
by Pete_UK Go to last post
3 129
How do I turn off format painter so it doesn't keep popping up? by mcandrj
Is there an option to hide or cancel the format painter?
August 29th, 2008 12:04 AM
by Saylees Go to last post
4 447
using a formula to create an ordered purchase order by Jesse
I use excel to send out request for quotes to vendors and then transfer that information into a purchase order. I send out a request for quote to several...
August 29th, 2008 12:02 AM
by Max Go to last post
5 135
vlookup returning zeros by Cobaum
I have a vlookup formula that I copied down a column. It works fine on 95% of the values, but for some reason, right in the middle of the column it is...
August 28th, 2008 11:43 PM
by Max Go to last post
5 75
Percentage formula needed by MJM
I have not used Excel formulas for a while (need to take a refresher course) but in the meantime I am in need of the formula that will calculate the...
August 28th, 2008 11:25 PM
by MJM Go to last post
5 79
need help with a formula by freeman
I have an excel file that looks like this. Column A has a long list of names, many that repeat Column B has a the following formula =COUNTIF($A$2:$A$7610,A2)...
August 28th, 2008 11:08 PM
by Bob Phillips[_2_] Go to last post
8 82
#Missing by Shirley
Hi, I am using Hyperion Smart View - similar to excel. The cells have formula which are suppose to be zero amounts, display #Missing, instead of 0 or - ....
August 28th, 2008 10:22 PM
by JLatham Go to last post
1 90
similar names - two spreadsheets by jtkuehn
I have two spreadsheets. 1 has the names of new customers and 1 has names of prospects. I want to figure out if a prospect became a customer, but the names...
August 28th, 2008 10:07 PM
by dan dungan Go to last post
3 89
Choose 2 of 6 optional units for grade - formula question by xtrailer
I'm teaching a course that requires students to choose 2 of 6 units for a value of 20% towards their course. My Excel sheet is set up so I can enter the...
August 28th, 2008 10:01 PM
by dan dungan Go to last post
1 104
=SUMPRODUCT Col E = B, Col F = blank by 77Debbie77
I am using the formula below to try and get the total count of Col F when it is blank (Col F is text data and some employees did not enter a comment) when...
August 28th, 2008 09:14 PM
by Dave Peterson Go to last post
7 87
how do I apply formatting from one worksheet to a whole workbook? by amergerm35
I have an Excel workbook that is composed of the results from Access queries. IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely...
August 28th, 2008 08:34 PM
by amergerm35 Go to last post
5 84
hyperlink to other sw(exe) and open with parameters by [email protected]
Hi, I try to make a hyperlink to my exe and send it some parameter but when I click in the hyperink I get the following err msg: The specified file can't...
August 28th, 2008 08:28 PM
by ShaneDevenshire Go to last post
2 103
weighted average by elaine9412
Thanks for my previous help. Now I have the data and I need to do a weighted average for different groups of data as follows: group 1: Total count 3 total...
August 28th, 2008 07:40 PM
by Duke Carey Go to last post
6 75
#NAME? by 77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
August 28th, 2008 06:54 PM
by 77Debbie77 Go to last post
5 92
Post New Thread


Display Options
Showing threads 21001 to 21020 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 05:34 AM.


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