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
Track Changes History Worksheet by cathym
In a shared password protected workbook, I would like to keep the History worksheet displayed all the time. Currently, every time I open up the workbook, I...
February 5th, 2010 06:44 PM
by cathym Go to last post
0 109
limited cell movement by thebusinessbus
I cannot move my cursor on one of my worksheets to any cell outside of the range of A1:N125. There are locked cells within this range that are blocked once...
February 5th, 2010 06:18 PM
by Eduardo Go to last post
2 167
Nested subtotals in incorrect order on large worksheets by 'Wyn
I have found that the higher level subtotals are in the wrong order on long spreadsheets. Has anyone else got this problem or solved it?
February 5th, 2010 06:04 PM
by Dave Peterson Go to last post
1 153
Function needed by Jen_T
I was curious if there is a formula that I can use to check if a cell contains any of the values below? "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408",...
February 5th, 2010 04:48 PM
by Jen_T Go to last post
2 76
Frequency by Amar
I used the Frequency function to analyze a set of real values with one decimal place. I think that the Frequency function was applied properly with the...
February 5th, 2010 04:13 PM
by Teethless mama Go to last post
1 95
Stopping duplication within Data validation by SNA400
I hope someone can help me with these problems! I am using Data Validation for selected vehicles on runs, but I need to stop people assigning a duplicate...
February 5th, 2010 03:26 PM
by Luke M Go to last post
1 88
Search for data in Excel and hide rows by Bjarne Jensen
Hi newsgroup, Has come upon an interesting challenge ;-) I have to search through an Excel sheet for a lot of data. I would like to have the rows without...
February 5th, 2010 03:20 PM
by Luke M Go to last post
2 101
Excluding a column from range in COUNTIF function by connole99
Does anyone know how to exclude a column from a range in the COUNTIF function? Example: =(COUNTIF($A:$N,B1)=0)*(B1"") but I want to exclude the B column...
February 5th, 2010 03:09 PM
by Eduardo Go to last post
3 126
Find the cell ID of last row in the column and use it in SUMIF for by YY san.[_2_]
Hi, I have this formula to find the cell ID of the last row in a column: =ADDRESS(MATCH(9.99999999999999E+307,'IT hours'!A:A),1) eg.. if the result is...
February 5th, 2010 01:20 PM
by Bob Phillips[_3_] Go to last post
2 76
need a formula by Aaargh
I'm trying to set up a formula that will check the value of a cell, then based on the value of that cell, will insert another value....i.e. If C2 =1, then G2...
February 5th, 2010 11:25 AM
by Gareth_Evans (InterCall EMEA)[_2_] Go to last post
8 67
help creating a time function by Josh
Hello, I am trying to create a time function that will look at a typical day and add the hours. Then show how many hours after 8 is overtime. I have the...
February 5th, 2010 09:57 AM
by David Biddulph Go to last post
8 117
SUMIF and text by Silja
I am looking for a way to use the SUMIF function on text. I have a sheet with several different words in A column and different values in the B column. For...
February 5th, 2010 09:31 AM
by Silja Go to last post
3 62
need help with a solution - maybe vlookup? by Noetic76
Hi, I have a list of documents with unique IDs that were delivered; electronically, posted or faxed. There are duplicates in the ID column because some docs...
February 5th, 2010 05:59 AM
by Noetic76 Go to last post
3 72
data consolidation by Stupac
I created a worbook with multiple pages. I then consolidated the data. I had to save it under a new worksbook name. In this new worksheet I need to be...
February 5th, 2010 05:09 AM
by Bernie Deitrick Go to last post
1 104
Formula in dropdown list by David Pickering
I am using Data Validation / dropdown to allow a user to select either a static entry or a calculated one. There is a line of products a1=apple b1=banana...
February 5th, 2010 05:02 AM
by David Pickering Go to last post
2 95
Bill Payment Form by JWR
I am looking for a simple form to record bill amounts due each month, due date, and when bill was paid. I did not see something like this in the Templates,...
February 5th, 2010 04:41 AM
by Fred Smith[_4_] Go to last post
6 71
#REF! error with Multiple Documents by zxcvbnm6000
I keep receiving a #REF! error when I try to use VLOOKUP to find data in one document and bring it to another. If both documents are open all the numbers are...
February 5th, 2010 03:25 AM
by zxcvbnm6000 Go to last post
7 124
list in data validation by benji
in a cell I have Data validation with validation criteria to Allow List. Now my list is a long list of 3 alphabet codes such as ACE AET AMN ARC ARM ASL ATG ATS
February 5th, 2010 12:34 AM
by L. Howard Kittle Go to last post
4 118
printing by SBAIG
Hi, I am having trouble with printing.I do not know how to print page number 2 out of 5 pages in 1 worksheet of 1 workbook.Basically the question is ''print...
February 5th, 2010 12:26 AM
by Teethless mama Go to last post
2 59
printing by SBAIG
tHi.I am having trouble with choosing the pages and printing them.Basically the question is '' print out page number 2 only out of 5 pages''?in one worksheet...
February 5th, 2010 12:03 AM
by SBAIG Go to last post
0 54
Post New Thread


Display Options
Showing threads 3221 to 3240 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 03:01 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.