Worksheet Functions - Page 519

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
tool bar question by Brian Hello, A while back I clicked and dragged FILE and the TOOLs menus and dragged them off of the tool bar. How do I get them back? Thank You, Brian	November 28th, 2004 05:55 PM by Bob Phillips	2	97
Using Vlookup with validation by Brian I'm trying to use the Vlookup function so that when a particular selection is chosen from a dropdown box, it will then alter data elsewhere in a spreadsheet. I...	July 1st, 2005 03:33 PM by Bob Phillips	3	78
nested what if statement by brian I am trying to solve this problem and really could use some help. Here is the questions and the spread sheet information. If you have some helpful ideas that...	April 23rd, 2007 12:11 AM by JE McGimpsey	1	57
Extracting characters before or after a specific character by Brian Howdy All, I have data imported from a web query, but it isn't formatted the way I need it. I have a part number and description combined in a cell,...	June 6th, 2007 05:35 PM by Brian	3	65
Multi-sheet sumif help by Brian Howdy All, I have a workbook with 6 worksheets in it that each contain the data for 6 departments. The data format on each worksheet is identical. I have a...	July 20th, 2007 05:26 PM by Bob Phillips	4	76
Excell formula help by Brian I have this formula in a cell (=IF(SUM(BJ94:BJ96)BJ95,BJ95,BJ96+BJ95+BJ94). this formula does not function correctly in all conditions. In certain...	August 5th, 2007 06:25 PM by Rick Rothstein \(MVP - VB\)	9	146
How do you use sumproduct to return specific cell data? by Brian I have the following scenario: A B C D E 1Hotel# 1Job# 2Hotel# 2Job# Staff# 101 ...	September 14th, 2007 07:42 PM by Brian	2	82
Subtracting one list from another list by Brian Howdy All, Here is what I have. Column A is a list of several thousand record numbers, Column B is a list of several thousand record numbers. What I want...	October 12th, 2007 05:50 PM by Brian	2	64
MID formula question by Brian I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't want the H2 to be the cell, but rather I want the value that I entered into H2 to...	October 24th, 2007 02:50 PM by Don Guillett	2	95
i need an excell formula that will round up to the nearest 9.99 by Brian In excel i want to take a cost divide it by a certian margin then round that result up to the nearest $9.99... For example $125 divided by a 45% margin is...	May 11th, 2005 10:51 PM by JE McGimpsey	4	293
simple formula with blank cells by Brian I have values in cells a1 and b1 however a1 or b1 can be blank. The formula in c1 should add the values of a1 and b1 only if there is a value in a1 and b1...	April 1st, 2005 04:41 AM by Reid McTaggart	1	84
Updating links by Brian Help! I have placed a two workbooks on a server one workbook relies on the other for data. I have changed the sources after placing them on the server and...	January 12th, 2005 03:05 AM by Dave Peterson	1	85
simple countif by Brian I have values in cells B2:B8. In cell B10, I woud like a formula that counts the number of cells in B2:B9 with values greater than 4. Thanks for...	February 3rd, 2005 01:25 AM by John Mansfield	1	73
Formatting a cell to populate on a certain date by Brian I want to have a cell populate with a specific value once a particular date coemes. Example: On the 15th of the month I want to have cell D6 populate with...	February 16th, 2005 02:10 AM by Jenny Dempsey	6	124
Finding and Deleting duplicates in a column by Brian I have a huge list of 10 digit numbers in column B. These numbers where scanned in using hand-held barcode scans, so human error is possible. I may have...	February 5th, 2005 02:19 PM by Brian	3	334
Sorting data by last to digits by Brian I have a worksheet that I need to sort by terminal digits (last 2 digits). The data is in column A in the format: '0004135296 Notice the ' at the...	February 23rd, 2005 05:44 PM by Brian	2	85
Auto Protect workbook with password upon opening by Brian This is what i currently use to auto protect sheet, but i want to add a password to this, (2468) so that the protection is password protected, but i do not...	February 23rd, 2005 05:45 PM by Brian	0	339
if a cell = a particular letter or even contains that letter by Brian =IF(M22="all","a",IF(M22="e","r","a")) Notice the "e", how can I insert the following: ....If m22 contains "e" anywhere,"r","a")) Thanks Brian	February 28th, 2005 05:58 AM by Rob van Gelder	3	100
Hide a row based on one cell's condition by Brian Is it possible to hide a row based on a condition? For example...if I have dollar amounts in cells A1, B1, and C1....and I want to hide any rows where the...	March 19th, 2005 11:57 AM by Dave Peterson	1	265
how can i use a function to change chart title in Excel 2007 by Brian I used the approach in John Walkenbach 2002 Formulas in excel book (chapter17) but it does not work. I have a useless error message each time.	November 16th, 2007 06:42 AM by yshridhar	2	55

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