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
Document Numbering by adnav
How can I make template in Excel which will allocate a new document reference everytime I create a new document from the template?
December 13th, 2006 05:18 PM
by RagDyeR Go to last post
1 48
Compare columns, count matches by adodson
I'm looking to compare two lists (a1:a10 compared to b1:b10, unnamed). Then, return the count of original matches between the two lists. For example, if...
(Multi-page thread 1 2 3)
January 25th, 2007 03:34 AM
by T. Valko Go to last post
20 231
sum column based on single cell match? by adodson
This seems so simple and yet the solution eludes me... In row 2 I want Excel to match a cell's contents (ex: find 3200). Once finding the column that...
April 9th, 2010 07:15 PM
by Luke M[_4_] Go to last post
1 90
Sumif on Formula instead of Value by adodson
What I'm looking for is a way to sum the cells that contain =Ceiling. I've tried SUMIF(range,"*CEILING*",range) but the formula returns 0. I'm guessing it...
May 30th, 2006 05:28 PM
by SteveG Go to last post
4 100
MRound and Roundup by adodson
I can't seem to get these functions to work in conjunction with each other to get my desired results, so I'm putting it out there for someone else's...
April 11th, 2006 12:13 AM
by adodson Go to last post
4 59
Save as not working for laptop to desktop by Adra
I am using network connection for laptop and desktop. Save as function is not working to save open file on desktop from laptop.It says file is located...
March 29th, 2005 10:55 PM
by Worm Go to last post
3 142
IF cell A1 contains "X", enter "X" in cell B1, if not enter "Y" HE by adre77
The operation I am trying to do is: If cell A1 contains the word "AMR", I need Excel to show in cell B1 the word "AMR", if it does not find it, enter the...
December 2nd, 2008 11:08 PM
by adre77 Go to last post
4 61
Using ISTEXT across separate Spreadsheets by Adrena1in
Hi there, I've got a customer with a single spreadsheet, which uses the ISTEXT function to query lots of other spreadsheets. This appears to be failing, and...
June 30th, 2006 11:23 AM
by Adrena1in Go to last post
1 82
Data in list w/same A:B move to column by Adresmith
Hi, I have a list of source data that I need to change to format of and I am not sure how to do it. Maybe a pivot table? What I want to do is have each Pers....
January 24th, 2006 09:58 PM
by John Michl Go to last post
1 82
How can I sort a group of numbers automatically as data is entere by Adrew
I'm designing a spreadsheet to record the World Cup football scores. I've got the leagues to take scores from the match results but I now want the leagues to...
December 19th, 2005 01:56 AM
by Adrew Go to last post
4 141
Fill cell with a worksheet name? by Adri S.
I have a workbook that will be used for employee evaluations. Each sheet is for a different employee, and the sheet is named for the employee. I would like...
January 16th, 2008 06:12 PM
by CLR Go to last post
4 63
Can a cell have a drop down list and can also be auto populated by Adrian
I would like to have a cell that can be autopopulated based on the content of a different cell but also have a drop down menu that can effect the 2nd...
March 17th, 2005 06:05 AM
by Jason Morin Go to last post
1 256
Would like help with displaying data if are a certain value is pre by Adrian
Hi, Hope the formatting of this comes out OK. Typed it up in notepad 1st. Anyone good at functions where if 1 cell in a row = a value, then the entire row is...
June 10th, 2006 06:47 PM
by Country Go to last post
8 73
Grouping by Adrian
I have a spreadsheet which we used to be able to group the rows of data which is not current. In the past, we were able to group these unwanted data and on...
April 2nd, 2008 01:41 PM
by Cimjet[_2_] Go to last post
2 119
How to I sum different data from different sheets by Adrian
Hello. I have a workbook with 12 sheets. In the first one I have in column A: x , y, z, x, a, z ....and in column B: 100 $, 300 $, .... In the second sheet I...
April 20th, 2008 04:38 PM
by Herbert Seidenberg Go to last post
3 129
Formating cells by Adrian
Is there a way to utomatically remove boarder if there is no value in the cell and place a boarder i there is?
May 1st, 2008 01:34 AM
by Adrian Go to last post
6 72
Index/Match Formula across 2 worksheets by Adrian
New to all this so any help would be really appreciated. (Using Office 2003) I have 2 worksheets and need a formula (possibly index/match) to add up total...
June 19th, 2008 11:34 PM
by Adrian Go to last post
4 103
Formula to calculate 4 possible answers in one cell by Adrian
Hi The following 2 columns can both contain either a "Y" for Yes or an "N" for No so there are 4 possible outcomes for each row. I require a formula for...
June 20th, 2008 01:08 PM
by Don Guillett Go to last post
3 63
You should design a way of doing algebra calculus on a computer by Adrian
Seems to me that there is no easy way of entering calculus style equations into Excel and I just think it would be such a cool tool for students and pure...
October 16th, 2005 09:37 PM
by Adrian Go to last post
0 129
How can one cell be autopopulated by another cell and have a drop. by Adrian
I need to have cell #2 be autopopulated by cell #1 and also be able to have a drop down menu to be able to autopopulate cell #1. If one have of the...
March 17th, 2005 04:46 PM
by JulieD Go to last post
1 120
Post New Thread


Display Options
Showing threads 1361 to 1380 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 04:30 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.