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
can't roundup sum by swell estimator
shouldn't I be able to roundup a sum? The only way I can do it is to first convert the sum to a number and roundup the number. That means 2 columns and I...
September 4th, 2008 03:48 AM
by T. Valko Go to last post
3 75
scroll with arrow keys problem by Accounts Diva
When using the arrow keys to scroll down a spreadsheet, I find the active cell disappears below the bottom of the screen. I have to use the scroll bar at...
September 4th, 2008 03:37 AM
by Peo Sjoblom Go to last post
1 64
Annuity Payments From A Present Amount by JRR
I am trying to figure out how to use functions in Excel to calculate an annuity from a present amount. Do you happen to know how I would do this? For...
September 4th, 2008 03:35 AM
by ryguy7272 Go to last post
2 100
Please HELP!!!! by Yitzhack
Hello again, I’m working on a project where I need to calculate the hours missed per day on a daily basis. The workbook needs to record every employee...
September 4th, 2008 03:28 AM
by T. Valko Go to last post
8 93
Need help with a formula by Nobody
I currently have a formula or function which is =SUM(B26-B17) what do I add if I want the total to appear in red if it is a minus rather that a...
September 4th, 2008 02:00 AM
by JMiller Go to last post
5 130
look ups by chrisgoods
hi im looking for a formula that will let me look up two values in one table array and return one value. For example: How would i look up a numerical value...
September 3rd, 2008 11:52 PM
by Max Go to last post
4 146
Excel formula question by Greg S
Is there a formula or function similar to DGET that returns multiple text records for specific criteria? I have multiple entries from the same date in an...
September 3rd, 2008 11:25 PM
by T. Valko Go to last post
1 93
Please help with vlookup function by JMiller
Hi, I am trying to copy data from sheet1 to sheet2. I cannot use the regular copy and paste function because if I make changes on the sheet1, will not...
September 3rd, 2008 10:48 PM
by JMiller Go to last post
0 74
View Locked Cells? by Nick Jenkins
Is there a way to show which cells have been locked without having to check each cell? I have a very large spreadsheet with multiple worksheets. There are...
September 3rd, 2008 10:37 PM
by Gord Dibben Go to last post
3 101
Novice user trying to use variables including text and numbers by Rachel Tulloch
I'm completely self taught so hope this is possible I've tried a number of formula but the nearest is =IF(($D$72)*($F$7100)*($D$7="NA"),0,1) what i need...
September 3rd, 2008 10:10 PM
by Spiky Go to last post
3 114
Linking Question by akemeny
In order to prevent excessive entries of the same information my company wants to link a master account list to the individual lists that we currently...
September 3rd, 2008 09:52 PM
by Spiky Go to last post
4 156
I've forgotten the password to unprotect a workbook in Excel. by Punkoloratura
How do I unlock a worksheet in Excel when I've forgotten the password?
September 3rd, 2008 08:48 PM
by FSt1 Go to last post
3 146
Check number within a range by djungst
I would like to check a number to see if it is greater than one number and less than or equal to another number and if it is perform a calculation on the...
September 3rd, 2008 08:45 PM
by Peo Sjoblom[_2_] Go to last post
2 116
Where can I get a template for 3-column (green) ledger paper? by TT
I have searched high and low for a template for the Wilson Jones G7503 3-Column paper...any ideas.
September 3rd, 2008 08:43 PM
by TT Go to last post
0 128
conditional formatting by Anne
how do i write a formula for a cell that i want to format if the date entered into the cell is within 7 days beyond a date in another cell. -- Anne
September 3rd, 2008 08:36 PM
by Glenn[_6_] Go to last post
1 83
Function works in one cell but not another by myssieh
Good Morning!! I am running Excel 2003 I have a function of: =AVERAGE(IF(G17:G210,G17:G21,"")) in M11 that is just calculating numbers and it works...
September 3rd, 2008 08:34 PM
by Duke Carey Go to last post
2 81
Sort by even and odd digits and copy to separate worksheet by K Drier[_2_]
This is a second function to a prior question wherein we removed an alpha character from the end of a number down the full length of a column. Now they want...
September 3rd, 2008 07:56 PM
by K Drier[_2_] Go to last post
3 172
Macro_AND function by Aline
There is an formula I’d like to add it in a macro. =IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N") I want it to automatically fill up for the rest of row. ...
September 3rd, 2008 06:46 PM
by Aline Go to last post
2 87
excel 2007 right click edit query by Koppite412
Hi Folks New to Excel 2007, seasoned at Excel 2003. I have set up an ODBC query, run it in MS Query and returned the data to Excel 2007. On my previous...
September 3rd, 2008 06:26 PM
by Duke Carey Go to last post
1 114
Protect cells by Tag1948
I want a cell like "Name" be locked, but the cell next to it to be open for entering a name. How do I do it?
September 3rd, 2008 05:36 PM
by Glenn[_6_] Go to last post
2 93
Post New Thread


Display Options
Showing threads 20821 to 20840 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:24 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.