Worksheet Functions - Page 191

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
Sum with a slash "/" by Freshman Dear experts, I've columns in a workbook which, for an example, in a cell wrote as "20/79". The users meaning is 20 persons order 79 tickets. As there are...	January 15th, 2010 08:25 PM by ryguy7272	6	113
Macros and security by Zita I have check boxes in my excel sheet. When I click a box and save as (I think enabeling macros), the next time I open it, I cannot change the check unless I...	January 15th, 2010 07:26 PM by Zita	0	77
Format date in header by Sammie I use the date button to insert the date in the spreadsheet header & , and I want to change the format of the date from 1/15/2010 to January 15, 2010. How...	January 15th, 2010 07:16 PM by Eduardo	4	108
How to seperate ALPHANUMERIC data in a cell in an excel sheet. by Tiamiyu L.O Please Members, I would like somebody to help me on how to enter a formular to seperate ALPHANUMERIC data in a cell in an excel sheet. For example, if a cell...	January 15th, 2010 06:57 PM by Ron Rosenfeld	3	102
Counting current streak by Renan Germano Hello! I have a table with the results of each team?s recent games. In column A are the game dates, and in each other column is a team name (B1,C1,D1..). In...	January 15th, 2010 06:55 PM by Luke M	6	135
Mark Up by Egg Harbor I want to calculate a marked up price on an item. IE 15%, 25% etc. If $100.00 is marked up 15%, the selling price is $117.65	January 15th, 2010 06:52 PM by Eduardo	4	90
return a value in one cell based on multiple formulas by eliyahuz I have the following data: gift_id suffix gift_desc size BX02 Chateauneuf - Semi Dry White 750 ml (12) BX07 Cabernet...	January 15th, 2010 06:39 PM by Luke M	2	86
Reading Multiple Files by BadBoy Good Morning, I have a data base titled 'DISTRICT YEARLY ROLL-UP'. This data base looks in a folder called 'NORTH BAY TIMMINS' for the name 'MARTIN114' and...	January 15th, 2010 06:26 PM by BadBoy	5	87
IF in formula by Denise Help...I'm tired of trying different formulas and none are working... I'm looking for a formula to do the following, with 9 employee names possible in one...	January 15th, 2010 05:10 PM by Gary''s Student	1	92
Retriving column header for non empty cells in a row by Sushil Patil Hello, I have worksheet like one below No Att1 Att2 Att3 Att4 Att5 A 1 1 1 B 1 1 1 1 C ...	January 15th, 2010 03:41 PM by Ashish Mathur[_2_]	2	92
Need help with formula by Connie Martin I am trying to adapt a formula in I2 from another spreadsheet that works well, but won't in mine. I've traced the error, but I would need help to understand...	January 15th, 2010 03:23 PM by Connie Martin	8	118
Simple Count of certain cells by JPDS Whats the simplest way of counting how many times certain letters appear in a list? In cells A1:A2000, I have Ethnicity codes with singular letters A-Z, I...	January 15th, 2010 02:45 PM by JPDS	7	86
If by Trace How do I get a return of 1 in column B for all numbers in column A that are greater than 0?	January 15th, 2010 02:37 PM by Eduardo	2	66
conditional formatting in excel 2007 by Lofty I have a table of 90 rows with names in column 1 followed by 6 cloumns of numbers. i.e.1 Alan 8 11 23 38 42 48 2 Dave 6 8 13 24 40 43 and so...	January 15th, 2010 02:16 PM by Luke M	1	80
Average number excluding 0 and blanks with text criteria by Pumpkin Pie[_2_] Hello smart people I have a list of survey names in A3:A726 and numbers in M3:M726. Column M also contains 0 and blanks. I am doing a summary table on the...	January 15th, 2010 01:05 PM by David Biddulph	6	134
Vlookup in multiples columns by Trainer I have the following simple spreadsheet. I'm tryping to use VLOOKUP to find the rate of pay based on the Job Type and the Hourly Pay which refers to a table...	January 15th, 2010 12:14 PM by Jacob Skaria	1	106
Shared Workbook User had unsaved information disappear by Aeryn635 We share a workbook and my co-worker came to me today and insists she typed information in multiple cells which is now missing. We do track the history and...	January 15th, 2010 05:31 AM by ryguy7272	1	94
Extracting data from multiple new workbooks via one master workboo by iBob Every week several reports are generated from a vendor in pdf format. These reports are converted (successfully for the most part) using Able2ExtractPro. I...	January 15th, 2010 04:21 AM by Leung	1	129
Divide two cells and if the number is negative display is as zero by mike I have an excell spread sheet and i am dividing two cells. Most of the numbers are positve but some of the numbers are negative. I want to put a formula in...	January 15th, 2010 03:33 AM by OssieMac	2	106
If Statement by tss Need help with this formula? Need to calculate a formula for CELL A based upon the following IF CELL B = STOCK and CELL C = 1.0, 25.0 THAN CELL D * 4	January 15th, 2010 01:45 AM by Pete_UK	4	86

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