Worksheet Functions - Page 142

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.

Thread / Thread Starter	Last Post	Replies	Views
Sort sheet based on particuilar sort order by Also Slightly odd one. I want to sort a sheet in order of, for example, "Grape, Apple, Orange, Banana, Melon". Of course at the moment it will just sort...	January 3rd, 2008 09:31 AM by Also	4	59
Format cells based on text string contains by Also Had a good search but have to ask sadly. Using a Macro I have generated several columns of data. For columns F, H, I and J I want to in effect conditional...	May 14th, 2007 11:13 AM by Also	7	79
Forumla Help!!! by Alta Hello, I am in need of help with a formula in Excel. I am trying to create a worksheet for work that would automatically accumulate a monthly total. The work...	June 28th, 2004 03:04 PM by R	4	134
Index function by altah I'm trying to match data from 1 spreadsheet to another using the index function. I have tried formatting the data on each sheet to general, tried the "Text...	December 13th, 2006 06:03 PM by altah	7	54
Drop down list linking by altah I need to link the drop down list in a pivot table to a drop down box in another worksheet in a workbook. Is there a way to do this?	January 13th, 2007 12:45 AM by Debra Dalgleish	1	62
How can I subtotal a row that gives me =SUM(Q3:X3) by altah I have a spreadsheet that was sent to me that I need to subtotal a row. When I use the subtotal icon I get the formula but not the result.	April 19th, 2006 08:14 PM by Duke Carey	1	82
Searching String for phrases/multiple text strings by Altair1972m I have a column of Vendor Comments on the Outreach effort such as "Client's case is closed" "Client lacks transportation" "Client is 8 months...	May 16th, 2009 10:44 AM by Greg Lovern	4	194
Drop down menu by Altan I have a drop down menu of Dis or En. When I select En I have a conditional format to have the cells background turnblue. Dis will turn the cells background...	January 14th, 2004 06:37 PM by Peo Sjoblom	4	334
functions for drop down menu... by Altan I need to set up a drop down menu that has the following: En or Dis. I would like the background color of En to turn blue when you select it; when selecting...	January 13th, 2004 02:19 PM by Frank Kabel	1	494
Highlight row a random color by Altan[_2_] Visual Basic 6.3/Excel 2003/XP (Function Question 1) Column A- has many different ticket numbers sometimes duplicated. Can I create code to have all...	May 21st, 2008 01:35 PM by Gary''s Student	1	85
Sig Figs by Alterac I am working with a series of complex equations. I need them to carry a constant 4 significant figures throughout the entire spread sheet until it is rounded...	January 12th, 2010 07:44 PM by Herbert Seidenberg	3	179
Divide date into separate columns by Althea Hi Need to get year of a date entry into a separate column, whats the formula? eg 2/5/1900..want 1900 in separte column Thanks Althea	December 13th, 2005 02:16 AM by Peo Sjoblom	7	121
Text not all displaying in a cell, what is max that can be inserted? by Althea Dear list A general question, I am typing larger amounts of info in a single cell and it gets to a stage where it is not displayed, even when I choose...	May 9th, 2005 02:41 AM by Althea	4	80
Getting rid of new line command between 2 sets of info by Althea Hi List I have a spreadsheet that has Fathers name, occupation (then I pressed Alt + enter) to put on a new line in same cell a second Fathers name,...	May 7th, 2005 05:56 AM by Althea	2	65
Splitting firstName from Surname by Althea Hi Forgotten how to split into separate columns. Have FirstName and Surname together in one column (unfortunately some have a missle initial). Want surname in...	April 23rd, 2006 09:05 PM by Althea	5	173
countif nesting with subtotals by Altiplano Please I need some help. I would like to count the instances where the visible cells (to which filtering has been applied) in a selected column that contain a...	October 1st, 2004 01:37 AM by Dave Peterson	1	74
Fantasy Football Conditional Arrays by altopalo Hi, I really could use some help. I've got one work book with 4 work sheets devoted to various positions (e.g. QB RB WR/TE & K). Each of these worksheets...	May 8th, 2006 05:08 AM by Biff	4	76
Using data from multiple worksheets in a formula by altschool I have a workbook that will have 26 worksheets, the first worksheet will serve as an index of data for a roster of students. The other worksheets will be...	September 25th, 2008 09:31 PM by Duke Carey	1	114
Need helping with my formula please... by Altstatten I have three cells designated P7, Q7, and R7 with a line of text in each. In another cell (L7) I have a percentage. My formula is in M7. If the percentage in...	March 14th, 2006 08:48 PM by bpeltzer	1	83
A little help with a conditional formula, please. by Altstatten I understand the syntax for an IF formula. (IF(True, Then This, Otherwise This) Question is, can I make the first of the three variables an AND or an...	January 2nd, 2006 08:43 PM by Altstatten	4	87

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed