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
Can a "lookup" be added to an IF Statment? 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 19th, 2009 06:25 PM
by Kiley Go to last post
0 181
Make Object(s) Visible by Dennis
How would I make an object visible/invisible depending on the contents of a cell (for instance, making a block arrow visible when the number in a cell drops...
May 19th, 2009 06:24 PM
by Gord Dibben Go to last post
2 204
How do I print only cell contents of a Excel 2007 spreadsheet? by Johnny Page
Some of the cells in my spreadsheet have complicated formulas that I want to save on paper. But the only way that I have found to print them is to cut and...
May 19th, 2009 06:00 PM
by Don Guillett Go to last post
1 187
Can a column be formated to make any entry in that column capitali by Lynda
If there is an entry in that column then it will always be an X. It needs to be capitalized. If there a way to just enter X and not shift X? Microsoft...
May 19th, 2009 05:59 PM
by Gord Dibben Go to last post
1 125
Custom Sorting by A. Roger[_2_]
Hello, I have an inventory sorted by ascending part numbers(smaller to largesr). But i would like for the order to start with numbers that begin with a 0...
May 19th, 2009 05:49 PM
by Otto Moehrbach[_2_] Go to last post
3 159
MACRO's by arangoa79
I work with imported data that varies in size. In order to prepare the data for analysis I take the same repetitive steps. I know using a macro would make...
May 19th, 2009 05:48 PM
by Gord Dibben Go to last post
3 148
Automatic/Manual Calculation by Scott D[_2_]
Sometimes, when I open a workbook, the calculation setting has been changed from automatic to manual. I have never in my life change this setting. It seems...
May 19th, 2009 05:36 PM
by Gord Dibben Go to last post
1 136
Filter - Blank vs Space by Matthew
I was suprised to see that a Blank is treated identical to a cell containing a single space. I needed this in order to preserve section formatting while...
May 19th, 2009 05:32 PM
by Matthew Go to last post
0 204
Combine rows and add semicolon by Lost in Microbiology
I have inherited a spreadsheet with a column for e-mail addresses. I need to combine all of the addresses to send a single e-mail to each person in the list....
May 19th, 2009 04:53 PM
by Gord Dibben Go to last post
2 197
I keep getting arrowheads in my cells. How do I get rid of them by Rettmarion
These arrowheads can go either in a vertical or horizontal directions and once thee ,I can't get rid of them. They can be on the line or in the cell.
May 19th, 2009 04:47 PM
by Gord Dibben Go to last post
1 160
= sign in formula changes to + when adding a cell or name by Steve
I trying to make different row within a list appear based on the content of a couple of other cells. Have tried using vaildation/list and then enter the...
May 19th, 2009 04:02 PM
by Steve Go to last post
2 171
Drop Down Problems by lightbulb
I've created a drop down list and when I click the arrow to see my choices, the text in the drop down box is really tiny! There are only 2 options in the...
May 19th, 2009 03:49 PM
by Gord Dibben Go to last post
1 124
CHANGE THE RIBBON AFTER THE INSTALLATION OF ADDIN "MOREFUNC" by FARAZ QURESHI
Upon installation of the excellent AddIn of Morefunc I have the Formulas Tab quite changed. Any idea of how to change the same to return a set of desired...
May 19th, 2009 03:31 PM
by FARAZ QURESHI Go to last post
0 162
Files saved as csv files are actually saved as text files? by Queen_Of_Thebes[_2_]
I am opening txt files in Excel, importing them using the wizard and then saving them as csv files for use in another application. However the upload into...
May 19th, 2009 03:04 PM
by David Biddulph Go to last post
2 131
Financial Year Weeknum by Trevor Aiston
Is there a switch/way in excel to return week numbers from a date other than 1st Jan. I would like to be able to calculate the weeknumber from 1st april-31st...
May 19th, 2009 02:52 PM
by Sheeloo Go to last post
1 149
IF Statment more than 7 stacked ? by keeny
Hi I am trying to completed this statment up to "Z" Whats the best way to do this ? Excel...
May 19th, 2009 01:57 PM
by David Biddulph Go to last post
4 133
How to I filter one list based on another list? by Erlend
I have one customer-list showing which of our customers have been active the last year (list1), and one list showing all of our customers and their adresses...
May 19th, 2009 01:48 PM
by Erlend Go to last post
2 109
Help to create this by Marco
Hi. I need help to create this: I've got my actual view like this: (Rows) ID DInicio DFim 3000 38279 38340 3000 38353 38561 3000 38578 38927 and I need to...
May 19th, 2009 01:44 PM
by Don Guillett Go to last post
6 260
How do I number pages consistently using different files? by sswillis
There are about 12 files and they need to be combined. Knowing that all 12 files will be 70 pages total, how do I number each file so that the pages will be...
May 19th, 2009 01:36 PM
by sswillis Go to last post
4 183
find unique records by frankfurtjoe
how do i look through a column of data and create list of the unique entries not showing the number of duplicates ie apple, pear, orange - and create a new...
May 19th, 2009 01:30 PM
by Jarek Kujawa[_2_] Go to last post
1 128
Post New Thread


Display Options
Showing threads 19901 to 19920 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 11:56 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.