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
#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 131
URGENT! how count how often a vlaue occurs within a range of value by elaine9412
What formulae do I use to count how may times a number equal to and greater than 2 but less than 3 occurs in one row? ( I have numbers in the row that are a...
August 28th, 2008 06:08 PM
by T. Valko Go to last post
3 136
Finding last cell with a value and then adding to another by KoolyHigh
I need help in writing a formula that will lookup the last value in a column and then add that value with the value in another cell where you have several...
August 28th, 2008 05:48 PM
by KoolyHigh Go to last post
2 94
follow up to nested subtotal/sumproduct by SteveDB1
Hi again. Yestyerday I was talking to Peo Sjoblom about a nested sumproduct with a subtotal. We did get it to work, but after I posted it was solved, I'd done...
August 28th, 2008 05:48 PM
by SteveDB1 Go to last post
0 71
If formula with two conditions to meet by Carolina
I have the following scenario: If the value in cell Z5 is equal or greater than "0" the person gets $700 AND if in addition field value in cell AB5 reflects a...
August 28th, 2008 05:25 PM
by Carolina Go to last post
7 81
"move tab sheets" by Avinono1
is there a way to mpve the tab sheets from the bottom of the worksheet to the side?
August 28th, 2008 05:12 PM
by Pete_UK Go to last post
1 121
Cumulative labor calculation by MarkMcG
Please forgive my indolence (and perhaps slothfullness). Communal work is the best. I have a salary for 2008. I want to calculate a 3.5% increase, year...
August 28th, 2008 05:02 PM
by MarkMcG Go to last post
0 176
amortization schedule / Mortgage payments by Bmac
I would like Excel to calculate the remaing balance based on the current month. For example if I am making my 26th payment on my $200,000 mortgage, and...
August 28th, 2008 04:34 PM
by Bernie Deitrick Go to last post
5 163
Complex SUMPRODUCT/VLOOKUP/SUMIF by tigger
Hi there, hope someone can help. I have a summary table within a spreadsheet where I am tracking actual and forecast spend against individual projects. I...
August 28th, 2008 04:30 PM
by tigger Go to last post
1 79
August 28th, 2008 04:29 PM
by Spiky Go to last post
2 116
How to restrict user to input only one of multiple cells by James
Hello, here's a problem I've been wrestling with. Is there any way to design a worksheet that would only allow a user to enter a value in one of a group of...
August 28th, 2008 04:23 PM
by Gary''s Student Go to last post
1 129
Calculation of an UDF by Werner Rohrmoser
Hello, I've made an UDF to determine, whether a cell has a formula or not, see listing...
August 28th, 2008 03:54 PM
by Werner Rohrmoser Go to last post
5 99
Keep all cells in a column unique? No cells identical by phillr
Hello. I'm creating a video catalogue list. Each video is being assigned a unique ID number. Column A is my ID # column. Is it possible to keep every cell in...
August 28th, 2008 02:54 PM
by Gary''s Student Go to last post
1 114
NEED INFO to the left of rqd cell by CAPTGNVR[_2_]
DEAR ALL Can you pls give me how to write the INDEX AND MATCH function so that I can get the left value in col-D interpolated for a col-D value say...
August 28th, 2008 02:51 PM
by CAPTGNVR[_2_] Go to last post
7 98
match with isna formula question by Belinda7237
I want to bridge info from one workbook to a new workbook with a formula in column V. but i have two criteria instead of one to consider the match before...
August 28th, 2008 12:52 PM
by Belinda7237 Go to last post
2 131
add If to formula to blank #n/a by Diddy
Hi everyone, I'm using the following formula =INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0)) How do I add to this to not have #N/A when it doesn't...
August 28th, 2008 11:16 AM
by Max Go to last post
3 115
Keep data in fields if no update while updating by MS
The problem must be solved without using VB and the excel version is 2003 ! The problem is I have an everyday sheet to keep track of some part#s and another...
August 28th, 2008 08:06 AM
by MS Go to last post
2 98
=SUMPRODUCT(--(TRIM(A1:A10)"")), what does the "--" mean? by Ray
Hi, What does the "--" operator mean in the above worksheet equation? Thanks.
August 28th, 2008 08:05 AM
by T. Valko Go to last post
2 91
Active Cell Color by Taurien
Hi! Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its...
August 28th, 2008 07:53 AM
by Taurien Go to last post
5 423
Simple IF , maybe, for names in columns by Steve
I have a column of 40 names (A3:A43) In column B, I have only 10 of those names I'd like column C to show what names are not listed in column B ( the other 30...
August 28th, 2008 06:51 AM
by Max Go to last post
7 125
Post New Thread


Display Options
Showing threads 21021 to 21040 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 12:40 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.