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
Counting with conditions based on another range by stephanie
HI. I've tried several different ways now to the experts :) I have two rows of data: Emp Lvl Rating 1 4 2 3 2...
November 30th, 2009 10:19 AM
by Pete_UK Go to last post
5 104
freeze panes cannot be saved by AndyZZ
Hi there, I have a big file and in a few sheets I use freeze panes which works fine. But each time I open the file anew after having saved my changes, the...
November 30th, 2009 09:53 AM
by AndyZZ Go to last post
4 92
convert text to formula using VLookup by VickiMc
My question; I've seen somewhere that you can convert a text string into a formula using the INDIRECT Function. What I am constructing is a maintenance...
November 30th, 2009 07:51 AM
by VickiMc Go to last post
3 83
re done Match formula needed by bill gras
Sorry about the last post , here is an other copy in sheet R! A D F 1 num time price ...
November 30th, 2009 07:40 AM
by bill gras Go to last post
3 111
Frequency of date by PAL
I have a list of dates over a two year period (in this example it is over 2006-07; although it will vary given different data sets). I would like to create...
November 30th, 2009 07:28 AM
by T. Valko Go to last post
4 109
edit, fill, justify by Tom
in excel 2003 to justify text in a range of cells, you did edit, fill, justify. How the hell do you do it in excel 2007? thanks -- tom ps i hate the new...
November 30th, 2009 05:11 AM
by Len Go to last post
3 119
Linking worksheet and multiple cells by Greg P[_3_]
Hello All: Here is my situation. I have 3 worksheets (WS1, WS2, WS3). Column A is linked to the same Column A in all 3 worksheets. So, if A1= DOG on WS1,...
November 30th, 2009 05:04 AM
by Jacob Skaria Go to last post
1 89
Don't Display #N/A by Dax Arroway
I have a formula that pulls info from another page. The formula is: {=INDEX('Patient Count'!$J2:$J5000,MATCH(1,('Patient Count'!$C$2:$C$5000=A2)*('Patient...
November 30th, 2009 04:01 AM
by Ron Rosenfeld Go to last post
1 86
Dealing with blank cells by Victoria
hi again - I hope it's OK to ask 2 questions on the same day! This problem is related to the one I posed earlier, but more general. Let's say a sheet has 3...
November 30th, 2009 03:39 AM
by Victoria Go to last post
4 90
returning the value in Colunm C using Colunm A as Ref by Robbo12
Hi I am trying to format a spread sheet and need to return the value of colunm C but the problem is Colunm A is blank as it runs in sequence (see below) It...
November 30th, 2009 03:01 AM
by Jacob Skaria Go to last post
1 101
How To????? by Gymclass14 via OfficeKB.com
I am attempting to write a formula in excel 2003. What I am trying to accomplish is to enter a list of values, say 20, 15, 4, 2.5, 1, 3, 6, 8.878, 17, 20.75,...
November 30th, 2009 02:15 AM
by Tom Hutchins Go to last post
1 75
Conditional IF Or Format by mjones
Hi All, Can I turn a cell’s contents orange If G100today() and G101=0 Or If H100today() and H101=0 Or If I100today() and I101=0 Or
November 29th, 2009 09:40 PM
by mjones Go to last post
6 87
Sum a range based on another range of cells by Raj
I want to sum a range based on another range of cells. I can detail my problem as follows: Range: 1 Name Points A 1 B 2 C 3 D 4 E 5
November 29th, 2009 05:26 PM
by Raj Go to last post
8 121
multipule calculations in a single column by mexmex
Trying to total sum a range of cells in a column and subtract from a total in another cell in the same column, getting a value error ex sum cell a10 to a20...
November 29th, 2009 04:13 PM
by Jacob Skaria Go to last post
2 88
Adding multiple intances from several sheets? by cwcordell
I use a timesheet in my job & I want to total project times over the course of the year. There are 52 sheets, one for each work week, plus a totals sheet. I...
November 29th, 2009 04:09 PM
by cwcordell Go to last post
2 93
Precedent lines by Sally
How do I save precedent lines in Excel 2007? Everytime I try to save them, they disappear.
November 29th, 2009 12:18 PM
by trip_to_tokyo[_3_] Go to last post
1 91
Stopping a formula once a condition has been met. by ordnance1[_2_]
Cell A1 of my worksheet contains the following formula: ='Retirement Summary'!Retirement_Payment Cell A2 contains a date. Is there any way that the formula...
November 29th, 2009 09:15 AM
by ordnance1[_2_] Go to last post
0 87
Recalling more than one cell by inputting a single command by Luis Verdejo
Hello everybody, I have a master list of books and course. each course has a course number.for each course there are different number of books.the books are...
November 29th, 2009 07:51 AM
by Max Go to last post
1 86
match formula needed by bill gras
in sheet R! A D F in sheet H! A in sheet RC! H 1 num time price 1 num ...
November 29th, 2009 07:12 AM
by Jacob Skaria Go to last post
2 80
How do I evaluate whether a character is present in a cell? by Crash
I am hoping I can evaluate whether a specific character is present in the text of a cell using an If function. For example if I test for a forward-slash in a...
November 29th, 2009 05:40 AM
by T. Valko Go to last post
4 99
Post New Thread


Display Options
Showing threads 5081 to 5100 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 10:25 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.