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
How will hyperlink cell reference update after copy paste? by bjry
When I hyperlink a cell and then copy paste it to another cell, the reference still says the same. Is there a way for the cell reference to get updated just...
May 12th, 2009 05:10 PM
by bjry Go to last post
2 170
Forecast Formula by Sam
Hi, I have a table as per the appended below table. Now I want to forecast what I am going to be doing on sales rate for the 10th of May or for a later date...
May 12th, 2009 05:03 PM
by Iriemon Go to last post
1 121
ROUNDUP to nearest 1/16 (in decimals) by [email protected]
How can I ROUNDUP a number to the nearest 1/16? I currently have a column with 1/16 increments listed in decimals: 1/16 = 0.0625 1/8 = 0.125 3/16 =...
May 12th, 2009 04:55 PM
by David Biddulph Go to last post
5 159
Repaymen of loan excel sheet with grace period etc... by Morten
Hi, Can anyone help on this problem: Trying to build a spreadsheet for repayment of a loan, would like 3 variables: 1) No of yrs for repayment 2)...
May 12th, 2009 04:24 PM
by JoeU2004 Go to last post
7 125
pivot table- need cell indentifier to repeat in each row by joeinnc
When setting up a pivot table and your first column is a unique indentifier, how do yuo have that repeat for each row when you pivoted data for columns to...
(Multi-page thread 1 2)
May 12th, 2009 04:24 PM
by Liz Go to last post
11 256
Value of particular column by kashish
Formula for A column If B = Y then there will be value in C column or D Column (any one column has value) Value of C or D should come in A For...
May 12th, 2009 02:13 PM
by kashish Go to last post
3 92
Countif – Multiple column criteria – with “does not contain” by Nick
Hi Masters! Help Excel 2003: 3 columns data. (F, G, AA) The last 2 columns are numeric data. 1st one is not numeric data but names. (i.e. Carl, Ron etc...)...
May 12th, 2009 02:12 PM
by Glenn[_6_] Go to last post
4 114
Counting Cells With Text by DonArturo
I would like to be able to count the number of cells within a range that contain text, excluding those that are strictly numeric values. For example,...
May 12th, 2009 01:49 PM
by DonArturo Go to last post
4 100
Formula to run report by Rosemarie
what is the formula to run report with the following requirements: job code #, and effective date in 10, 12, 16 and 20 weeks increments?
May 12th, 2009 01:18 PM
by Rosemarie Go to last post
2 99
3 zero instead 1 zero by javadez
hello dear, i want type 1 zero in excel and type 3 zero instead 1 zero. what can i do? thanks for your help.
May 12th, 2009 12:32 PM
by mubashir aziz[_12_] Go to last post
2 84
how to create row with data by rafael
imagine i have two rows: name and color: mary blue ken brown will blue what i want is having, in another row, just the names that have blue eyes,...
May 12th, 2009 12:20 PM
by Ashish Mathur[_2_] Go to last post
3 78
Calculating Dates by Gaza[_2_]
I want to create a formula so that when I enter a date in one column and a number value in another column it adds the date and the number value and...
May 12th, 2009 10:57 AM
by Tuukka Go to last post
7 92
how to find cubed root of a number by westvette
I want to calculate the radius of a sphere knowing its volume. volume = 4/3Pi r3 r3 = volume/ 4/3Pi r= cubed root of r3 How do I find this cubed root.
May 12th, 2009 10:47 AM
by Jacob Skaria Go to last post
2 71
IF Function in Excel by Superboy
Hello, I want to write an "IF" Formula using dates and blank cells. ie if Cell A2 is blank, use the date calculated in cell A1. However, if cell A" has a...
May 12th, 2009 09:56 AM
by Superboy Go to last post
2 60
Duplicate Rows by Nate
I have a sheet with a number of rows which I'd like to be able to create 2 instances of with out having to copy paste etc. Is there a formula that will...
May 12th, 2009 09:04 AM
by JBeaucaire[_92_] Go to last post
3 78
Create A Master List From Several Lists by Timbo
I have workbooks one per year with codes in Column N and Categories in O. The codes and data vary from year to year so a code i.e. AKC for the Category...
May 12th, 2009 07:59 AM
by mubashir aziz[_11_] Go to last post
5 81
HELP! Need to sum columns where credit balances are shown as ###CR by ahwelch
I just got a huge trial balance from a client that shows debit amounts as positive and credit amounts with a "cr" after the number. This makes it impossible...
(Multi-page thread 1 2)
May 12th, 2009 07:17 AM
by T. Valko Go to last post
10 145
How do I select cells for a specific month in Excel 2003? by HelplessIdiot
-- Many Thanks HelplessIdiot
May 12th, 2009 07:15 AM
by HelplessIdiot Go to last post
4 109
Filtering the Column headers that contains data for resources by Max
I have an excel with the following information A1 - Is a dropdown which will have names of the systems (EAI,Mediation,CDF ...,All) Row2 will be header...
May 12th, 2009 06:58 AM
by Max Go to last post
0 107
subtotals in excel by me2jr2
I use the subtotal function in excel every month. This month I just can't get it to work. It gives me a circular reference error. I can't figure out what...
May 12th, 2009 06:07 AM
by Martin Fishlock Go to last post
1 102
Post New Thread


Display Options
Showing threads 11181 to 11200 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 01:28 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.