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 Liz J[_3_]
I'm looking at a spreadsheet that has 3 columns: A: Name B: Expense 1 C: Expense 2 I have a maximum amount, $1,000, that I can spend on both expenses, but,...
October 13th, 2009 10:58 PM
by smartin Go to last post
1 125
Can't find Column A in my worksheet by Ayo
The first column, Column A in my worksheet is not visible and I have tried everything I know to make it visible and it's still not showing. Any ideas?
October 13th, 2009 10:34 PM
by Bill Sharpe Go to last post
3 117
Naming sheets after a range by kefee85
I have a list of dates in A1:A15 I would automatically like to name sheets 3-18 after the values in that range.
October 13th, 2009 09:51 PM
by Dave Peterson Go to last post
3 124
Vlookup to return the next true value by Donna
I am working to find a solution to a vlookup that I need to have return the value for the first 11 characters of the vlookup for the last characters not...
October 13th, 2009 09:14 PM
by Donna Go to last post
2 119
Toolbar has changed - how to return to normal by jmcclain
Using Excel 2003 - Sometime today - I must have hit something that caused some of the usual toolbar buttons to disappear. How can I restore it to the wy it...
October 13th, 2009 08:13 PM
by jmcclain Go to last post
1 118
Subtract 1, 2 and 3 months from the text "September" by wx4usa
I have column A with the text string "September" and I need to have column B show "September" minus 1 month or "August". Column C "July" and D "June" Then...
October 13th, 2009 07:48 PM
by T. Valko Go to last post
8 113
inserting an autoshape into a chart by NG
Hello everyone, I have a smiley that changes color (yellow, green, red) based on a percentage, I made that work with some help. What i need is to insert...
October 13th, 2009 07:40 PM
by NG Go to last post
9 159
How to look up a value in a list and return multiple corresponding by worksheet functions
I can make the formula look up anumber but i need it to look for a specific word. What can i replace "SMALL" with to have the formula bring all intances of...
October 13th, 2009 07:35 PM
by Bernie Deitrick Go to last post
3 113
Displaying arrow in a dropdown list within cell by Lionheart
I created a dropdown list in Excel 2007 using the 'Data Validation' function. I checked off 'In-cell dropdown' and finish process. However, whenever I...
October 13th, 2009 07:09 PM
by T. Valko Go to last post
2 110
auto renumbering rows with blank spaces by edithprado
I am so stumped on this one simple function! I am compiling an inventory list of key rings we loaned to employees. Since there are different departments with...
October 13th, 2009 07:07 PM
by edithprado Go to last post
5 115
Cell formulas by Vickie T.
I have two cells that I am using an IF function so that if there is no data in cells used in the formulas, the cell is blank instead of showing 0.00. I want...
October 13th, 2009 07:07 PM
by Vickie T.[_2_] Go to last post
2 114
paste web without date format by tombugg55
When i paste from a web page, Excel 2007 automatically changes any text that might be considered a date into date format. In the Excel help, it indicates...
October 13th, 2009 07:01 PM
by Joel Go to last post
1 124
I am stumped. Help with Formula... by Rob
I want A1 to equal the contents of a cell in the "last row with contents". If not, then I want the cell in the row above it, and if not I want the cell in...
October 13th, 2009 07:01 PM
by Rob Go to last post
5 96
Basic Graph help by Confusicous
I need an opinion for a simple line graph in which the data in b17, c17, d17 are on the Y axis and the data in b9, c9, d9 on the x axis. I only need one line...
October 13th, 2009 06:52 PM
by Jon Peltier[_2_] Go to last post
2 99
Unable to get column width I want in Excel 2007 by Instructor44
,I am an instructor teaching Excel 2007. There is an assignment where my students have to change the width of several columns. They would like a column width...
October 13th, 2009 06:32 PM
by Bill Sharpe Go to last post
9 89
Identify Duplicates that are not identical by KFM
I have two spreadsheets that contain duplicate names of idividuals. One spreadsheet includes the first name in column "A" and the last name in column "B"....
October 13th, 2009 06:17 PM
by Jacob Skaria Go to last post
4 121
Excel 2007 Pivot Table navigation without mouse by Jim[_66_]
Anyone have any experience navigating Excel 2007 pivot tables through keyboard shortcuts or voice recognition? Possible? Options? Thanks
October 13th, 2009 06:13 PM
by Jim[_66_] Go to last post
2 125
macro to add numbers based on set criteria by David
Hi Everyone, i am trying to create a macro that will add numbers based on set criteria here is an example I have a file over 20K lines and about 200 columns...
October 13th, 2009 06:01 PM
by Joel Go to last post
6 92
How to fill up blanks by deeds
I am trying to fill a range of blanks with the data at the bottom of the selections. Example: I want to fill the "x" cells above the 200 with 200, I want...
October 13th, 2009 05:52 PM
by deeds Go to last post
4 130
Get information from one sheet to another by holly2327
I have two data sources and I'm dumping one source onto sheet1 and the other onto sheet2. I have a common id that is unique in each sheet in column B in each...
October 13th, 2009 05:52 PM
by holly2327 Go to last post
2 97
Post New Thread


Display Options
Showing threads 11781 to 11800 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 05:50 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.