Worksheet Functions - Page 459

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
to fetch the rebate from another worksheet using itemcode by pol[_2_] I have two excel sheet 1. Itemdetails.xls 2. Discount.xls. The itemdetails.xls contain the following column. 1. itemcode 2. Description 3. Rate 4....	July 14th, 2009 07:27 PM by DK	1	116
highlight cells different colors in row by tweetlee I would like to be able to highlight a row green if column b in that row has an x, and highlight it red if column c in that row has an x. How do I do this?	July 14th, 2009 06:51 PM by RA	1	105
Paste solution by fi.or.jp.de Hi All, I have userform in excel with some textbox. Users copy the value from excel worksheet and paste that in Textbox. My query : when they paste that...	July 14th, 2009 06:18 PM by fi.or.jp.de	0	121
font in drop down by [email protected] The font in my drop down is tini tiny and figure out how to change	July 14th, 2009 06:10 PM by T. Valko	1	152
count function ??? by [email protected] ok I am lookeing for a function that will no per-say count cells fut produce the a value of 1 if there is any data typed in specified range so say my range...	July 14th, 2009 04:48 PM by RagDyeR	2	92
Count based on single number in string by Basenji The column has data like this A1, 749; A2, 14; A3, 910. The numbers vary as well as the length. The numbers are always whole numbers and never negative....	July 14th, 2009 04:46 PM by T. Valko	7	106
sumif function or something else needed? by kathy I have column E2 to E43 with place names e.g Dawson Creek, Peace River, GrandePrairie and I want the corresponding numbers in column J2 to J43 1196, 990,946...	July 14th, 2009 04:39 PM by Don Guillett	3	119
Does complicated sumproduct formula crashes excel? by vivi Hi there I have put a template together which is now 1.66mb, the workbook is huge with one tab "Entry Form" and the other "Project Costs", then there are a...	July 14th, 2009 04:20 PM by Don Guillett	7	169
Excel Column Summation by Scott Adams I know this is likely an insanely simple situation, but it is early Tuesday and I am stumped. I have a simple spreadsheet breaking hours down by percentage... ( 1 2)	July 14th, 2009 04:09 PM by David Biddulph	10	160
IF formula returns blank cells--only want values to show by Wilma I am trying to link data from one worksheet to another using the IF formula. The first worksheet (roster) includes student information, status (active or...	July 14th, 2009 04:02 PM by Wilma	3	95
I want to create an IF statement that leaves a cell blank if.... by KK I want to create an IF statement that leaves a cell blank if the value in another cell is blank or zero. How would I craft this formula please?	July 14th, 2009 04:02 PM by Teethless mama	6	169
Working with Date/Time by Thanks Hello I am creating a date/time using =TEXT(DATE(year,MONTH(B10),D10),"yyyy-mm-dd ")&TEXT(TIME(E10,0,0),"hh:mm") to produce 2009-01-21 00:00 I would like to...	July 14th, 2009 03:37 PM by Luke M	1	77
Showing date as day of week by Trevor Aiston Followed the help and used Day function to calculate the day of the week then formatted as custom to ddd to show short day name. But sometimes it returns...	July 14th, 2009 02:13 PM by David Biddulph	4	121
Averaging to-date lists??? by pjroethel Hello, I am trying to average this months list of numbers to-date from the first of the month until now. Since there are no entries in the future cells they...	July 14th, 2009 12:24 PM by Bob Phillips[_2_]	1	81
Array formulas/selecting data by Kalle Hi, I would like to use an array formula to retrive an array of data from a column given a certain condition, for sake of example let the columns look like...	July 14th, 2009 10:52 AM by Jacob Skaria	2	69
row and cell highlighted by Mr.Param[_2_] Hi, currently I am using this command: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlColorIndexNone ...	July 14th, 2009 09:26 AM by Mr.Param[_2_]	2	83
If logical function with text and numbers by Hugo Hi, I have a row with dates. Every three cells are a date in months, which excel recognizes as a date, but every fourth cell is the quarterly date, which...	July 14th, 2009 09:07 AM by Rick Rothstein[_2_]	7	100
Price time to cost by Linda Can any one please advise me how I can do the following In A1 00:27:25 (which is time hh:mm:ss) In B1 0.488p ( which is the cost) In C1 - I have to charge...	July 14th, 2009 08:38 AM by Linda	9	87
Is there a function that will return/copy an entire row? by snord I have a worksheet containing a few thousand rows and I used randbetween to select 50 of them. Now I need to make a list containing just those 50 records. ...	July 14th, 2009 08:11 AM by Liliana[_3_]	1	67
Age Date Between Two Dates to Return Value as 30, 60, 90 day by Nath Hi, How do I calculated between two dates to return the value as 30, 60, 90 day.	July 14th, 2009 02:38 AM by Jacob Skaria	4	453

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