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
auto height by lgreggs
I have merged cells across the bottom of a worksheet for a comment area. I have formatted the text to wrap. How do I get the area to auto format the height?...
March 12th, 2010 08:41 PM
by Gord Dibben Go to last post
1 181
creating drop down lists from source on another page by Shaun
Using Data/Validation trying to create a list based on our headcount stored on another tab. However Excel telling me impossible. Can I please have some...
March 12th, 2010 08:37 PM
by Gord Dibben Go to last post
7 157
Why does my text in a cell with wrap text and auto height get cut by HerbertB
It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when...
March 12th, 2010 08:30 PM
by Gord Dibben Go to last post
4 184
Wrap text in cell by HerbertB
It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when...
March 12th, 2010 08:19 PM
by Gord Dibben Go to last post
1 153
External Links in Excel 2007 with variable source file by PaHead
I have read many posts in this discussion group refering to "External Links". It seems there needs to be an answer for more people than just me. I have many,...
March 12th, 2010 08:12 PM
by JGT Go to last post
5 208
Repeat Rows but not on every page! by AndreaW
Is it possible to set the repeat for just a certain number of pages, not all? Example: I want to repeat $2:$2 on page 1 through 6 but I don't want the repeat...
March 12th, 2010 07:46 PM
by Luke M[_4_] Go to last post
1 180
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) by Ann Scharpf
I have a bunch of columns with dollar values. I want to add the sum of all the values for rows that meet a single condition. If possible, I'd like to...
March 12th, 2010 06:43 PM
by T. Valko Go to last post
4 154
Highlight Cell that contains invalid email format by Gareth_Evans (InterCall EMEA)[_2_]
Hi again, I've been working on a spreadsheet that will highlight cells different colours based on criteria. I've been doing this with VBA...well, trying :)...
March 12th, 2010 06:25 PM
by Gareth_Evans (InterCall EMEA)[_2_] Go to last post
3 156
Return Corresponding Value Based on Comparing Two Sheets of Data by PaulQ[_2_]
Can someone please help me find a formula (or two) for this example. If you can show me a couple of ways to do this (so I can learn), I'd greatly appreciate...
March 12th, 2010 06:23 PM
by T. Valko Go to last post
6 146
Any idea why this is giving me a #Value! Error? by msnyc07
Function FrstLtrs(MyStr As String) As String Dim temp Dim i As Long TmpStr = Split(Trim(MyStr)) 'MsgBox "String" + TmpStr For i = 0 To UBound(TmpStr) If Not...
March 12th, 2010 06:22 PM
by msnyc07 Go to last post
3 136
colating multi rows of data into single rows - no to pivot tables! by UKMAN
the formula below allows me to state the number of days by month i.e. 10 days from 23rd April means 8 in April and 2 in May. I have 2 issues with it...
March 12th, 2010 05:11 PM
by UKMAN Go to last post
4 174
SUMPRODUCT ISSUES by Rbirdie
I am trying to get SUMPRODUCT to work and it is not. Here is my data A L M 1 C 354.54 Notes about account 2 W 16.54 ...
March 12th, 2010 05:10 PM
by Ashish Mathur[_2_] Go to last post
2 146
Parsing Information from a Cell by Ken
I have a long list of supplies in Column A. In Column B it shows the range of their cost ... for example, "79.99 - 89.99". I would like Column C to only...
March 12th, 2010 05:06 PM
by Ashish Mathur[_2_] Go to last post
3 134
SUMIF with area that is not a range by lwsnbaker
I am trying to sumif cells that are not consecutive. Here is what I have so...
March 12th, 2010 04:49 PM
by Luke M[_4_] Go to last post
2 134
Using Iserror with If statement and Vlookup by juliejg1
I have the following formula in a cell: =IF($K2="STEEL",VLOOKUP($B2,'Macos 12 Mo. Data'!$A$4:$AU$326,40,FALSE),0) Problem is that the results of this are used...
March 12th, 2010 04:01 PM
by juliejg1 Go to last post
3 136
Help with SUMIF & AND function by mirko
Hi, how do I create a formula to sumarize value by group and subgroup? My formula by group works but unfortunately the 2nd one doesn't work. What I need is :...
March 12th, 2010 03:49 PM
by Bob Phillips[_3_] Go to last post
2 113
Report one value out of a range by jollyr
Hello everyone. I have the following scenerio that I sure could use some help on: A B C D E 1 Mike tools Sam tools 2 ...
March 12th, 2010 02:54 PM
by jollyr Go to last post
2 162
Formula calculating to the 3rd decimal by Shayla2008
I am using simple addition & multiplication formulas and the sum appears to be calculating to the 3rd decimal which is making my totals unacceptable. My...
March 12th, 2010 12:23 PM
by Bob Phillips[_3_] Go to last post
9 217
Count by Louja
Hi, On my file I get a list of accounts. I have a look up which lets me know which account belongs to which individual. I need to know how many different...
March 12th, 2010 11:56 AM
by Louja Go to last post
7 183
Formula problem with Excel 2010 by mns
Hi there, I am trying to enter this formula in conditional formatting window but my Excel 2010 wont accept it. I get the error "the formula you entered...
(Multi-page thread 1 2)
March 12th, 2010 10:42 AM
by Bob Phillips[_3_] Go to last post
13 256
Post New Thread


Display Options
Showing threads 2181 to 2200 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 08:49 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.