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
Timecode in excel by Amber
I am trying to subtract the timecode in one column from the time code int another column. Then I need to sum...
October 30th, 2003 05:22 PM
by Peo Sjoblom Go to last post
4 186
How to exclude dates which equal SUNDAY from a fill series? by Amber
I want to fill a series of dates, for example cell A1 = November 1, 2008 through cell A30 = November 30, 2008. BUT I do not want to include any Sundays, so...
November 5th, 2008 03:09 PM
by John C[_2_] Go to last post
8 124
Difficult Calculations by Amber
I am needing to combine multiple functions, I believe, but am in need of some help. I currently have a document that I run a sumproduct. With the...
December 11th, 2007 05:17 AM
by ilia Go to last post
8 101
CountIf embedded in an IF statement by Amber
Good Morning, I have a situation where I would like to count the number of orders created by a certain person within a specific month. What I would like to...
July 30th, 2007 07:44 PM
by Toppers Go to last post
8 60
Count IF/Sum IF by Amber
I have a document where I want to know how many of a product that I seel each day. I have this to show how many are sold as a total =SUMIF('Total...
July 10th, 2007 10:52 PM
by Amber Go to last post
4 72
Formatting by Amber
I have a document with multiple calculations in it and for some reason today, one of the tabs that has calculations is showing only the actual calculation...
June 11th, 2007 05:38 PM
by Amber Go to last post
3 58
BIG Dilemma.....HELP!! by Amber
I have some data that I am trying to do a function to calculate. What I want to say but can't figure it out is.......If the sold to party is X,and the...
May 30th, 2007 01:26 AM
by Roger Govier Go to last post
5 51
Counting Function by Amber
I have a document with a list of part numbers and quantities. I would like to create a function that allows me to update a new sheet where all the part...
May 15th, 2007 09:28 PM
by Ragdyer Go to last post
9 74
How do I sort an excel spreadsheet based off of subtotals? by Amber
I am trying to sort my spreadsheet based off of the subtotal information that I have just created. Is it possible to do this?
March 20th, 2007 12:18 AM
by Dave Peterson Go to last post
2 89
Need formula to jump from one column to the next by Amber
I am looking for a formula to end a column say at A20 and then begin again at B1. Is there a formula for this. So when typing you don't have to click...
April 8th, 2006 10:25 PM
by L. Howard Kittle Go to last post
2 81
Separating text and data in a column by Amber
I have a column that contains text and data, never in the same cells, but I want to separate the numbers from the text in order to do a total at the bottom. ...
April 4th, 2006 11:42 PM
by Gord Dibben Go to last post
1 82
how can i get rid of duplicate records in excel? by Amber
I have a large spreadsheet and because of system parameters, it has lots of duplicate records. How can I get just one of each record without manually deleting...
November 10th, 2008 08:16 PM
by Kim Go to last post
5 341
Deleting Blank Rows by Amber M
Can I highlight a range of rows and columns and have excel automatically delete any rows/columns with no data in them? Thanks!
October 4th, 2004 06:55 AM
by Frank Kabel Go to last post
4 105
equation for a power analysis by amber riggs
I need the equation to do a power analysis in excel!!
May 27th, 2006 10:52 AM
by Tom Go to last post
1 64
Timesheets by amber s
I am doing a timesheet that shows a start time and and end time. I know how to make the result show up as a decimal, but I would like to be able to not have...
March 18th, 2009 06:05 PM
by Pecoflyer[_250_] Go to last post
2 46
VLOOKUP works in some cells but not others. by amberlodge
Excel 2000 Really simple data sheet: list of names with homerooms Lookup table: list of homerooms with teachers. (named "Range") =VLOOKUP(E2,Range,2) Some...
April 14th, 2006 09:03 AM
by Infinity Go to last post
9 109
Show - in cell by ambermw15
I have some formulas in a couple of cells but I don't want them to calculate yet. Some other cells are dependant on it and I would like it to show a - in the...
November 28th, 2006 07:37 AM
by Roger Govier Go to last post
1 61
SPREED SHEET TEMPLATES IN EXEL by ambiance
iam looking for spreed sheet templates in excel
September 26th, 2007 04:40 PM
by Gord Dibben Go to last post
2 47
INDEX & MATCH find first column value in an array? by Ambie
I need to lookup a value in cell D15 from worksheet B in an array found in worksheet A for the first column containing the value of cell D15 from worksheet...
December 3rd, 2008 12:34 AM
by Ambie Go to last post
3 128
reverse lookup function, index/match usage? by Ambie
Hi, I never got a response to this question that worked, so I thought I would ask it again hoping that this time it makes more sense: Here is a sample of my...
December 12th, 2008 02:22 AM
by T. Valko Go to last post
3 79
Post New Thread


Display Options
Showing threads 3021 to 3040 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 03:05 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.