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
Look-up a value within an interval by Christine
I would be very grateful if someone could provide me with a formula that will look up the closest minimum and maximum based on a value and bring back the...
(Multi-page thread 1 2)
September 26th, 2008 06:14 PM
by Christine Go to last post
12 241
criteria for two different cells in a count if function by Judy Rose
I have one column where I want to count if it equals a certain value, I need to sum all the rols that have that value that are of a certain date that would...
September 26th, 2008 05:43 PM
by Peo Sjoblom[_2_] Go to last post
2 141
Populate a spreadsheet from a data set by rev
I have a data set from access that I exported into Excel. Now I am trying to write a formula that will summarize the data based 3 criterias (appropriation,...
September 26th, 2008 05:13 PM
by Sean Timmons Go to last post
1 137
Data Validation & Dependent Lists -from same list? by blucajun
Using the instructions on Contextures.com about Data Validation & Dependant Lists, I have created a form that contains the following columns with drop down...
September 26th, 2008 04:58 PM
by T. Valko Go to last post
5 242
Option Box protected errror by Whois Clinton
I have option boxes from the "Forms" toolbar. On the sheet there are some cells with formulas I would like protected. When I protect the sheet a couple of...
September 26th, 2008 04:34 PM
by Whois Clinton Go to last post
0 133
protecting and unprotecting by Fusion1337
I googled the group before posting, but I wasn't able to make any use of what I found (my VBA-fu is still pretty feeble). Anyway, I was wondering how to do the...
September 26th, 2008 04:03 PM
by Don Guillett Go to last post
5 143
Calculating % by Erica
I am trying to calculate the percent of budget used according to hours worked and pay rate. In order to calculate the hours worked i used the following...
September 26th, 2008 03:51 PM
by Erica Go to last post
2 119
VLookUp - Questions - Spreadsheet setup by Cpviv
Hi, I need to setup a spreadsheet that has criterias go like this: Cell A3 - Enter a key word. It will give me a list of the searched key words (maybe...
September 26th, 2008 03:13 PM
by Spiky Go to last post
3 138
Macro_AND function by Aline
There is an formula I’d like to add it in a macro. =IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N") I want it to automatically fill up for the rest of row....
September 26th, 2008 03:10 PM
by Aline Go to last post
1 111
Arrow keys when cells locked by sam
Can anyone help. In a protected worksheet when the up or down arrow keys are used the cursor moves to row 1 (if you use down it moves over one column; up...
September 26th, 2008 01:41 PM
by Gaurav[_6_] Go to last post
1 113
Get data from specific collumn by KT
Hi, I have a date in sheet one cell A1. In sheet two I have monthly data. Now If the date is 30/6/2008 I want data from June collumn and so on. Hope I\m...
September 26th, 2008 12:28 PM
by KT Go to last post
4 125
SUM of a 3D calculation by Werner Rohrmoser
Hi, I have a book with Sheet1 through Sheet10. On Sheet2 through Sheet10 there are numbers in cell "A1", "A2" and "A3". What I'd like to do is to calculate...
September 26th, 2008 11:49 AM
by Werner Rohrmoser Go to last post
6 249
Average by Alexey[_2_]
Hi I have three cells O28,O29,O30. In cell O27 I want to display the average of the other three cells, but only if they have values in them. Not sure how to...
September 26th, 2008 11:40 AM
by Alexey[_2_] Go to last post
3 143
Lookup 2 columns of data, perform, match, output results by John
I have 2 worksheets containing data: 1st Worksheet contains Column N N1:1371 N2:1000 N3:1322 2nd worksheet contains Column A
September 26th, 2008 11:30 AM
by John Go to last post
2 121
XL2000 - Average/If/And Functions by LPS
My Excel 2000 workbook has two sheets, the first (Evaluation Detail) contains details about course evalutions per instructor. Column A is Course Name, B and...
September 26th, 2008 11:14 AM
by Bob Phillips[_2_] Go to last post
7 140
Pasting HTTP 'without' it being a clickable link?? by Robert Blass
I copied some test which included some URLS in it. When I past it I noticed the URLS were clickable which I wanted the URLS to be just plain text like the rest...
September 26th, 2008 10:52 AM
by David Biddulph Go to last post
2 110
Hyperlinks in excel from a list by [email protected]
Hi all I have 2 spreadsheets I'm trying to streamline. One has an overview by date and time of trainers and their scheduled courses, ie a basic group...
September 26th, 2008 10:41 AM
by [email protected] Go to last post
2 213
IF AND - need help with formula by lsgKelly
I have to write a formula that accomplishes the following task: I have a spreadsheet that has three columns. The columns are "Subs1" "Subs2" and "RATE1"....
(Multi-page thread 1 2)
September 26th, 2008 08:15 AM
by David Biddulph Go to last post
10 182
Tracking how my bets are going by Robbo
I have no idea how to use excel but have been told it will help me do what I am asking(if that makes sense) I bet on horseracing and want a sheet to How much...
September 26th, 2008 08:13 AM
by David Biddulph Go to last post
3 122
If A1=X cell d1 must be completed before row 2 can be used by Paul07
If the text in cell A1 = Cheque then other cells in row 1 need to be completed, one of which must be cell D1 which will contain the cheque number before...
September 26th, 2008 06:59 AM
by liuyann Go to last post
1 116
Post New Thread


Display Options
Showing threads 19841 to 19860 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 07:34 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.