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
Restrict data entry to specified cells by ajsguinness
Hi, I'd like to be able to restrict new data entry to specified cells in a workbook. I'd like a method to say where data should be added, and then for that...
June 11th, 2009 03:36 PM
by ajsguinness Go to last post
2 128
Problem with Using "Multiply by 1" by A
I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip...
June 11th, 2009 03:27 PM
by A Go to last post
5 160
IF or VLOOKUP - help please ..... by Eán[_2_]
I have a coloum of dates dd/mm/yyyy and would like to return in a separate coloum the month eg, dd/04/yyyy = 'APRIL' can you let me know what formula I would...
June 11th, 2009 02:48 PM
by Roger Govier[_3_] Go to last post
4 100
If or VLOOKUP by Eán[_2_]
Hi I have a coloum of dates dd/mm/yyyy but would like in a separate coloum to show only the month - how would I write a formula to return "April" for all...
June 11th, 2009 02:22 PM
by Simon Lloyd[_288_] Go to last post
4 113
Internet Explorer opens jpeg from a hyperlink ??? by Roman
when I created a hyperlink to a jpeg image located on my hard drive, why does internet explorer open the image?? I am using Office 2000 and IE7 +XP S3 I...
June 11th, 2009 01:23 PM
by Roman Go to last post
0 100
HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003? by TEJAS SHAH
I WANT TO CREATE THE PRICE RANGE IN EXCEL 2003 WITHOUT USING THE "IF ELSE" COMBINATION. SR PRICE RANGE 1 1500 2 3500 3 4750 4 ...
June 11th, 2009 01:19 PM
by Jacob Skaria Go to last post
3 114
Give me a Function by Fareez
Dear Friends Lokking at folowing chart ,please help me solve my...
June 11th, 2009 01:09 PM
by Eduardo Go to last post
1 102
use sumif / Sumproduct for year data by Chris26
Hi I have a set of daily data (total rainfall) for100 years. What would be the easiest way to extract the total rainfall for:- January Year 2000-2100,...
June 11th, 2009 11:50 AM
by Jacob Skaria Go to last post
5 100
Display 2 worksheets simultaneously by Kent[_2_]
Dear all, How to simultaneously display 2 worksheets come from the same excel file in the sreen? Thanks Kent
June 11th, 2009 10:13 AM
by Kent[_2_] Go to last post
2 110
Counting in columns by Deb
Hi all - I have a column which can include a date (eg format 10 June 2009) and I want to be able to count the total number of times a date appears in that...
June 11th, 2009 09:51 AM
by ytayta555 Go to last post
5 97
How to create one additional warning flag into my logic? by Danny Boy
I need assistance in editing a portion of the formula below. As it stands this formula (which I have written into cell (AF4) WORKS, and does exactly what it...
June 11th, 2009 08:51 AM
by Roger Govier[_3_] Go to last post
1 117
Formula and worksheet will not working properly by nathanv3223[_3_]
can someone help me with a formula it is not giving me the right times. The formula is supposed to figured the time between dates. It is not giving me the...
June 11th, 2009 07:00 AM
by Simon Lloyd[_284_] Go to last post
7 79
excel by Beautiful
how can a formula reference data containd in several sheets or books?
June 11th, 2009 04:07 AM
by JLatham Go to last post
3 83
need lookup help by Mike Coleman
I need to lookup a value in a range based on a cell then return the value of the 1st row of the column the found cell is in. here's my...
June 11th, 2009 03:17 AM
by Jacob Skaria Go to last post
3 86
Fitting data with a negative exponential by [email protected]
I have a number of data points that appear to fit a negative exponential model. When I graph the data in Excel that is how it looks. However, the trends that...
June 11th, 2009 02:22 AM
by [email protected] Go to last post
0 100
default border color by DeAna
On a few of my worksheets I save and use again I am unable to select a border without having to change “color” from “automatic” to “black”. How...
June 11th, 2009 12:19 AM
by DeAna Go to last post
2 81
excel by bbillybax
I have created three workbooks that have a series of links/formula that update sheets/cells within the other workbooks on my desktop computer. When i...
June 11th, 2009 12:05 AM
by Gord Dibben Go to last post
1 72
how do i count using two criteria by IHF
I have varying dates in D:D and different names in F:F such as 5/1/09 splmd2 6/1/09 armd4b 12/01/09 carbdp the names repeat as wil some of the dates. I...
June 10th, 2009 11:36 PM
by David Biddulph Go to last post
3 113
Bin Array--Frequency by Excel User
I want to set a bin array for only five numbers. I have entered the results of a survey asks people to answer on a scale of 1 to 5. I want to find out how...
June 10th, 2009 11:30 PM
by Domenic[_2_] Go to last post
1 99
Count w/ multiple variables & text values by king60611
I'm trying to get a count of how many times a value appears in either of 2 columns vs. a set column. In plain English, how many times does Bonds appear as...
June 10th, 2009 09:55 PM
by T. Valko Go to last post
5 80
Post New Thread


Display Options
Showing threads 10221 to 10240 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 11:21 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.