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
if statement, change cell only if true by laavista
I know there has to be a simple solution, but I can't find it Sheet1 has values in column A. Col A is formatted as text and contains either an ID...
April 29th, 2010 04:11 PM
by laavista Go to last post
4 133
result given from content of selected cells. by Rik_A
is there any way to give a result in one cell from the content of other selected cells. scenario: i am trying to create a spreadsheet to work out my current...
April 29th, 2010 04:04 PM
by Mike H Go to last post
5 131
Imperial Weights in Excel by andrew.ford.af
How do you use Imperial Weights in Excel, to allow formula for adding up weights to use in pie charts etc. imperial weight measuring in stones. pounds and...
April 29th, 2010 03:49 PM
by Luke M[_4_] Go to last post
1 135
sumif formula by Vince
I have a summary sheet and a detail sheet. On the summary sheet I am trying to sum columns (E - O) from the detail sheet that are less than or equal to a ...
April 29th, 2010 03:46 PM
by Steve Dunn Go to last post
2 150
How does one put a watermark in an Excel worksheet? by Newellmyra[_2_]
Not even sure if it is possible but would like to put a watermark in an excel worksheet... HOW can it be done? step by step? -- Newellmyra
April 29th, 2010 03:39 PM
by Tom Hutchins Go to last post
1 174
problem with lookup function by lampatmyfeet
I have a problem with summing a lookup function My data looks like this: A1: text B1: time C1: time D1: time E1: time A1 = could be any of 8 different...
April 29th, 2010 03:30 PM
by lampatmyfeet Go to last post
2 187
Record time by formula by karim
hi, i want to create excel sheet wherein time has to be recorded multiple time. Now() formula does not help and i don't want to use macro. Pls Suggest
(Multi-page thread 1 2)
April 29th, 2010 01:36 PM
by Dave Peterson Go to last post
10 255
Adding data from multiple cell and linking to a new worksheet by Rashmi
I have data in a sheet with names and amounts due. Like A 500 B 300 A 600 B 300 C 400 C 200 There is a second sheet named summary. I want the totals of each...
April 29th, 2010 12:54 PM
by Eduardo Go to last post
3 153
Counting Characters In A String by fabio
Hi I am trying to manipulate some data strings and I want to count how many times the characters '(' and ')' occur in each of the data strings on my...
April 29th, 2010 11:01 AM
by fabio Go to last post
2 138
Build 'show 0 as -' into existing formula by CW
Hi All, I have a working formula as follows: =SUMPRODUCT(('Timelines Data'!B4:B52="Modelling")*('Timelines Data'!D4:D52=TODAY())*('Timelines...
April 29th, 2010 10:41 AM
by CW Go to last post
8 261
HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B by Rodrjua
I am trying to developt a formula that restrict symbol characters to be entred as data, help me!
April 29th, 2010 10:12 AM
by Steve Dunn Go to last post
1 136
Sorting a portion of a worksheet by NicoleS
*Using Office 2007* I am using the sort function to organize a list by date and anniversary year. That works well. Then I insert blank lines (for...
April 29th, 2010 09:37 AM
by Steve Dunn Go to last post
1 110
Slope??? help please!!! by beto
------ I have 4 columns : --------- COLUMN A: Dates (ex. 1/15/2009) COLUMN B: Time (ex. 1:35:24 AM) COLUMN C: Dates and Time added and shown in the format...
April 29th, 2010 08:59 AM
by Jarek Kujawa[_2_] Go to last post
1 105
Advanced Data Filter by Asad
How can I generate a count number series on entries recurring on my worksheet; e.g i have a data sheet with the following data appearing x x x a a g g
April 29th, 2010 08:39 AM
by Bob Phillips[_3_] Go to last post
1 109
Adding Fractions and Displaying as a percentage. by SarahN
Hi, I am trying to add a number of Fractions and then display as a percentage. Does anyone know a formula that will automatically add a number of cells and...
April 29th, 2010 08:16 AM
by Jacob Skaria Go to last post
6 260
Index Match Problem by jeikenberry
I'm using the following formula, but it's returning #N/A: =INDEX('File X'!$F$1:$F$2000,MATCH(1,($B5='File X'!$A$1:$A$2000)*(S$4='File...
April 29th, 2010 06:25 AM
by Jacob Skaria Go to last post
3 122
Which (logical) function? by JustJill
Table was codes...if the ID begins with a w and the number in the second column is a 1 add the ones (which are male ;) A B 1 ID ...
April 29th, 2010 06:05 AM
by Jacob Skaria Go to last post
3 128
formula help by Jeff Brown[_2_]
I have a formula and can not make it work the way I would like. =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is. I need it to subtract .50 from I5...
April 29th, 2010 05:51 AM
by Jacob Skaria Go to last post
4 130
How to remove a bunch of zero's by daisy
Can anyone help me with a function that I could apply to my spreadsheet? I have 10 columns and hundreds of rows coming over from another application and now...
April 29th, 2010 05:24 AM
by ozgrid.com Go to last post
4 128
Running calculation of a frequency by Marcia
Hi, On a monthly basis I need to calculate a running frequency of scores, but I'm not sure how to do it. For example, Joe receives 3 scores (based on a 1 to...
April 29th, 2010 04:06 AM
by Teethless mama Go to last post
1 119
Post New Thread


Display Options
Showing threads 901 to 920 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 08:38 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.