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 Reverse Sort Order / Thread Starter Last Post Replies Views
"Group" and sorting data by Joel Bergsman
One of my Excel spread sheets somehow (?) acquired the word "group" in its name, and many menu choices disappeared -- including the sort function. How do I...
October 6th, 2003 07:09 AM
by acw Go to last post
2 366
"how to combine multiple lines into a pull down option?" by eric_mc2
I am trying to create a series of single line pull down menus in excel. I am trying to create something like a 'build your computer to suit' like you would...
July 4th, 2005 03:06 AM
by Anne Troy Go to last post
1 117
"IF" by gbeard
I have 6 different sheets in my workbook 1 for each of my 5 different districts in my company and one main sheet. Is it possible to put the district number in...
April 5th, 2005 05:47 AM
by Nick Turner Go to last post
3 92
"IF" formula question by Barb1
I have been working with this formula for two hours and can't get it to work right. Can anyone help? The criteria is--If less than 400 pages, but not equal to...
April 5th, 2005 05:27 PM
by Duke Carey Go to last post
2 133
"if" formula to sum several cells... by Massimo
Hi all, I need to sum some consecutive cells in a row, depending on a number in another cell. For instance: If the cell contains 2 sum A1 + B1 If the...
June 7th, 2005 07:26 PM
by Massimo Go to last post
3 113
"IF" function by Natasha
Hi, does anyone know how to use "if" function which enables 2 actions to be performed at the same time given that a particular condition is met? For example,...
October 16th, 2003 09:33 PM
by Natasha Go to last post
0 251
"IF" Function . . . PLEASE HELP!! by MarthaSue
Creating a field ticket on excel . . .in one area of the worksheet the user will choose between 5 diferent choices (length of tubing)in a drop down bar. Each...
May 12th, 2005 09:26 PM
by JE McGimpsey Go to last post
3 106
"IF" function is not working O.K. by Enrique
"IF" function in an old Excel version before 2002, worked OK when comparing cell value("text") versus "Text argument". Now using Excel 2002 (10.432.4219) is...
December 10th, 2003 06:07 PM
by Chip Pearson Go to last post
1 264
"IF" Function limited to 7 in a formula.... need 14 by VonSinkum
Wow... the limits of Excel are really hurting my sheets here. The limit of 7 uses of "IF" is a killer. Here is my formula, but I still need to add 7...
August 14th, 2005 10:15 PM
by VonSinkum Go to last post
2 190
"IF" function: Can a calculation be an answer? help plz by Kentucky Insurance
Using Excel XP. Trying to determine commissions that are on a sliding scale. Excel will not let me use a calculation as an answer in "value if true" or "value...
(Multi-page thread 1 2)
October 16th, 2006 05:29 PM
by FMWGARY Go to last post
13 246
"If" or "sumif" by Peter
I am holding a function where if the person comes alone, the price is $300, but if he brings his wife, the price is $400. I am collecting deposits, and will...
September 16th, 2003 10:06 PM
by Ken L Go to last post
4 311
"If" statement? by baileygrrrl
Is there a way to have excel to highlight each instance of a particular word in a file? Eg. I need excel to look for the word "delivered" in a worksheet...
February 3rd, 2005 10:06 PM
by Bob Phillips Go to last post
2 124
"IF..THEN.."formulas by Mari P
Can you do "IF...THEN..."formulas in EXCEL and How? Thanks Mari
February 1st, 2005 01:33 PM
by Arvi Laanemets Go to last post
2 102
"Intelligent" copy to cells below by cindee
I want to copy a cell to the blank cell below it and continue to copy until another value is found, then I want to copy that new value into all the blank...
October 2nd, 2003 12:31 AM
by J.E. McGimpsey Go to last post
1 424
"Justify" Vertical Alignment does not work for Merged Cells by Steve
Selecting "justify" for a cell's vertical alignment automatically increases the row height (when "Wrap" is also selected) as more or less text is added or...
October 19th, 2003 07:52 PM
by Tom Ogilvy Go to last post
1 471
"last saved" date and hour of a file in a cell of the worksheet by Rey
Is it possible to see the "last saved" date and hour of a file in a cell of the worksheet of the file. I try to find a solution for a long time without...
December 30th, 2003 04:41 PM
by GerryK Go to last post
6 294
"Last saved" information by Gustavo Strabeli
Hi! Does anyone know a VB code which can return me the name of the user who last saved the worksheet? Thanks, Gustavo.
July 28th, 2004 07:14 PM
by Gustavo Strabeli Go to last post
7 357
"Last saved" information by Gustavo Strabeli
Hi, Frank! Another question: I have 2 sheets in the same workbook. The function "DOCPROPS" is on sheet2. If someone updates any information on sheet1 and...
July 29th, 2004 08:23 PM
by Gustavo Strabeli Go to last post
0 274
"Lock down" date formating by Jumbo Shrimps
I need to ensure dates entered into certain cells are in "##/##/##" only. If for example, someone enters "Dec. 10, 2003" in the cell, an error message should...
December 9th, 2003 05:40 PM
by Andy B Go to last post
1 177
"Look up" with multiple hits? by Olle Nyström
There is a range of "look up" formulas that finds a value in one column and delivers a value from a different column in the same row. But all of them seemes to...
February 27th, 2004 03:20 PM
by JulieD Go to last post
5 213
Post New Thread


Display Options
Showing threads 41 to 60 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:25 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.