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
Multiple function queries in same cell by Donna
Hello. Is it possible to have two functions in the same cell, even if one is already nested? Example: Function for...
June 10th, 2009 09:08 PM
by Donna Go to last post
2 99
Auto Assigning Number to Excel Invoice by Angela Rose
I have been using a template created in Excel 2000 for my business invoices for 7 years. This template had a tool box which allowed me to assign a...
June 10th, 2009 09:07 PM
by Gord Dibben Go to last post
5 154
undo feature non-functioinal in Excel by Bonnie P
Why is the undo feature not working in Excel? Both it and the forward feature are "greyed out" on my toolbar. Undo only appears functional if I have not...
June 10th, 2009 08:30 PM
by Bonnie P Go to last post
0 85
IF _Different Values- by Rick.[_2_]
I'm working on a formula for Split Shift (SS), Having different hourly rates and different hours worked. For example, Rate 1: @ $8.25/hr if the employee (EE)...
June 10th, 2009 07:54 PM
by Bernie Deitrick Go to last post
1 102
Percentage of a count data in Pivot table by Krish
I have a pivot table pulled from a database. The database has Invoice number, line number, product number, customer number and operator code taking the order....
June 10th, 2009 07:32 PM
by Krish Go to last post
0 83
If specific # of certain characters in a range, "OK", if not "Aler by Steve
I have various codes(letters) in cells B1 thru N1.(see below) If B1:H1 has 5 or more C's , I want "OK", if not "Alert". In this case, it would be "alert'...
June 10th, 2009 07:05 PM
by T. Valko Go to last post
4 95
how to use data table by steve
I've used it in previous versions, but not in 2007. I have 2 input cells that I would like to vary. I assume the top and left side of highlighted area will...
June 10th, 2009 07:04 PM
by steve Go to last post
3 79
Test whether formula in cell is an expression or a number/text by Fred Holmes
Excel 2000 Is there a test criterion for use in conditional formatting of a cell that tests simply whether the formula in the cell in question is 1) a number...
June 10th, 2009 06:18 PM
by T. Valko Go to last post
3 97
YTD budget formula based on current actual input by Sanj
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 ...
June 10th, 2009 06:04 PM
by Ashish Mathur[_2_] Go to last post
4 142
Please help by Nina
I'm working with a spreadsheet that has +/- on the far leftside of the page. Once you click on the icons they collapse the row. How do i do that with other...
June 10th, 2009 05:37 PM
by Ashish Mathur[_2_] Go to last post
2 74
Ranking Question by PJFry
I am dealing with a dataset that has a many ties in it. This is a list of sales from 2008 to current, by customer and I need to rank on total sales. In...
June 10th, 2009 05:24 PM
by T. Valko Go to last post
3 75
Entering time by C
Is there a way I can enter various times and have the colon automatically inserted for me instead of having to manually enter it every time?
June 10th, 2009 05:10 PM
by T. Valko Go to last post
1 85
What type formula to use? by CE
Hi, I need a formula that takes into account todays date before it adds the row range. The spreadsheet I'm working with has 2 tabs. On the second tab are...
June 10th, 2009 04:47 PM
by T. Valko Go to last post
6 116
Help with this formula by Nelson
Here is what I have =SUMIFS((L8:L23, B8:B23),"=D03KHLL",year(A8:A23),=2008)) L8:L23 are the amounts Criteria 1 B8:B23 (which are the part numbers...
(Multi-page thread 1 2)
June 10th, 2009 04:32 PM
by T. Valko Go to last post
14 158
Formula question by Kristal_81
I am trying to find a formula to copy the rows that contain "suzanne" in column C and "open" in column B to another worksheet...anyone have any ideas???
June 10th, 2009 04:29 PM
by Jacob Skaria Go to last post
2 77
getting rid of blanks by thislibrarian
Is there a way to automatically remove blanks from my colums of text data. I want to remove the blank cells and move the others up without having to select...
June 10th, 2009 04:06 PM
by Jacob Skaria Go to last post
1 87
Page setup stuck on portrait mode by bobtex
Excel 2003 SP3 Vista Ulimate SP1 Page Setup is not changing from portrait to landscape mode. Landscape selection button works, but it will not change from...
June 10th, 2009 02:57 PM
by Simon Lloyd[_281_] Go to last post
3 171
Help neededin adding an additional "Warning Flag" to my current lo by Danny Boy
I need assistance in editing a portion of the formula below. As it stands this formula (which I have written into cell (AD4) WORKS, and does exactly what it...
June 10th, 2009 02:50 PM
by Luke M Go to last post
1 105
Lookup multiple values by willemeulen[_31_]
A need to retrieve a price depending on three values Material, class and size Material = B5 Class = C5 Size = D5 Vlookup column table Sheet1 A4:H69
June 10th, 2009 02:34 PM
by willemeulen[_40_] Go to last post
3 116
how do i use the roundup function by Leprechan
I have prepared salary scales using simple formulas where the calculations are based on a % increase. I would like the answers to be rounded up eg: $27.997...
June 10th, 2009 02:30 PM
by Luke M Go to last post
8 86
Post New Thread


Display Options
Showing threads 10241 to 10260 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 03:55 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.