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 Reverse Sort Order Last Post Replies Views
SUMPRODUCT Issue by Adam Lauzon
I am trying to set up a summary page from data collected over the past few months. The 2 colums of data that I am trying to reference are a date colum in a...
March 9th, 2004 05:37 PM
by Frank Kabel Go to last post
2 100
Excel Table Help by Adam Miller
I have created a table that displays the weekdays of the month, who has the highest commission and how much they earnt in the form: Date | Seller| Commission...
June 8th, 2009 05:11 PM
by Herbert Seidenberg Go to last post
2 143
Conditional Formatting by Adam Ronalds
How can I use the formula function in conditional formatting in order to indicate if a formula in the cell has been altered?
(Multi-page thread 1 2)
June 17th, 2008 04:34 PM
by Adam Ronalds[_2_] Go to last post
10 140
Using VBA to make a user input a note when making changes to a cel by Adam Ronalds[_2_]
How can I program in VBA to require that a user inputs a note (I want a blank note to pop up) when they change a number in a cell? For example, if I have...
June 24th, 2008 05:54 PM
by Gord Dibben Go to last post
3 85
Excel Number Sorting by Adam Rothschild
I have imported some data into excel as text because if I do so as general, excel chops off some zero's placed after decimal points. (for example 151.0 151.00)...
March 3rd, 2004 08:19 PM
by Frank Kabel Go to last post
4 390
OFFSET Function by Adam Smith
Dear Folks, Using Excel 97, primarily, Recently discovered the usefulness of the OFFSET function. For example, I keep track of the Consumer Price Index,...
January 30th, 2004 01:07 AM
by Adam Smith Go to last post
2 390
Excel date intervals look up by adam smith
Hi Im trying to lookup a value based on date intervals for academic years, using birthday to find the year. So for example if I enter a birthday of 22/09/1997...
January 29th, 2010 11:53 AM
by Jacob Skaria Go to last post
1 71
Excel 2007 Nested formulas by Adam Stegeman
In cell AD4 I want a number to appear. I want it to count how many times the letter "C" appears in column E IF column F has the word "July" in the...
October 20th, 2009 09:21 PM
by muddan madhu Go to last post
2 128
Formula help - possible vlookup/hlookup combination with IF or oth by adam&ellie
HI, I'm trying to work out a formula that will bring back data from a table as below 1 2 3 4 5 60 20 10 6 ...
June 13th, 2008 10:32 AM
by Jarek Kujawa[_2_] Go to last post
3 81
Help with this formula. by adam.carson
I am working with a bunch of qualitative data, such as Poor, Fair, Good, and Exc. I am trying to give a value to each response and total up each person's...
April 23rd, 2008 12:43 PM
by Sandy Mann Go to last post
1 76
date range by [email protected]
excel spread sheet
March 13th, 2008 02:26 AM
by Max Go to last post
1 42
select date in date range by [email protected]
I want to be able to do the following: A B 1 26/03/2006 $20.00 2 1/12/2006 $40.00 3 1/10/2007 $100.00 4 5 6
March 13th, 2008 06:56 AM
by Max Go to last post
7 64
time in minutes and seconds and .00 by adam11m
I don't know how to format a cell so when I enter a number it is not in a date format. I want the number to be displayed as minutes, seconds, and 2...
July 24th, 2007 06:53 AM
by T. Valko Go to last post
2 95
Combining multiple lists into one ! by Adam194
I would greatly appreciate anybodies help with this: I have 6 lists (defined as Nicki, Cathy, Dawn, Alison, PatJoy and MikePauline). I downloaded an example...
June 19th, 2006 02:06 PM
by Adam194 Go to last post
0 104
Cell calculate only once by adamb
How can I have a cell calculate only once? Example: Equation in cell D7 "=A1+B1" So if I create this equation in cell D7 yesterday and A1 and B1 both...
May 26th, 2006 07:41 PM
by Bernie Deitrick Go to last post
1 67
I want cell A1 to equal $A$2 even after inserting line at A2 by adamb2000
Whenever I make cell 'A1' = '$A$2 and insert a line at 'A2', the value 'A1' gives me is that of 'A3'. I would like 'A1' to equal whatever number inserted into...
May 29th, 2006 12:20 AM
by adamb2000 Go to last post
2 89
VLookup a Vlookup by adamb2000
Hi, I have created a VLOOKUP function which looks up a value in a different Workbook. Bases on this returned value I would like to create a VLOOKUP which...
June 28th, 2006 10:54 PM
by adamb2000 Go to last post
4 134
Making a Nonconsecutive range of data consecutive by [email protected]
I have a range of data of x and y values. Each point has a checkbox. If this checkbox is checked on, I want to include the data in a linest type function,...
June 17th, 2008 10:17 PM
by [email protected] Go to last post
0 108
Return Value that exists more than all other values by AdamE
Good Afternoon, I'm having trouble trying to write a function that returns the value in a given row that exists more than all other values in that same...
November 20th, 2007 11:07 PM
by Max Go to last post
9 62
LOOKUP functions from cells containing formula . . . by adamhudson
I am using Excel from Office XP, version 10.0.4302.0. I am trying to use the LOOKUP function to return a fee or rebate value (in dollars) based on a fuel...
July 22nd, 2004 08:20 PM
by Frank Kabel Go to last post
1 325
Post New Thread


Display Options
Showing threads 1221 to 1240 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:58 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.