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
Empty Cell Result by Mike H.
In this if statement: IF(A1=100,1,"") I would like the 3rd parameter to not return "", not return 0 but return NOTHING. Is there a way to return empty,...
April 13th, 2010 10:10 AM
by Grimwadec Go to last post
8 115
April 13th, 2010 08:38 AM
by RTK Go to last post
0 146
visible cell only by Brad Autry
I'd like to use the PERCENTILE function in a list that has been autofiltered and get the results based only on the visible cells. I've used SUBTOTAL in order...
April 13th, 2010 05:36 AM
by T. Valko Go to last post
1 105
Conditional formatting with expired dates after current by Josh
I am trying to get a cell to turn Red if the date that is in the cell is less than or equal to the current date. The formula I have in it already is:...
April 13th, 2010 04:37 AM
by Max Go to last post
1 157
I want to add formulas from multiple sheets to master form by snake941
How do I add formulas from multiple sheets in a workbook to a consolidated worksheet?
April 13th, 2010 04:27 AM
by Fred Smith[_4_] Go to last post
1 149
vlookup and match first value greater than by MPI Planner[_2_]
I need to lookup a product id and return the date of the first value greater than zero For instance a b c d e f g 1...
April 13th, 2010 03:31 AM
by Teethless mama Go to last post
4 160
Non-contiguous range and Sumproduct to average by Mifty
Hi, I'm using the following to average data in K if value in F = value in...
April 13th, 2010 03:03 AM
by T. Valko Go to last post
5 159
Invoice: customer database and billing information by Nic Daniels
Hi, I would like to connect an invoice sheet to a customer database (a database including names, addresses as well as billing information). I would be great...
April 13th, 2010 02:37 AM
by JLatham Go to last post
3 133
excel formula by Brian
Does anyone know how to create a cell that will calculate whether the number in the orginal cell is above or below 40. If above 40 it will calculate at...
April 13th, 2010 02:36 AM
by T. Valko Go to last post
6 137
Sum VLOOKUP? by andyoftheg
Hi All, I appologise if this function is currently avalible and i have missed it. Is there a function or macro in Excel 03 which will effectivly provide the...
April 13th, 2010 02:07 AM
by Ashish Mathur[_2_] Go to last post
4 117
Ignore Hidden Rows and Count of distinct values by Anuma (GGK Tech)
Hi, I need to display the Count of distinct values and also ignore hidden rows in the count. Please help me to fix this issue.
April 13th, 2010 02:00 AM
by Ashish Mathur[_2_] Go to last post
3 174
Duplicates formula by Soth
Result Example Result in col B A B 100 100 100 3 200
April 13th, 2010 01:57 AM
by Ashish Mathur[_2_] Go to last post
5 120
Averaging many non-contiguous cells if they are blank by Nadine
I have columns set up to record payments (one for the date and one for the amount). Currently I have columsn enough for 13 payments. So, imagine that the...
April 12th, 2010 11:25 PM
by macropod[_2_] Go to last post
1 99
Need to extract specific data from a text column by Homecomingwarrior
VFLE_VT_1CAAGK_790006_BH4A004M02_STALVTBAKAF From this string I may need to extract 1CAAGK or 790006 or BH4A004M02 Not all rows of data are consistent in...
April 12th, 2010 11:10 PM
by Joe User[_2_] Go to last post
2 123
Lose Formatting by [email protected]
We have a pretty intense Excel Workbook that we use on a daily bases. We are currently running MS 2007 but this Workbook is running in 97-2003 because we just...
April 12th, 2010 10:10 PM
by [email protected] Go to last post
0 117
locate first value greater than by MPI Planner[_2_]
I would like to be able to return the first column that has a number greater than zero. For instance 3/2 3/9 3/16 3/23 3/30 Product A...
April 12th, 2010 09:23 PM
by MPI Planner[_2_] Go to last post
6 124
I need to write a PRODUCT formula that mimics a SUMIF by eileenfz
I need to write a PRODUCT array =PRODUCT(1+(the values in column t that have a value in column d that match the value in D841)-1) Is there a way to do a...
April 12th, 2010 09:08 PM
by Tom Hutchins Go to last post
3 106
Can I color a cell with "If" formula by DLHedges
I would like to have the cell turn a certain color with an "If", "Then" formula. Is that possible?
April 12th, 2010 08:37 PM
by JLatham Go to last post
2 160
Average For Filtered Cells by carl
I use the auto-filter feature. Is there a formula I can use that will compute the average of the values in a column for just the cells that are displayed...
April 12th, 2010 08:30 PM
by Don Guillett[_2_] Go to last post
1 121
transfering cell values progressively through worksheets by Mike1558
I am creating a budget/pay-application template that uses a new worksheet for each pay-application and the number of worksheets corrisponds to the duration...
April 12th, 2010 08:10 PM
by Mike1558 Go to last post
8 192
Post New Thread


Display Options
Showing threads 1341 to 1360 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 02:35 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.