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
Entering Values and Updating Next Empty Cell in a Range by Stilltrader47
Please help, I hope there is a macro. Every time I enter a value in cell j29, I would like it to post to the next empty cell in range b139:b150. For...
March 14th, 2010 03:53 AM
by Stilltrader47 Go to last post
2 102
vlookup, concatenated named range by patti
My function: =VLOOKUP(G7,"Asset"&F7,1,FALSE) "Asset"&F7 is a concatenation for a named range. If i type in manually, it works. Concatenated, it does...
March 14th, 2010 03:20 AM
by T. Valko Go to last post
4 126
Control On Cell Input by Laura11
Hi, how do I put a control on a cell so that only a "-" i.e. -8 can be entered or conversely a control so that only a positive number can be entered. Thanks...
March 14th, 2010 03:18 AM
by Laura11 Go to last post
0 85
hypothesis testing by Jaybird
The question is: using a 0.10 level of significance, is there evidence that the population mean is above $300 values given: sample of 25 students, X(bar) =...
March 13th, 2010 11:49 PM
by Mike Middleton Go to last post
1 81
Info between worksheets by Eileen
All i want to do is fill a cell with a number and that number to go into a cell on another sheet as well.
March 13th, 2010 10:06 PM
by Joe User[_2_] Go to last post
1 111
Sumif Question by stevestr
I need help with a sumif formula. I have two spreadsheets. On my report spreadsheet I want to use a sumif function that looks at two columns in the other...
March 13th, 2010 07:32 PM
by Bob Phillips[_3_] Go to last post
1 94
"Send to mail recipient" is dimmed out on my tool bar by SRU
I often use the "Send to mail recipient" option in my Excel 2007 to send a single sheet in an email, rather than attach the file. But this option is now...
March 13th, 2010 07:28 PM
by SRU Go to last post
0 91
Highlight cells by Goyo
I am trying to highlight a cell if it is empty. However, the cell in question is pulling data from another page in the worksheet, so the cell is not empty...
March 13th, 2010 06:06 PM
by Gord Dibben Go to last post
1 77
Percentages by Don
I have a spreadsheet that I use to track manpower usage. I have been asked to reduce hours or days worked by 3% on average per month and not to exceed or...
March 13th, 2010 05:46 PM
by Dennis Tucker Go to last post
2 74
Excel file size increased 3 times after saving!!!! by Exceller
Hi all, I have a very strange situation with my Excel workbook. I created Excel workbook with conditional formulas (no other formulas) which total size is 3...
March 13th, 2010 04:09 PM
by marstinson Go to last post
1 78
Multiple IF function by Anthony
Hi, I'm trying to create a Life Insurance Calculator within Excel. I've already done a VLOOKUP to get the Relevant Premium Rate, but now I need to be able to...
March 13th, 2010 04:01 PM
by Bob Phillips[_3_] Go to last post
5 80
Possible problem with PMT and FV functions by Keith
Hello, I must be missing something -- here’s the question. If I use the Excel PMT(rate, number of periods, beginning balance, 0,0) function, I can...
March 13th, 2010 03:43 AM
by Joe User[_2_] Go to last post
2 71
Consolidating Data Between Worksheets with Duplicates Removed by JodySmithPharmD
I am interested in tracking lab values that my staff enter into a daily worksheet. I would like to compile monthly percentages (% low, % in range, % high)...
March 13th, 2010 01:11 AM
by Dave Go to last post
1 87
How do I lock ONLY the formatting on an excel sheet? by Court
I want to Lock the formatting on an excel sheet so when i sort the data in the sheet the background colors and cell formatting stay in place, and just the...
March 13th, 2010 01:07 AM
by Dave Go to last post
2 126
Reconstructing a table by Ted Metro
I can pull a table out of a repository that looks like this -- Bill Mike Sarah Jill Tom Project 1 0 10 0 0 0 Project 2 40 0 0 12 0 Project...
March 13th, 2010 12:27 AM
by Bob Phillips[_3_] Go to last post
4 76
On Time Calculation by Teri
I have two columns, one is Sched Dely Date/Time (O5) and the other is Actual Dely Date/Time (N5). If my Sched Dely Date / Time is 04-Mar-10 05:00 PM and...
March 12th, 2010 11:03 PM
by Fred Smith[_4_] Go to last post
1 71
numbering pages in footer by StarZ_Keeper
In the old excel, 1997, we could start a new page with a different page number rather than 1. I have many pages in one worksheet and many worksheets. I want...
March 12th, 2010 10:18 PM
by Glenn[_6_] Go to last post
1 78
Hiding worksheets by Curtis[_6_]
Is there any way to keep users from un-hiding worksheets in a workbook? However they do require access to other sheets (not hiiden) within the workbook...
March 12th, 2010 08:38 PM
by Mike H Go to last post
7 99
I can still select & manipulate locked & protected cells in '07 by Jesse
I have an Excel 2007 worksheet that rotates between locked and unlocked rows. I protect the document correctly (checking the boxes “select unlocked cells”...
March 12th, 2010 07:46 PM
by Mike H Go to last post
1 92
auto height by lgreggs
I have merged cells across the bottom of a worksheet for a comment area. I have formatted the text to wrap. How do I get the area to auto format the height?...
March 12th, 2010 07:41 PM
by Gord Dibben Go to last post
1 86
Post New Thread


Display Options
Showing threads 2161 to 2180 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 12:51 PM.


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