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
Merging different sheets by vassilis
hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment...
March 14th, 2010 07:59 AM
by vassilis Go to last post
5 204
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 04:53 AM
by Stilltrader47 Go to last post
2 184
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 04:20 AM
by T. Valko Go to last post
4 190
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 04:18 AM
by Laura11 Go to last post
0 147
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 14th, 2010 12:49 AM
by Mike Middleton Go to last post
1 178
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 11:06 PM
by Joe User[_2_] Go to last post
1 173
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 08:32 PM
by Bob Phillips[_3_] Go to last post
1 148
"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 08:28 PM
by SRU Go to last post
0 147
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 07:06 PM
by Gord Dibben Go to last post
1 134
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 06:46 PM
by Dennis Tucker Go to last post
2 125
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 05:09 PM
by marstinson Go to last post
1 125
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 05:01 PM
by Bob Phillips[_3_] Go to last post
5 154
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 04:43 AM
by Joe User[_2_] Go to last post
2 119
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 02:11 AM
by Dave Go to last post
1 127
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 02:07 AM
by Dave Go to last post
2 174
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 01:27 AM
by Bob Phillips[_3_] Go to last post
4 131
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 13th, 2010 12:03 AM
by Fred Smith[_4_] Go to last post
1 120
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 11:18 PM
by Glenn[_6_] Go to last post
1 124
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 09:38 PM
by Mike H Go to last post
7 173
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 08:46 PM
by Mike H Go to last post
1 147
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 09:59 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.