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
group/ungroup protected sheets? by RLD
Is it possible to allow users to group & ungroup rows in a protected sheet?
March 25th, 2010 07:46 PM
by Gord Dibben Go to last post
1 138
Excel 2007 - Autocomplete Alpha List by Jannoth
In previous versions of Excel, if I added A,B,C,D,E to the first few rows of a column then dragged the AutoFill handle downwards, Excel would have recognised...
March 25th, 2010 07:24 PM
by Gord Dibben Go to last post
4 188
Jpeg links opening in Explorer instead of Picture Manager by stripedfrog via OfficeKB.com
I've set up a spreadsheet in Excel 2003 that has links to jpegs. I've gone back in to add more photos but am having problems with the links. I added 6 photos...
March 25th, 2010 07:14 PM
by stripedfrog via OfficeKB.com Go to last post
0 241
Nesting Lookup Functions by eionjess
Is it possible to nest an HLOOKUP in a VLOOKUP equation? Here's what I have: =VLOOKUP(C27,A2:B5,(HLOOKUP(D27+1,INDIRECT(A2),21) Each VLOOKUP lookup value is...
March 25th, 2010 06:29 PM
by Ziggy Go to last post
4 154
VLookup with Search for in String by Benjamin
I need to look for this value within a cell i.e. A1XT-4-0713-01-00021-1.PDF within Folder:Folder:Folder:Folder:FolderPath:A1XT-4-0713-01-00021-1.PDF then...
March 25th, 2010 06:14 PM
by Ziggy Go to last post
4 163
SUMPRODUCT help by Mark D
Good afternoon everyone I have the following 2 formula's that are working perfectly for me =(SUMPRODUCT((K9970%)*(B118=1),K78*'Base...
March 25th, 2010 06:01 PM
by Fred Smith[_4_] Go to last post
3 129
Repost - Functions on filtered data by LiAD
Afternoon, Sorry i forgot to put in the formulas concerned. Second time lucky! I have an excel sheet of 10 cols and 200 rows on sheet 1. Sheet 2 has a...
March 25th, 2010 05:34 PM
by LiAD Go to last post
0 139
Array formula to find date by Amylou
To trigger conditional formating. I tried being brief, but I couldn't figure out how and still be articulate. Each month we publish a catalog of our products...
March 25th, 2010 05:17 PM
by Amylou Go to last post
0 165
Print Preview Different than What I see in the Excel File by Kashmira
When I created an Excel file and inputed text data, it shows that it is within the column width in the file, but when I do a Print Preview, it shows that the...
March 25th, 2010 04:51 PM
by Kashmira Go to last post
0 168
Macros by AlwaysQuestions
I have recorded a macro to open up a service report I use all the time. I am able to open it only when I open Excel for the first time. After I close that...
March 25th, 2010 04:22 PM
by ericaamousseau Go to last post
8 125
Formula Needed for lowest three values in a Column by frankjh19701[_17_]
I need a formula that will find the lowest three values in a given row or column. I would like to be able to highlight them in different colors. Any/all...
(Multi-page thread 1 2)
March 25th, 2010 02:50 PM
by frankjh19701[_22_] Go to last post
12 369
Formula for multiple countifs by J.Scargill[_2_]
Hi, I would really appreciate anybodys expertise with the following 2 formulas; I have a worksheet that looks a bit like this - (A is days taken to deliver -...
March 25th, 2010 02:39 PM
by J.Scargill[_2_] Go to last post
4 110
Multiple IF function by Jecker
Any assistance will be greatly appreciated. I have a worksheet that contains employee information, another worksheet that contains current team structure....
March 25th, 2010 02:36 PM
by Jecker Go to last post
7 143
counting based on two conditions in excel 2003 by Anand[_5_]
I've a sheet with two option buttons (grouped). The data goes like A B C Name Process Role x a ...
March 25th, 2010 12:42 PM
by Bob Phillips[_3_] Go to last post
4 151
General Calculator by MIKEY
Hi all I have a SUM result in M8 (this is my sub total) I have a allocated cell Q8 to receive a final Total. Cells N8,O8,P8 will be allocated the functions...
March 25th, 2010 11:14 AM
by Gary''s Student Go to last post
1 149
How can I count values in multiple non-consecutive cells? by Kevin M.[_2_]
I'm trying to figure out what formula to use when I want to count how many times a value is found in a specific set of cells.
March 25th, 2010 10:28 AM
by Bob Phillips[_3_] Go to last post
1 149
Sumproduct, but errors in column by ker_01
I've been asked by a colleague to help tally some data, and sumproduct is the logical formula to use. However, the raw data has some N/A# errors in it, and I...
March 25th, 2010 10:26 AM
by Bob Phillips[_3_] Go to last post
6 177
HELP! by TJ
How can i combine two formulars together? =COUNTIF(L9:L453,"Deal*") =COUNTIF(A9:A452,"15/03/2010") Im trying to find out how many DEALS on a certain date
March 25th, 2010 10:21 AM
by TJ Go to last post
4 114
IF - more than seven arguments by Hannah
Good morning I would like to write an if formula that will provide me with the month (in words) if the date in a column falls between certain values, this...
March 25th, 2010 10:21 AM
by Hannah Go to last post
2 129
Entering Formula - Cannot select cell as it is hidden by formula by Jim
I'm using Excel 2007 When I'm entering a formula into a cell, the text of this formula if longer than the cell covers the cell to the right and then I cannot...
March 25th, 2010 08:22 AM
by Jim Go to last post
0 142
Post New Thread


Display Options
Showing threads 1821 to 1840 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 06:13 PM.


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