General Discussion - Page 9 - OfficeFrustration

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.

		Home » OfficeFrustration forum » Microsoft Excel
General Discussion

Home

Page 9 of 6989

Threads in Forum : General Discussion

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
What is worng with my formula? by robert morris I trying to determine the sum of nine numbers in Row / Column I12,M12,Q12,u12,y12,ad12,ah12,al12,ap12, minus the two largest numbers of the... ( 1 2 3)	August 28th, 2007 10:47 PM by Ron Rosenfeld	21	312
Extract two letters by bm Trying to extract two letters, the state to be more specific in cells that have varying lenghts and number of spaces. Examples: CEDAR RAPIDS IA 52404 USA ... ( 1 2 3)	August 11th, 2007 05:56 PM by RagDyeR	21	192
Excel Spreadsheet Manipulation by Baffy An Excel Spreadsheet is set up like this with hundreds of duplicate names and addresses: Name Address City ... ( 1 2 3)	July 29th, 2007 01:34 PM by Baffled	21	276
VLOOKUP by kyoshirou i trying to use this forumla: =VLOOKUP if unable to find out the values, can the data cells auto set to blank? ( 1 2 3)	July 7th, 2007 03:23 PM by Dave Peterson	21	245
Concatenate multiple rows and columns into 1 cell by mj44 I have a spreadsheet using 3 columns and n number of rows worth of data. I am trying to create one long string of this data by concatenating in the following... ( 1 2 3)	July 19th, 2007 09:18 AM by Bonobo	21	406
Why do people use SUM() unnecessarily? by [email protected] Someone wrote: I need a formula that will show percent change from the pervious month, the one I came up with is =SUM((D19-B19)/B19) This is just one... ( 1 2 3)	May 20th, 2006 07:21 PM by Don Guillett	20	483
How to count data in 2 columns by Ltat42a Hi All, Can Excel count data that is in two columns? Example, I have a column of people's names. In the next column, I have a number. Column A Coulmn... ( 1 2 3)	May 31st, 2006 05:55 PM by Ltat42a	20	217
How can I delete all macros? by Pheasant Plucker® Hi there, I have an invoice spreadsheet based upon the Village Software invoice. There is a date cell that automatically puts in today's date but I see... ( 1 2 3)	July 27th, 2006 12:49 PM by Dave Peterson	20	217
Adding numbers to an incomplete numerical list by HANA I have a list of numbers w/ data that doesn't include all of the numbers. I need to add numbers to the list to complete the numerical list (so the added... ( 1 2 3)	January 11th, 2007 09:46 PM by T. Valko	20	303
Need Custom format, not a formula by nastech 060426-5 Need Custom format, not a formula (Not looking for formula's). Just need "Custom Format" for how column of e.g.: 1.511B will look like: 2B That... ( 1 2 3)	April 29th, 2006 03:42 AM by Ron Rosenfeld	20	371
Creating a tick by clicking a cell by Justin Abel I have designed a schedule form for my business using excel 2003 and i would like to know how i can click a cell (a time block) and have it place a pre-defined... ( 1 2 3)	April 24th, 2006 09:24 PM by Dave Peterson	20	229
time clock formulas by Andrew I have created a formula for calculating total hours / day the times are entered in military time a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,... ( 1 2 3)	August 9th, 2006 07:56 PM by Marisel	20	213
print spreadsheet with each coming day dated on it for 2006. by Megan I have a spreadsheet in excell that I want to print with todays date on it as a header and then some how be able to print one for each day for the rest of the... ( 1 2 3)	March 13th, 2006 09:02 PM by Ron de Bruin	20	383
Adding a character to a defined name with a formula or macro by InfinityDesigns I am not sure what happened to my last thread. I was getting valuable information from someone but my thread disappeared. What I am trying to do is this, If... ( 1 2 3)	June 24th, 2005 06:36 AM by InfinityDesigns	20	443
more than one IF by Micayla Bergen i want my cell to return a value if J5 is 1 or 2 (which themselves are results of formulas) i have this thusfar =IF(J6=1,"SELL?","",(IF(J6=2,"SELL?",""))) ( 1 2 3)	June 2nd, 2005 07:15 AM by Max	20	233
import file by Mindy Hi, I have all of my personal addresses in an AnyTime file. I have exported it as a .csv file. I then open Excel and when I try to import it, it says cannot... ( 1 2 3)	April 6th, 2005 04:08 PM by Fredrik Wahlgren	20	367
BIMDAS - Order of Calculation by Atreides I've recently noticed that Excel flies in the face of standard scientific, mathematical and engineering convention in the calculation of powers for numbers... ( 1 2 3)	February 23rd, 2005 02:33 AM by Atreides	20	541
Finding last row in a column by daniel chen Column A contains entries of any formats including blanks. My objective is to find the last blank row# in Column A, and post it in cell D1. Can you help me... ( 1 2 3)	August 16th, 2004 09:44 AM by icestationzbra	20	326
Select sheet to print from a drop down box by krislyn Hi All, I Have a workbook where each tab is a different months report. Would like a print button on a menu that lets the user click and choose from the... ( 1 2 3)	July 30th, 2004 04:29 PM by Bob Phillips	20	715
Can Only Be Done One Way ! by RagDyeR We are all aware of the numerous ways that "things" can be accomplished in XL. Does anyone know of anything, that can only be accomplished using... ( 1 2 3)	July 8th, 2004 04:59 PM by RagDyeR	20	506

Page 9 of 6989

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 03:49 AM.