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
Pivot table by PatJennings
In Col A is the Month (Jun,Jul,Aug) of transactions, listed in date sequence in another column is the last name of the salesman for each transaction. There...
September 6th, 2008 06:34 PM
by Roger Govier[_3_] Go to last post
5 73
sloping top rows in Excel by prints phil
How do I get the top row of cells to slope 45 degrees?
September 6th, 2008 06:04 PM
by Gord Dibben Go to last post
5 165
Why doesn't the alignment dialog box come up like the book shows? by [email protected]
I am taking an online course in Computer Applications, and working with Excel 2007, as that is what is required. They are instructing us to click on the...
September 6th, 2008 04:35 PM
by Rick Rothstein[_2_] Go to last post
2 94
copying a date into a text string by Looking for help
I have a date in cell b6 (format is custom m/d/yyyy) input value is 08/23/08 In column E18, I have a formula "b6-5" (format is custom m/d;@), the purpose of...
September 6th, 2008 02:57 PM
by Max Go to last post
3 88
Have worksheet changes cascade down? by Jeremy
Hello. I have a workbook in Excel 2007 that is made up of three different worksheets. I want to copy those three worksheets so there are a total of four sets...
September 6th, 2008 02:14 PM
by Jeremy Go to last post
8 90
named ranges question by Chris
I have a sheet that has formatted boxes of information in it. I would like to carry over the entire format to another sheet using the name of the range. Is...
September 6th, 2008 01:46 PM
by Don Guillett Go to last post
2 96
Print 100 Sheets by Hardeep_kanwar[_2_]
I have a workbook with almost 150 sheets. and i want to take the print of all sheets. Is it possible to give a single command to take all the print. Or its a...
September 6th, 2008 12:56 PM
by N Harkawat Go to last post
1 68
Using STDEV to evaluate a subset of a population by jdunnisher
I have a list of 500 items that I have ranked across 10 separate categories using the STDEV function for each individual category. I then SUM the standard...
September 6th, 2008 08:08 AM
by jdunnisher Go to last post
6 94
Problem with HLookup. Not sure if it is a bug or not by rockycho912
I have a table as setup below: 0 1 2 3 4 5 ... 59 60 (row A) 0 0.16 0.32 0.48 0.63 0.79 ... 9.34 9.50 (row B) 0 17 28 36...
September 6th, 2008 06:37 AM
by Bob Bridges[_3_] Go to last post
3 86
Adding up the number of times a month is in a column by stevesoul
I have two colums, of which column B has months and dates. Sometimes the date can be up to three times added, or not at all. I can't figure out a formula...
September 6th, 2008 06:21 AM
by Peo Sjoblom Go to last post
1 62
sumif formulas by ibhavn
I have a listing of salary figures for my organization. Several positions are currently vacant, but the salary needed to fill the position is still listed. ...
September 6th, 2008 03:29 AM
by Dave Peterson Go to last post
5 110
Lookup duplicate items in a list by Niall
Hello, I hope that some1 can help me. I have a spreadsheet which looksup a list in another sheet of the same workbook based on what account number is...
September 6th, 2008 03:06 AM
by Ken Johnson Go to last post
5 139
Calculating the distance customers live from a branch office by Steve Cornelius
I work for a bank in the Chicago area. We have a number of branch offices and are interested in determining how far our customers live from their bank...
September 6th, 2008 02:00 AM
by Ron Rosenfeld Go to last post
5 109
Custom HEX or BASE 33 Sequence by Mitch Matheny[_2_]
I want to create a custom numbering sequence in excel.... 0123456789ABCDEFGHJKLMNPQRSTVWXYZ (note that the letters I, O, & U are left out). My objective is...
September 6th, 2008 01:31 AM
by Harlan Grove[_2_] Go to last post
7 78
Viewing formulas for Print in Microsoft Office 2007 by Scharron25
I need to know how to change the view of the formulas from numerics to text. In my book it tells me to go to normal page layout and press CTRL +, but that...
September 6th, 2008 12:59 AM
by Scharron25 Go to last post
3 89
Create a conditional formula that results in another calculation by dyrret
I'm just learning to use Excel. I want to enter data in either column A (litres) OR column B (US gallons). Column C will convert to imperial gallons. I...
(Multi-page thread 1 2)
September 6th, 2008 12:54 AM
by JC-PS Go to last post
10 117
split single cells by Idaho
All I am looking to do is take a single cell and make into 2. I know I have seen vertical, horizontal, as well as diaginal line splits before, and I cannot...
September 5th, 2008 10:53 PM
by Idaho Go to last post
2 56
text substitution by Mark
I am trying to get the text in a specific cell to be replaced by the last text entered into a string of cells on a specific line.
September 5th, 2008 10:22 PM
by Mark Go to last post
4 54
Side to side scroll slide missing by 21 BillBoard
I somehow made the bottom (side to side) scroll bar vanish. Does anyone know how to get it back? I still have the up and down one.
September 5th, 2008 10:21 PM
by Spiky Go to last post
1 85
Performing date functions after getting cell address by rstasiunas
I have two columns in a sheet, approx 1000 rows. A1:A1000 contain the purchase date (i.e. 1/1/2000). I need to have B1:1000 display the date 3 years from...
September 5th, 2008 09:44 PM
by T. Valko Go to last post
1 70
Post New Thread


Display Options
Showing threads 20701 to 20720 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 10:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.