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
Keystroke for Formatting by AMaxwell
Is there a keystroke for text wrap in a cell? -- Anne Maxwell Workman Nydegger SLC, UT
February 13th, 2006 11:06 PM
by Bob Phillips Go to last post
1 88
How do I undo putting a column in alphabetical order? by amay
accidentally alphabetized a column how do I undo it?????!!!! The edit will not let me undo it.
December 6th, 2006 08:43 PM
by Gord Dibben Go to last post
1 74
Excel automaticly advancing copied cell numbers by Amazon H.
Forgive me, I don't know much Excel lingo. I'm changing the layout of packing slips for a fundraiser company. The Tally Sheet read: Column A Column B...
August 18th, 2007 05:01 AM
by Max Go to last post
5 104
Calculating the Median Price Sold by AMB
Hello, I am trying to find a reasonable way of calculating a median. I have a data set that is about 20,000 lines long and it contains Quantity Sold and Unit...
August 22nd, 2008 09:37 PM
by AMB Go to last post
3 64
Sumif as a fuction of If using multiple criteria by AMB
Hello, I am trying to create a formula to sum total units sold as a function of a list of zip codes and product codes. I have 30,000 lines of sales data...
June 11th, 2008 03:47 PM
by PCLIVE Go to last post
2 74
copying formulas by ambam
Probably a very simple question but... i use excel for bookkeeping and therefore have sheets of jan to dec with formulas in certain cells to work out VAT...
January 13th, 2010 09:03 PM
by Gord Dibben Go to last post
7 152
INSERT COMMENTS WONT SAVE by AMBAZ
EVERYTIME I ENTER A COMMENT INTO A CELL AND PRESS SAVE ITS NOT THERE THE NEXT I GO INTO THE FILE, I NEED TO KNOW WHAT WOULD BE CAUSING THIS TO HAPPEN SO I CAN...
December 14th, 2005 03:57 AM
by AMBAZ Go to last post
2 91
Countif within and if statement by Amber
Good morning, I have data that I am trying to do an embedded countif statement and I can not get it to work. I would like to say If the date is within the...
July 30th, 2007 06:05 PM
by Rick Rothstein \(MVP - VB\) Go to last post
2 72
excel formating by amber
How do I convert military time to reg on a spreed sheet?
July 15th, 2008 09:10 PM
by Gary Brown[_4_] Go to last post
2 58
Multi Function for Unique Numbers by Amber
We run catalogs with special part numbers. I am trying to see how many unique special part numbers I have as each day passes. Each of these part numbers...
May 15th, 2007 09:56 PM
by Amber Go to last post
4 51
"Begins with" by Amber
How can I express the following within a function? begins with contains ends with
(Multi-page thread 1 2)
June 19th, 2007 09:11 PM
by T. Valko Go to last post
12 102
conditional format, day of month by Amber
I have a column filled with sequential dates. Cell A41 will always be the 30th day of a month, cell A42 will be EITHER the 31st day of that month OR the...
May 2nd, 2008 08:51 PM
by Sandy Mann Go to last post
5 65
SumIf Function by Amber
I have a spreadsheet that contains two columns, one is the date (m/yyyy format) and the other contains cost associated with the date. I would like to have a...
April 23rd, 2008 03:53 AM
by Tyro[_2_] Go to last post
2 88
Pivot Table by Amber
Every time I refresh my Pivot tables, Excel re-formats the Boarders on the entire worksheet. The boarder pattern seems to be completely random. I have gone...
February 21st, 2008 09:03 PM
by Amber Go to last post
0 65
Sumproduct with 2 criteria. by Amber
Good Morning, I have an expression =SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw Data 2008'!B2:B1528"XIAPPLXRP110")) in which I would like to add...
January 23rd, 2008 10:44 PM
by Bernard Liengme Go to last post
4 112
Return cost with 2 criteria by Amber
I have an excel spreadsheet with 2 sheets. I need to return a value based off of 2 criteria. Sample Data: First Sheet A B ...
January 15th, 2008 07:40 PM
by Bernie Deitrick Go to last post
5 73
Help with Formula by Amber
I have a graph built that automatically updates based on data that is entered. One of the columns that is graphed, has a formula of =MIN(cell #,500),...
June 8th, 2007 07:46 PM
by Amber Go to last post
2 61
Counting Unique Values with Multiple Criteria by Amber
My data contains 2 columns of data I want to count column A if column B has not already been counted. A ...
September 25th, 2007 02:52 PM
by Amber Go to last post
3 79
Odd functionality by Amber
I had submitted a previous question but it was getting confusing and I believe head ing in the worng direction. Here is the situation. I have a document...
July 10th, 2007 10:12 PM
by Amber Go to last post
4 89
Count items by day by Amber
I have a list of data where I want to know, by day, how many time different items occur. I have tried several possibilities with no luck. I would like to...
October 23rd, 2007 04:40 PM
by Amber Go to last post
5 57
Post New Thread


Display Options
Showing threads 3001 to 3020 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 07:12 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.