Worksheet Functions - Page 704

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
SUMIF formula required to search for 2 diff values in 2 diff colum by Lidy693 Hi I have the following data: A B C Team Complaint Type Action Required Sales ...	February 21st, 2009 09:45 PM by T. Valko	7	97
Sum within a column, according to another column by Auditor I have two columns. One column contains the prices of each item sold. The other column is called a line number and begins with one for new transactions. So...	February 21st, 2009 09:30 PM by Shane Devenshire[_3_]	2	150
Data Validation Q by Seanie Would it be possible to have a Data Validation that will only allow input of Today+1 or later. I don't require a strict 24hours of a difference, just the...	February 21st, 2009 06:10 PM by Don Guillett	3	87
how do i set up if cell content repeat, warn given by lahiripranab	February 21st, 2009 05:50 PM by Fred Smith[_4_]	2	102
SUm by shah Hai How to sum in a column only a positive and negative value separetly rgds	February 21st, 2009 05:46 PM by Fred Smith[_4_]	3	89
editable cell in a dropdown list by Nelson Noel Is it possible to add an editable cell to a dropdown list?	February 21st, 2009 05:46 PM by Shane Devenshire[_3_]	1	110
How do I save only active worksheet without save all of worksheet by droth Excel 2003 I have formatted copy of existing worksheet and inserted in to new worksheet tab. I do not want the worksheet I edited to change from orginal...	February 21st, 2009 05:11 PM by Dave Peterson	2	97
matching or lookup functions by anand I have 2 columns of data (A and B) both with unique alphanumeric codes in each cell (unique to each column but not between columns; ie some values are found...	February 21st, 2009 05:08 PM by T. Valko	3	85
Copying summed cells by spitfiregp34 I am trying to copy a column of cells that I have summed from other columns. I then want to erase the other columns, but then when I do this the copied...	February 21st, 2009 04:05 PM by Gord Dibben	3	102
week update formula by Savio is there any way to have a cell in excel update itself every week to show the first day of the week? say the week starts on a monday, the cell displays...	February 21st, 2009 01:07 PM by David Biddulph	3	80
Auditing excel sheets for everyday task by test[_7_] Greetings, We have excel sheets created everday for some tasks. Each task in excel is assgined one of the 3 values: SUCCESS, FAIL or OTHER. There are 3...	February 21st, 2009 12:53 PM by Max	1	101
Formula help - rounding up and round down? by 0greeny0 Can anyone help me with working out a formula which automatically rounds data up or down? I am developing an assessment data base for my school and need...	February 21st, 2009 12:10 PM by 0greeny0	2	60
count by smina I have differnet repeated nos. in column A, and unique nos in column B. by using countif function by puting the formula in column C1 i.e =countif(A1:A30,B1)...	February 21st, 2009 12:04 PM by xlmate	3	64
how do I format numbers to ordinal i.e. 1st, 2nd etc by chieflx I am trying to use number format to present sightings in ordinal sequence. I need to enter multiple sightings in one cell so I would like to be able to type...	February 21st, 2009 11:59 AM by Ron Rosenfeld	9	206
Return the cell reference of the drop down list selection. by YY san.[_2_] Hi, I try to look for a smilar question in the forum, but I couldnt find it. Appreciate if some one could lend me a hand on this. In SHEET1,I have the...	February 21st, 2009 11:36 AM by Ashish Mathur[_2_]	1	104
Compare multiple rows for duplicated values in individual columns by LyndonMBA I've put together an algorithm to compare students' responses (i.e. compare one students' responses against all other students). The workbook accomodates 8...	February 21st, 2009 11:34 AM by LyndonMBA	1	80
Month by Christine[_3_] what is the formula for returning the month (eg Aug) of a date?	February 21st, 2009 11:10 AM by Ashish Mathur[_2_]	7	114
Need Help in Excell Formula by Vijayavel HI All, we have some data like given below in Sheet1. Column 1 118712_PE907 - Business In a Box. In Sheet 2 like given below	February 21st, 2009 11:08 AM by Ashish Mathur[_2_]	2	67
Nested formula to search a text string and return specific text by Barbie Hello. I have a large spreadsheet that lists many text strings in a single column. The text strings include the name of a company, product, platform, and... ( 1 2)	February 21st, 2009 07:40 AM by Rick Rothstein \(MVP - VB\)[_1218_]	10	124
how do I get a simple #"123" from 1 2 3 ? Spaces between numbers by Chris Visa put SPACES between all the numbers. (e.g. 1 2 3 . 4 5 ) How do I get back to a 123.45?	February 21st, 2009 06:32 AM by Shane Devenshire[_3_]	6	85

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