Worksheet Functions - Page 1157

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
can't lookup a value to the left of my variable by Gluefoot I cannot figure out how to return the value of a cell to the left of my reference. For example I have a table that looks like this.... A B ...	July 9th, 2008 11:38 PM by Sandy Mann	6	55
If statement error check by lghovden06 I've created a Sales Tax Ledger where Net Sales - Resale - Non-Tax - Process - Other - Gas&Diesel = Taxable 2% Tax + 7%Tax should equal Taxable. I want to...	July 9th, 2008 11:05 PM by Peo Sjoblom[_2_]	1	52
How do retrieve deleted files from excel? by Tracey I had a file and thought I would not need it again, unfortunately I now need it is there a way to get a deleted file back? I did the file in Excel. Thank you...	July 9th, 2008 09:36 PM by David Biddulph	1	61
Want to unlink calculations by Otto Moehrbach[_2_] "Otto Moehrbach" wrote in message news:... You say: "Here is the problem: If I click outside of the invoice (or defined...	July 9th, 2008 09:12 PM by Otto Moehrbach[_2_]	0	53
SUM with nested VLOOKUPS - can i make it ignore N/As? by JW73 I'm having some difficulty getting the nested formula below to work the way I want it to, compiling data from 5 separate files, for now - it'll be 12 at year...	July 9th, 2008 09:09 PM by Peo Sjoblom[_2_]	5	71
How to extract text from middle of a string by Makelei Hi, I have in cell text as follows: Text1 - Text2 - Text3 I need to get out Text2 in one cell and Text3 to another. What kinf of formula I could use? Lenght... ( 1 2)	July 9th, 2008 09:03 PM by Ron Rosenfeld	18	217
Its a toughie, not sure if its possible. by Chiccada I would like to know if its possible to create a sum total based on categories selected in other cells. For example, I have 3 categories: First, Additional &...	July 9th, 2008 08:45 PM by pshepard	3	55
name separation by Help with Cell question how do i separate a single cell name "Doe, John" into two separate cells?	July 9th, 2008 08:35 PM by Rick Rothstein \(MVP - VB\)[_861_]	3	53
Finding and Adding by Rich Hi, Have a problem hopefully I can get some help with. I need a formula to find the last positive number in a row and then add that and all the numbers that...	July 9th, 2008 08:05 PM by N Harkawat	2	46
How to show a whole worksheet on one screen? by Ask MS[_2_] I have 255 columns, and at least 370 rows. How can I show the whole file on one screen? My second question is: how to show two worksheets together on one...	July 9th, 2008 07:46 PM by Spiky	3	58
Excel Calculation by Zee Hello, I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate...	July 9th, 2008 07:32 PM by T. Valko	4	40
Actual Language for Nesting criteria by Judy Rose Have a system that is tracking scheduled appointments and appointment types, need to program the formula to calculate overall appointments scheduled for the...	July 9th, 2008 07:20 PM by Pete_UK	1	58
Please Help Qtr Mtch by KristiM I was provided with the following formula to calculate qtrly...	July 9th, 2008 06:58 PM by KristiM	6	74
VLookup function by duranwd First time learning Exel 2007, I am confused in how to use the Vlookup function can someone explain? I understand formula starts =VLOOKUP ( __ ,A2:C10,__...	July 9th, 2008 06:47 PM by Belinda7237	3	60
Finding selected numbers within a master list by JennaB I have a list of about 300 UPC numbers that have been extracted from a master list of about 2,000 UPC numbers. These lists are on 2 separate sheets, and the...	July 9th, 2008 06:06 PM by Dave Peterson	2	92
Nested if's and lookup by rj shoe I need help converting this statement into an excel formula: If I have a name in one worksheet and I want to look up the name in another worksheet to find out...	July 9th, 2008 05:56 PM by T. Valko	3	76
Main worksheet to automatically update figures on other worksheets by Deb A I have a main worksheet with 10 columns with $ values. Each of those 10 columns need to have their own individual worksheet. How do I get the individual...	July 9th, 2008 05:34 PM by Pete_UK	1	90
Add numbers in a column, but exclude percentages in the same colum by Rich W. First of all, I did not set this spreadsheet up, but maybe I can learn something . . . I have a user who needs to add a column of numbers. The problem is...	July 9th, 2008 04:46 PM by David Biddulph	3	69
Makeing a name only show once after i pull a report by Steve A.R.W. OPTICAL CORP ARW-OPT O Appoved, 4/15/08 A.R.W. OPTICAL CORP ARW-OPT O Appoved, 4/15/08 A.R.W. OPTICAL CORP ARW-OPT O Appoved, 4/15/08 when i run this...	July 9th, 2008 04:29 PM by Max	3	57
Formula for adding 2 worksheets by accountant I need to consolidate 2 worksheets on another separate sheet. What kind of formula can I write that would include new names on the 2nd worksheet. Say, the...	July 9th, 2008 04:22 PM by Rich W.	1	80

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