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
Conditional Summing... by AC [MVP MCMS]
I have a table with three columns: category, date, amount. On another summary sheet, I'm trying to sum up all the amounts based on the category for each month....
March 11th, 2006 08:47 PM
by Biff Go to last post
2 78
Can I enter two "IF" Functions in the same cell? by AcademyAce
I have used up all seven nested functions in my formula but still have three arguments left. I want to include them in the same cell.
November 28th, 2006 05:14 PM
by driller Go to last post
5 65
Conditional format row based on percentile by Acanesfan
I asked a similar question the other day and no one answered, because I posted it in general questions instead of worksheet functions. So I'm trying...
August 27th, 2008 10:41 PM
by Spiky Go to last post
3 78
Is there an easy way to delete empty columns? by Acanesfan
I am using Excel 2007. I have a spreadsheet that has been exported from an in-house software database. It has 57 columns and more than 1,000 rows. A lot of...
September 8th, 2008 09:01 PM
by Héctor Miguel Go to last post
2 67
Subtotals - is there a way to include more information on the line by Acanesfan
I am using Excel 2007. I need to sort by job no and client no. Some clients have more than one no. Here is an unsorted list: Mgr Client...
June 23rd, 2009 12:50 PM
by Dave Peterson Go to last post
2 148
In a function, How do I copy the cell color as well as text by Acapulcojo
All I want to do is to say for example that Cell A1 is equal to Cell G8 and have A1 contain the same text as G8 and have the same fill colour
September 28th, 2006 12:35 PM
by CLR Go to last post
1 54
Date Format by ACarella
How do I format a date 05/30/07 into Wednesday, May 30, 2007
May 30th, 2007 07:29 PM
by ACarella Go to last post
6 64
Time and megabytes by ACarella
I have three columns in an Excel Worksheet. Table Name Time of Data Transfer Size Data Transfer Would anyone know how to format the Time of Data Transfer and...
November 12th, 2008 02:07 PM
by ACarella Go to last post
4 100
append column data by ACarella
I have the following: COL1 COL2 COL3 COL4 SP000008 COVS S&IH EN and need this displayed in COL5 SP000008_COVS_S&IH_EN.html
July 22nd, 2008 06:13 PM
by Gord Dibben Go to last post
3 101
easy if statement by acarnah2
I need to know how to do make this into a properly working excel function If(A4 has nothing in it) True(Leave empty) False(H4-G4+F4) Thanks for the help
January 27th, 2006 05:59 AM
by Govind Go to last post
1 75
Consolidating spreadsheets by ACase
Hello, I am trying to consolidate 3 spreadsheets into 1. Each spreadsheet is in table format. The first spreadsheet is 'Asia, the 2nd 'Europe', the 3rd...
October 26th, 2005 08:33 PM
by Anne Troy Go to last post
1 128
Analysis ToolPak Translator by acasta
Hello everyone, after experiencing some problems because of non-automatic transation of ATP worksheet function names between different language versions...
September 7th, 2005 02:39 PM
by Ron de Bruin Go to last post
1 101
aauugghhh...#div/o problems & various average formula problems by acbel40
Help...I'm confusing myself... Trying to determine an average per month, based on 12 months of numerical data…but some of the cells have zero’s. Now…I...
October 19th, 2009 05:00 PM
by Dave Peterson Go to last post
5 168
Average formula works but.... by acbel40
I'm using this formula =IF(ISERROR(AVERAGE(IF(M6:M170, M6:M17))),"",AVERAGE(IF(M6:M170, M6:M17))) on a multiple column spreadsheet....it works...
October 18th, 2009 06:33 PM
by acbel40 Go to last post
3 156
Average formula only works partially..... by acbel40
Whew….anyone can help me with this…I’d be truly grateful…. My spreadsheet has several columns that need to averaged on time spent on that particular...
October 19th, 2009 07:02 PM
by acbel40 Go to last post
6 130
Return a Title based on a name by AccAdmin
I have a proposal sheet used by multiple users, and I would like the cell I have dedicated to the title of the individual proposing the work to be filled out...
December 31st, 2008 05:17 PM
by AccAdmin Go to last post
4 63
Can anyone help - I am sure there is a easy way to do this by ACCAguy
Can anyone help with a formula to separate a field containing numbers and letters into numbers per below? I only know how to use for eg =left(X,x) but that...
August 29th, 2008 11:38 PM
by Don Guillett Go to last post
6 106
How do I copy numeric section of cell from alpha-numeric cell by ACCAguy
Can anyone help with a formula to separate a field containing numbers and letters into numbers per below? I only know how to use for eg =left(X,x) but that...
September 8th, 2008 12:46 PM
by Ashish Mathur[_2_] Go to last post
8 109
Conditional formating, match, lookups by ACCAguy
Hello All: My problem is that I have 2 worksheets that I need to compare and highlight the items that are similiar based on 2 criterion. In essence it is a...
(Multi-page thread 1 2)
September 9th, 2008 08:59 PM
by duck Go to last post
10 119
HOW DO I CHANGE THE EXCEL CURSOR TO AN ARROW FROM A CROSS ? by Accellerate
usually, the cursor on spreadsheets is an arrow. when you enclose a word, you can move it to another cell, you can drag the cell starting from (i.e. a and you...
May 28th, 2006 12:09 AM
by Gord Dibben Go to last post
1 106
Post New Thread


Display Options
Showing threads 1021 to 1040 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 01:25 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.