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
April 15th, 2010 08:30 AM
by macropod[_2_] Go to last post
2 108
Validation list with formula? by SaM
I'm not sure I am going to explain this right - but here goes. I have a project open in excel - the main page is a form to fill in, with which I use drop...
April 15th, 2010 12:12 AM
by Ashish Mathur[_2_] Go to last post
3 96
Formula referencing a changing range?? by Stacie2410
I have a workbook that has several tabs. I'm only working with 2 for the problem that I'm having though. The first tab, which holds all my data, is called...
April 14th, 2010 10:55 PM
by T. Valko Go to last post
3 151
compare -neg and +pos number that cancel each other in a colum by checkQ
I saw your response to to Chom krosopon in July of 2005 and I noticed that the formula worked perferctly. My problem is similar to Chom's however my data is...
April 14th, 2010 10:39 PM
by Casper Go to last post
4 147
Relative Link remembers absolute path?? by [email protected][_2_]
I have a linked file that has about 6 source files that it is dependent on. The links have been setup relatively. The user's open the source files and the...
April 14th, 2010 10:03 PM
by Bill Snow[_2_] Go to last post
2 129
2 worksheets--3 questions by Anne
Hello! I have a workbook that tracks patients (mothers) and contacts (mom's family members). The mother worksheet is named MAT_INF and the contacts one is...
April 14th, 2010 09:57 PM
by Bob Phillips[_3_] Go to last post
3 144
Protecting Sheets with drop down boxes by Dolores Gomez[_2_]
I have a spread sheet that has drop down boxes with functions and validations. I want to be able to protect this spreadsheet so that users can only be able...
April 14th, 2010 08:28 PM
by Duke Carey Go to last post
1 122
Excel 2003 - deleting Duplicates under conditions by Cath
Hi I am using Excel 2003 and have a data list displaying Reference Numbers and Test Results. If reference numbers fail a test they will be retested until...
April 14th, 2010 08:25 PM
by Duke Carey Go to last post
2 99
Changing Source Data using V-lookup by Kevin
I am trying to use one spreadsheet that has v-lookup formulas in it and change the source data sheet with the current month's information. When I change the...
April 14th, 2010 08:14 PM
by Bernard Liengme Go to last post
2 100
data links on subsequent worksheets by TerriK
I have main data entered on worksheet 1 that I have linked to subsequent worksheets, however when there is no data on worksheet 1 I get 0's printed in the...
April 14th, 2010 08:10 PM
by Duke Carey Go to last post
2 132
Help needed with If & Today function by Nemo
I have a row where I have dates of the month - C2:AG2. I want a formula, where if I enter a text in the corresponding row, and if the date is not todays...
April 14th, 2010 07:50 PM
by Glenn[_6_] Go to last post
4 191
vlook up w- multiple variables by chilitodd
For my vlook up in excel 2007, I want to return data to populate cell B2 (xxxx) from column 3 ($21,745) of a data set when the value in cell A2 (360 19318)...
April 14th, 2010 06:22 PM
by chilitodd Go to last post
2 122
Auto Calculate Keeps Resetting to Manual by Shirley
Cannot get this to stay at automatic. Any thoughts why? New workbook, nothing complicated (b2/b3). I save the document, reopen and set to recalculate. The...
April 14th, 2010 04:58 PM
by Bernard Liengme Go to last post
2 142
invisible color by cindyhosch
I can only see blk/white on my worksheets. I can change text color and/or highlight a cell and it appears as though nothing happened. But - when I pull up...
April 14th, 2010 04:53 PM
by lllorigirl Go to last post
4 105
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR) by excelrookie
Anyone see the problem with this, it isn't working. I am tring to put all the results (in columns AF:AR) into a cell, based on the input Z3 (The input will...
April 14th, 2010 04:34 PM
by excelrookie Go to last post
2 110
Help with function, not sure which one by excelrookie
I don't want to use a macro...is it possible to do the following with functions? New York Joe Tim Kim Jane ...
April 14th, 2010 04:31 PM
by excelrookie Go to last post
4 120
If argument by DonaMil
I am looking to portray an argument that "if" a certain text is entered into a given field then another field which is used as a calculation would return an...
April 14th, 2010 04:20 PM
by Eduardo Go to last post
1 83
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY by Steve
I have 8 numbers in general format in the J column of the main! sheet: 20100416 20100527 20100427 20100513 20100414 ...
April 14th, 2010 03:46 PM
by Steve Dunn Go to last post
3 125
Nested IF(OR(AND) Statement with Two AND Conditions by chiefs19
I am using Excel 2003 and could use some assistance with a complex Nested IF statement. Here is the criteria: IF Salesorg=NAW1 AND Salesdivision=N4 AND...
April 14th, 2010 02:55 PM
by chiefs19 Go to last post
5 171
consolidating data for a report - HELP - pivot tables no good for by UKMAN
Hi The spreadsheet shows people on up to 20 differant projects with each project have 2 colums of data i.e. BY and BZ. My example cuts it down to 4 columns...
April 14th, 2010 02:40 PM
by UKMAN Go to last post
0 127
Post New Thread


Display Options
Showing threads 1281 to 1300 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:42 PM.


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