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
Summary by Eliz
i have a transaction of a few people with the figures. i can only get the total amount using the filter. so, i want to have a summary in another worksheet....
March 10th, 2010 04:04 AM
by Eliz Go to last post
2 123
Calculating Problem: Desperate :( by cionnaith
Hi. I have run into a snag trying to figure out how to make one of my cells calculate the way I need it to. Here is the rundown: I have a column of data that...
March 10th, 2010 03:09 AM
by cionnaith Go to last post
4 248
Excel 2007 Macro/VB Question DDE Question by MadDog22
Hi, So I have a column of cells that are the combination of a other cells in the row and a result of a few "if functions." The value comes out exactly as...
March 10th, 2010 02:47 AM
by MadDog22[_2_] Go to last post
1 151
COUNTIF across sheets in columns by meekjj13
I am trying to count names that appear in multiple sheets. All of the names appear in the column K in 32 sheets. Is there away to do this? Thanks for any...
March 10th, 2010 02:00 AM
by Pete_UK Go to last post
1 122
picture by raismisuaween
picture of pictures of pictures of eyes picture of pictures of
March 10th, 2010 01:11 AM
by raismisuaween Go to last post
0 125
using vlookup to find data outside a specified range by Art
I am sure I can guess the logical answer to this questions, but... I have a sheet (Sheet 1) in Excel 2007 with a list of courses. The Course ID is in Column...
March 10th, 2010 12:09 AM
by Max Go to last post
1 159
Trying to calculate average call length by pilates_jocelyn
Usually our phone system spits out a report for me, but it's broken right now... and I have to provide this info to another department ASAP. I'm trying to...
March 9th, 2010 11:46 PM
by pilates_jocelyn Go to last post
6 146
"clear contents" is not working. a list is still enforced. by peterg11
suggestions would be much appreciated.
March 9th, 2010 11:05 PM
by Otto Moehrbach[_2_] Go to last post
1 134
Data Validation: Validate Specific Day of the Week? by Ted[_15_]
Users will enter a date in cell D6. The date they enter must be a Monday. How can I validate for that? Thanks, -Ted
March 9th, 2010 09:59 PM
by Ted[_15_] Go to last post
2 165
Help requested for nested conditional formulas referencing other c by Bermie
Hello--i can better explain the problem with an example: 24h 1wk change Person A 1 0 -1 Person B 0 1 1 Person C 0 0 0 Person D 0.25 0.25 0 Person...
March 9th, 2010 09:50 PM
by Bermie Go to last post
3 134
Earliest time in a range by pete
Hi, I have a range of dates and times, and the following will give me the latest time: {MAX((Data!$D$2:$D$5000=B13)*(Data!$F$2:$F$5000))} However, I now...
March 9th, 2010 09:25 PM
by pete Go to last post
3 158
Can Sheet name be part of formula for a cell (+ sheet name) by Leslie
Worsheet name will change from template. Would like worksheet name to auto print in cell on separate worksheet. Can this be done?
March 9th, 2010 07:28 PM
by Eduardo Go to last post
1 131
Lookup Function? Employee Number with Employee Name by Lance Hebert[_2_]
I have a spreadsheet that I believe that I need some form of LOOKUP function, but have been unable to find the type that I need. I have a column "C" that has...
March 9th, 2010 06:25 PM
by Eva Go to last post
1 147
How do I change the fill color of a cell using an "IF" function by donschap
I'm trying to change the fill color of a cell based on a condition (value).. FOr example if a value is less than 7, fill the cell color in red
March 9th, 2010 04:48 PM
by Fred Smith[_4_] Go to last post
6 116
connecting formulas by Chris
I’m working on a Excel sheet where I have to connect two formulas as follows: A1 and B1 have together a value of 20%. if A1 is 12%, B1 should automatically...
March 9th, 2010 04:09 PM
by Luke M[_4_] Go to last post
6 132
matching only once by Donna[_5_]
If you could help me tweak this. I am using this formula: =If(COUNTIF(C$1:C$7,A1),"",A1) and I want it to put in Col B the amounts from col a that do not...
March 9th, 2010 04:01 PM
by Teethless mama Go to last post
3 136
AutoFill Changing Wrong Value by Lisa
I'm trying to create an analysis sheet that gathers data from 100 worksheets within the same workbook. I want the same cell reference in each sheet, but to...
March 9th, 2010 03:02 PM
by Pete_UK Go to last post
6 147
I know this is obvious but .. by Bony Pony[_3_]
I'm just not seeing it this morning! I have 3 columns: Col P16 to P500 contains Project Names Col Q16 to Q500 contains Pricing Mechanism descriptions Col X16...
March 9th, 2010 02:23 PM
by Max Go to last post
3 128
VLookup by L.Mathe
I'm working with Excel 2003 and created a workbook (1 worksheet) to compare 3 columns of data. Each column varies in number of rows, but could have as many...
(Multi-page thread 1 2)
March 9th, 2010 01:45 PM
by Max Go to last post
14 272
Sheet selected, automatic return to top of sheet by MIKEY
Hi all. Is there a formula that...When a sheet is selected via a macro button, you are automatically returned to the top of the selected sheet...or, when...
March 9th, 2010 11:58 AM
by Stefi Go to last post
7 182
Post New Thread


Display Options
Showing threads 2261 to 2280 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 01:28 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.