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
Days to Years ? How by Corey
Currently i have an induction register that has 3 worksheets. sheet1 = Date the induction was carried out sheet2 = Frequency that the induction...
August 11th, 2006 06:45 AM
by Arvi Laanemets Go to last post
3 50
require macro or code for purchase order to do the following: by jatman
i have a purchase order sheet that works good. it makes two copies when it prints, purchase order increases on its own. what i want it to do is print only...
August 11th, 2006 06:02 AM
by jatman Go to last post
0 69
Using Nested RANK functions by tuph
I have a sales ladder which ranks my people by the % difference between budget and sales to date, but not everyone has made a sale yet and the % difference is...
(Multi-page thread 1 2)
August 11th, 2006 05:18 AM
by Leo Heuser Go to last post
11 162
large page number in cenetr of sheet by Ollie
After setting up and printing a ws, the page number shows up in large type in center of page - spread across cols G thru L. How can I remove it?
August 11th, 2006 04:46 AM
by Ollie Go to last post
5 94
Question about SumIF by zhuanyi
Hello, I know this is really confusing, but...anyway.... Say for example I have 4 columns of data, the first contains, say, the name of the sales man, second...
August 11th, 2006 04:39 AM
by JMB Go to last post
3 90
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates by John
Hi folks, I have 2 rows of numbers, top row 100 110 120 110 120 2nd row 6 5 5 6 6 i need to find the highest number i the top row, which is...
August 11th, 2006 04:34 AM
by Biff Go to last post
3 62
Extract specific value from a long text string by Dinesh
Hi, I like to extract a value at the end of text string. The long text string ends with "Inc. for - 356989.23". Is there a formula where I can just extract...
August 11th, 2006 04:24 AM
by Ron Rosenfeld Go to last post
4 72
IF and Date Functions by Christ4
I want to have a "date due" to be 7 days after the "date out" unless the student option=true, then I want the "date due" to be 1 day after the "date out." ...
August 11th, 2006 04:18 AM
by Max Go to last post
3 57
centering items by yoursagain2002
how do i center items in a spreadsheet i am working on. i am very new to this :confused: --...
August 11th, 2006 04:16 AM
by Miguel Zapico Go to last post
1 54
August 11th, 2006 03:11 AM
by Dinesh Go to last post
0 41
hi - is there a formula that matches text in different columns? by rkat
Hi, I have two columns of email addresses, say 1000 in Column E and 500 in Column F. I would like to sort Column F so that each individual email address in...
August 11th, 2006 02:35 AM
by Max Go to last post
2 39
How to do a cartesian join in Excel? by rkg
I have two worksheets, each having the primary key values stored in column A. I want to create a new worksheet wherein each value in Column A of worksheet 1...
August 11th, 2006 02:27 AM
by Debra Dalgleish Go to last post
1 58
Product type function H.e.l.p by George
Hi, I would like to know if there is a function or combo of functions that can produce the following long form calculation: =(1+A2)*(1+A3)*(1+A4)-1 Where A2,...
August 11th, 2006 01:46 AM
by George Go to last post
2 49
Reference Worksheet Name by Leann
I would like to be able to change the name of a worksheet and have it change in all of the formulas that reference it as well. Is there an easy way to do this?
August 10th, 2006 11:02 PM
by Dave Peterson Go to last post
6 79
Searching for duplicate numbers by Uncle Guinness
Morning All Please forgive this newbie question ... hopefully the answer will be a whole heap simplier than my explanation. I have a spreadsheet in which I...
August 10th, 2006 10:59 PM
by Trevor Shuttleworth Go to last post
2 68
microsoft excel by lisa
I need to make a cell once used automatically move a column over and up so I can have lists side by side, how do I do that? for example A25 once filled needs...
August 10th, 2006 10:57 PM
by Gord Dibben Go to last post
2 85
Function help by Carolj
This is my first post here because I have a problem that I cannot solve. I don't have a lot of experience with Excel so this may be a simple fix, so here...
August 10th, 2006 10:50 PM
by Gord Dibben Go to last post
5 47
Copy data based on a count... by Brian
Howdy All, I have a spreadsheet that I want to copy certain info off to separate sheets. The sheet contains locations and dates, and I do a countif on the...
August 10th, 2006 10:36 PM
by Brian Go to last post
0 57
Updating Info from a previous worksheet by Tara working away
I have a worksheet that shows "mileage" such as 999999 and I will manually update on a new worksheet todays mileage #, I have a space commited to show the...
August 10th, 2006 10:18 PM
by Tara working away Go to last post
0 66
How to hide running total in successive cells in a column by JenniferAnderson
I have a spreadsheet with a column titled current balance. When I enter costs into other line items and this column updates with the new balance, the...
August 10th, 2006 10:16 PM
by Marcelo Go to last post
3 73
Post New Thread


Display Options
Showing threads 51001 to 51020 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 09:41 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.