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
Sharing Violation by Carolan
After I create a new Excel file, and then try to make changes to it, I get a message that says I can't save it because it's a "sharing violation". Could...
March 18th, 2010 04:15 PM
by Squeaky Go to last post
1 190
Microsoft 2007 by christie
What is the formula for a percent change between 2 cells? Everything I am trying will not work with the 2007 version. I have used the formula I know in an...
March 18th, 2010 04:09 PM
by Fred Smith[_4_] Go to last post
4 195
Formula Result is different from the shown result by DanWebster24
In the Function Arguments dialog the official Formula Result is different (and wrong) from the result shown after "=" just under the Serial number field. I...
March 18th, 2010 04:03 PM
by Fred Smith[_4_] Go to last post
2 153
How to enable auto height with merged cells? by lgreggs
I previously asked a question regarding auto height with merged cells and was given a code to enter into visual basic. I entered the code and copied & pasted...
March 18th, 2010 03:29 PM
by lgreggs Go to last post
0 88
Hide formula in list by Errko
Hi, I´ve made a list i Data Verifying that should display the options 0 or 1. 0 just being the digit 0 and 1 being the formula =SUM(D3)+1. How to I get 1 as...
March 18th, 2010 02:34 PM
by Errko Go to last post
1 72
Search Entire Sheet instead of 1? by msnyc07
I have a function whereby if a string in Sheet 2/Column1 is contained in Sheet1/Column1, it returns Sheet2/Column1. I am doing this manually but would like...
March 18th, 2010 01:51 PM
by Glenn[_6_] Go to last post
4 115
lookup second / last match with two conditions by Billy Leung[_2_]
Hello, I've a table below, I want to setup an formula to get the result as shown at the bottom. Thanks in advance for your help. Column B C D Row 1st...
March 18th, 2010 12:38 PM
by Gary''s Student Go to last post
1 106
I think I need a multiple IF statement, or is there another way? by Carl Waring
I can do the simple stuff, but this is more complicated! In English, this is what I want to do If the number in is =X then take off % then If the number in...
March 18th, 2010 10:57 AM
by Jacob Skaria Go to last post
5 113
Degrees Minutes Decimal Minutes to Decimal Degrees. by Al[_19_]
Hi All, I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653
March 18th, 2010 10:22 AM
by Ron Rosenfeld Go to last post
3 100
Changing Defined Names by Lelethu
I am try to create a formula where it will look up a range of defined names and then look for a value on that range found. how would i do that?
March 18th, 2010 09:43 AM
by Jacob Skaria Go to last post
2 110
countif with a condition and contains @ by Pete_UK
Try this: =SUMPRODUCT(--(A1:A20="M&P),--(NOT(ISNUMBER(SEARCH("@",B1:B20))))) Adjust the ranges to suit your data. Hope this helps. Pete
March 18th, 2010 09:15 AM
by whyrajesh Go to last post
1 80
SumProduct not Working in a Macro by Booey
Can someone please help - this is driving me nuts. I am wanting to use SumProduct in a Macro but it does not compile. The reason is that I am writing a...
March 18th, 2010 09:13 AM
by Bob Phillips[_3_] Go to last post
6 280
How do I find a value in a table without using the labels? by BobbyR
I have a table with a bunch of values. I need to find a value from the chart. the values are numbers based on different areas of steel. The values are the...
March 18th, 2010 08:50 AM
by Dennis Tucker Go to last post
1 75
Summing a crosstab by dysolomon
Is there a way to do a sumif on a crosstab? For example: Issue Year Duration 2,004 2,005 2,006 2,007 2,008 2,009 0 453 - - - ...
March 18th, 2010 08:30 AM
by minyeh Go to last post
7 99
column corresponding to row number by climate
I have 63 file. My data set on to column X, and G2 is row number related to column X. I need to macro or formula, when run it on any file, copy of column X...
March 18th, 2010 08:20 AM
by climate Go to last post
0 95
Formulas that recognise data from two worksheets by Kimbeau
I want to use data that is entered in one worksheet to calculate an equation in another worksheet. But i want worksheet one data to be recognized and...
March 18th, 2010 04:54 AM
by Fred Smith[_4_] Go to last post
1 83
combine vlookup and match help by cadustin
I need help, and fast! I am trying to create a form, and my formula is not working! I have been looking at thread after thread and no luck... I still get the...
March 18th, 2010 04:31 AM
by Jacob Skaria Go to last post
6 133
Help with SumProduct by Ayo
Is there a function in excel that would allow me to replace the $2000 in the formular below with the last row in the column contain values. Somthing like...
March 18th, 2010 12:21 AM
by T. Valko Go to last post
7 103
Replace Cells with Column names in functions? by msnyc07
I have a # of fairly long/complex cell functions that get hard to debug because there are also a lot of rows. Is there anyway to change display so it...
March 17th, 2010 11:56 PM
by Ashish Mathur[_2_] Go to last post
4 127
Microsoft Excel Total Values by gp
I have multiple instances on my spreadsheet of the same part number that I am tracking. In the differernt lines I have the different quantities of the same...
March 17th, 2010 11:25 PM
by Ashish Mathur[_2_] Go to last post
2 92
Post New Thread

Display Options
Showing threads 2021 to 2040 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:23 PM.

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