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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
IF Statement by Kiley
I have one row for each person for the following IF Statement to look at. Is there a way to add a "lookup" to the IF Statement to look at a particular...
May 21st, 2009 12:53 AM
by Max Go to last post
1 143
copy formula up by Pammy
Is there an easy way to copy formulas up without dragging up? I have a spreadsheet that has 4500 rows of info, I want to add the latest infor at the top...
May 21st, 2009 12:02 AM
by Gary McCarthy[_2_] Go to last post
2 150
How do I perform extended calculations in a Pivot Table in Excel 2 by learnlearn52
How do I perform extended calculations in a Pivot Table in Excel 2003? From the raw data in a worksheet, I created a Pivot Table shown below. How do I: 1....
May 20th, 2009 11:58 PM
by learnlearn52 Go to last post
4 161
formatting of cells used as abs or rel reference is lost by mnoll
How do I maintain the originally formatting of text in a cell (ex. certain characters - but not all - a certain color or bold etc) when using this cell as an...
May 20th, 2009 11:33 PM
by Sheeloo Go to last post
1 155
Using dropdown list in from one file to another? by Lex
How can I capture drop down list elements from spreadsheet and use them in seperate excel form? Thx
May 20th, 2009 11:29 PM
by Sheeloo Go to last post
1 237
What to use? Chart, PIvot Chart, or something else? by Jessie P
I am trying to Make a VERY LARGE (72x36) Chart in excel 2007. I have the layout that i want but i am trying to make it easier to change data. without doing...
May 20th, 2009 11:27 PM
by smartin Go to last post
1 175
v look value dependant on 2 cells by Tacklemom
what I am trying to do is calculate a formula based on the following: what I am trying to do a generate a V look up dependent on 2 cells I need to look at...
May 20th, 2009 11:17 PM
by T. Valko Go to last post
2 152
How reference cell in different worksheet by laavista
I’m comparing values in worksheet 2 against values in worksheet 1. Once found, I put the cell,column info in the 2nd worksheet indicating where it was...
May 20th, 2009 11:00 PM
by Don Guillett Go to last post
7 177
Help on lookup functions by Scott
I have a chart with anywhere between 1 to 12 columns, and anywhere between 1 to 144 rows. The columns used are anywhere between K-V, and rows range from 5...
May 20th, 2009 10:58 PM
by T. Valko Go to last post
2 141
NumberFormat by danpt
Range("A1:E3") contains 1 to 4 digits arithmetic numbers. I want to format the range in "0000" format and still retain its arithmetical properties. This macro...
May 20th, 2009 10:55 PM
by Gord Dibben Go to last post
3 144
Figuring out hours worked by Matt
In cell F3 I am trying to get the hours work from the start time in cell D3 and the finish time in E3. I can not locate the forulma for this?
May 20th, 2009 10:42 PM
by Matt Go to last post
3 153
Data Import Question by Steve Haack
I need to import data into Excel for statistical analysis. The data is being collected from thousands of PC's in an organization. Each of them generates a...
May 20th, 2009 10:37 PM
by Gord Dibben Go to last post
2 179
SUMIF and Named ranges by Henry
How can I get this formula to work. The idea is to create a dynamic formula where the it sums a range based on the date as it changes each month....
May 20th, 2009 10:36 PM
by Dave Peterson Go to last post
3 133
Equation by MDL
I need an equation in a cell (P4) that will depend on: 1) if the dollar amount is under $200,000 (in cell F17), the number I need in cell P4 will be .0075 of...
May 20th, 2009 10:18 PM
by MDL Go to last post
4 145
Merge Cells option is disabled sometimes, how do I enable it? by Darla
The MERGE CELL option has previously worked and still works on some sheets. There are times when it is disabled. How does this happen and how can I change it?
May 20th, 2009 10:18 PM
by Gord Dibben Go to last post
3 165
merge cell is disabled by Fesco
how will I enable merge cell and other toolbars. the file was shared and tried to save as and make another name but still can't make it unshared. What will I...
May 20th, 2009 10:17 PM
by Gord Dibben Go to last post
1 136
.xlsx by at22
How do I open OpenOffice docs in Office (.xlsx for example)
May 20th, 2009 10:15 PM
by Bob I Go to last post
1 141
Data Validation - enter first letter and find? by Don
Is there a way in Excel where you can start typing the name and it will try and fill it out from a list? I know in Access, you can create a form that when...
May 20th, 2009 10:14 PM
by Gord Dibben Go to last post
1 228
workbooks names used by derek
How do I save workbook names so that I can use them tomorrow Derek
May 20th, 2009 10:11 PM
by Gord Dibben Go to last post
2 185
Drop down lists and custom views functioning together by Lori Brehmer[_2_]
I was using Custom views within my excel worksheets however when adding drop down lists as a feature the customer views were automatically disabled. Below...
May 20th, 2009 10:09 PM
by Gord Dibben Go to last post
1 133
Post New Thread


Display Options
Showing threads 19801 to 19820 of 139764
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 04:46 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.