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
Using english and non-English Excel commands simultaneously in anon-English installation by Michael.Tarnowski
Hi community, I like this forum very much - I got many valuable insights from it. In the past I had an English Excel installation at the office...
March 12th, 2010 08:21 AM
by HK[_2_] Go to last post
6 218
Why won't this function work? by Angelsnecropolis
This function works: =IF(B71="","",IF(B71=330,"Standard","Below Standard")) But when I change "330" to "R4" it doesn't work. R4 is a number field that has...
March 12th, 2010 06:00 AM
by Fred Smith[_4_] Go to last post
3 175
slope? by John
Hi, if I have the following table how do I find x? 1 1134.9 2 3 1138.99 4 5 x
March 12th, 2010 05:42 AM
by John Go to last post
1 181
Sum Multiple Worksheets, same named cell by uncreative
I have multiple worksheets containing the same named cell (e.g. Month_Total). On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total)...
March 12th, 2010 04:39 AM
by Dennis Tucker Go to last post
1 156
SUMIF or SUMIFS help by RLD
I have 2 sheets in one workbook (Sheet 1 and Sheet 2) Sheet 2 has 3 columns: A B C MAKE TYPE QTY 1 toyota compact ...
March 12th, 2010 01:11 AM
by Bob Phillips[_3_] Go to last post
1 166
Removing Of/And/The from Acronym Function by msnyc07
Someone kindly provided me with: Function FrstLtrs(MyStr As String) As String Dim temp Dim i As Long TmpStr = Split(Trim(MyStr)) For i = 0 To...
March 12th, 2010 12:16 AM
by msnyc07 Go to last post
0 132
Countif function by joyce los angeles
I need to find out how this countif works. In my excel class I did the countif like this. Statistical, countif, I selected the range, press F4, tab and with...
March 11th, 2010 11:46 PM
by T. Valko Go to last post
1 166
create a button to print certain tabs in excel 2003 by larry504
I would like a way to search every tab in 1 workbook and the same cell on each tab, than based an the value in the cell print the page or not
March 11th, 2010 10:34 PM
by Otto Moehrbach[_2_] Go to last post
1 157
formulas by kcarlson
how do i write a formula to add cell contents that are seperated by ten other cells?
March 11th, 2010 10:28 PM
by JLatham Go to last post
2 163
Acronym Function? by msnyc07
Is there anyway to generate an acronym on cell contents with a function? Ideally I could ignore certain words e.g. of, the, and, etc. and then for the first...
March 11th, 2010 10:15 PM
by msnyc07 Go to last post
2 124
Conditional Formatting for 4 conditions by Steve
How can I set up conditional formatting for the following: 3.5 = red 2.5 - 3.49 = yellow 2 - 2.49 = green 2 = blue Thanks, Steve
March 11th, 2010 10:13 PM
by Steve Go to last post
2 146
countif?? by Liz
i have a list of peoples ages.. i need a formulat that tells me how many people are aged from 0-19, 20-24, 24-25 etc. im using countif but i cant figure out...
March 11th, 2010 09:32 PM
by ker_01 Go to last post
2 139
Running Sum by Jessica
How do I calculate a running total for specific functions? My example is as follows A B C D ...
March 11th, 2010 08:10 PM
by Bernard Liengme Go to last post
1 141
Averaging every 5th cell while omitting zeros by Erika
Greetings! Thank you for your interest in my question, I have been bashing my head in trying to figure it out. In a column, I want to add every FIFTH cell...
March 11th, 2010 07:56 PM
by Bernard Liengme Go to last post
5 282
2007 δΈ*ηš„ε·₯ε…·εˆ—ι*…δΈ*: 資料--資料ε·₯ε…·--假θ¨*η‹€ζ³εˆ†ζž--資料葨, θ«‹ε•ι€™εŠŸθƒ½ζˆ‘ε¦‚δ½•εœ¨2003η‰ˆδΈ*ζ‰Ύεˆ°??? by 在2003δΈ­ζ‰Ύ2007ηš„εŠŸθƒ½
2007 δΈ*ηš„ε·₯ε…·εˆ—ι*…δΈ*: 資料--資料ε·₯ε…·--假θ¨*η‹€ζ³εˆ†ζž--資料葨, θ«‹ε•ι€™εŠŸθƒ½ζˆ‘ε¦‚δ½•εœ¨2003η‰ˆδΈ*ζ‰Ύεˆ°???
March 11th, 2010 07:08 PM
by Gareth_Evans (InterCall EMEA)[_2_] Go to last post
2 151
Multiply Cell Values which include text units by DaveR
I have a formula in cell G13 that shows "=B13*C13". Is there a way that i can multiply cell B13 which has a number format and reads "61 Units" to cell C13...
March 11th, 2010 06:57 PM
by Bob Phillips[_3_] Go to last post
6 219
what function to use? by TJ
What function do i use? eg. DATE PAYMENT CODE 01/03/2010 J96 01/03/2010 B24 02/03/2010 ...
March 11th, 2010 02:35 PM
by Jacob Skaria Go to last post
2 133
Formating cell by Comparing two cells for value by AJK
I have a column of data and I want to use conditional formating to compare the current cell with the one above. If the cell above is the same as the current...
March 11th, 2010 01:17 PM
by ANOOP Go to last post
2 179
Search Function in Discussion Groups Home by JPDS
The search function does not work properly. Yesterday I filed a new thread labelled Autofill, have tried searching but it does not appear anywhere. Also, if...
March 11th, 2010 10:24 AM
by JPDS Go to last post
0 164
Totalling data from several workbooks to a Summary Sheet by Phillip Anderson
I am trying (unsuccessfully) in creating a formula, that will allow me to total data from several workbooks, to a Summary sheet within Excel. Does anyone...
March 11th, 2010 06:48 AM
by L. Howard Kittle Go to last post
1 205
Post New Thread


Display Options
Showing threads 2201 to 2220 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:29 AM.


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