Worksheet Functions - Page 71 - 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
Worksheet Functions

Home

Page 71 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
combining vlookup and hlookup functions by Adrienne I have a table with years across the top and months in the first column. Within the table is data for each month of each year. Is there a way I can point to...	April 26th, 2009 05:39 PM by Mike H	2	88
formatting won't apply to my cell with a formula by Adrienne I downloaded the checkbook register from Microsoft.com and am trying to add a few cells at the end to quickly calculate my outstanding debits and credits so...	November 27th, 2005 05:44 PM by David McRitchie	9	286
Printing Page Numbers: 1 Spreadsheet print pg #'s on several copie by Adrienne - Excel I print from one spreadsheet multiple copies from 10 to 50 copies, same thing over & over. But I want to add page numbers for each page printed. Not just...	December 18th, 2006 09:03 PM by Anne	2	72
counting the number of times a word appears by Adrienne[_2_] I have over 1000 entries where one colum contains cells with multiple info such as: Provide professional development opportunities, Subsidise the cost of...	September 5th, 2007 02:49 AM by T. Valko	5	74
excel "Networkday" function by ADS How do I assign current calendar date to end_date in order to calculate # of days worked from hire date to current date?	May 18th, 2006 03:55 PM by Bob Phillips	2	89
Can I add and IF function to a SUMIF function? by adscrim I need to sum values in a list that match other values and know that this can be done via the SUMIF function. However I also need to split the values based on...	January 21st, 2006 12:32 PM by adscrim	4	98
Google Adsense Account Approval Tricks by Adsense Trick Google Adsense Account Approval Tricks New Unique Genuine Google Adsense Account Approval Trick Only For Rs. 1000/-. Take This Trick & Create Unlimited...	May 13th, 2010 03:05 PM by Adsense Trick	0	125
Remove number from text string by adunao Please how do I remove numbers from unformatted texts strings e.g DEPOSIT RICA MARINE 6890312 RICA MARINE or DEPOSIT 7048783 KURUS NIG or DEPOSIT 7042248...	March 20th, 2008 01:02 PM by Ron Rosenfeld	1	71
Find Duplicates and Move to New Worksheet by Adurr I need to create a formula or a Macro that compares data on one worksheet and it compares it to another worksheet and if it finds a match moves it to a new...	June 28th, 2007 02:48 AM by Max	9	112
Finding a value or the one next to it in a range NOT array by advanced novice Picture data in a phone book with 5 columns of names and numbers 10 cols total. I need a function that will look up the name and return the number that will...	August 6th, 2008 02:54 PM by Pete_UK	3	105
LEADING ZEROS IN FORMULA RESULT by Advent I have looked all over to determine how to maintain leading zeros in a formula result. I have tried formating cells as custom '0000' and as text to no avail....	December 8th, 2006 01:22 PM by Advent	4	108
How do I apply the formula =PROPER(text) to existing text in works by ADWhitman I have a large worksheet with a lot of text that is in ALL CAPS. I need to convert all of the text from ALL CAPS into Title Case (1st letter of each work is...	September 20th, 2004 04:21 AM by Peo Sjoblom	1	160
H Lookup by Ady I'm trying to Hlookup a cell but the reference cell is merged. I only receive information from the first of the two columns underneath the merged reference...	April 18th, 2007 01:58 PM by bj	1	150
lookup field and copy the row across by adyden Hi, I am new to this so please be gentle:-) Can someone help me, I am trying to look for a value in one column in one sheet and when the value is found to...	June 14th, 2006 12:49 PM by adyden	3	99
Check Boxes by adyer Is there a way that I can insert check boxes into an excel spreadsheet?	February 5th, 2006 09:38 PM by dmexcel	2	53
bring info from one sheet to another sheet by Adyna I need to find out if there is a way to do this: Sheet 1: COL A COL B item 1 price 1 item 2 price 2 item 3 price 3 Sheet 2:...	April 2nd, 2009 08:46 PM by Adyna	2	44
Multiple criteria in COUNTIF in Excel by ady_mech I am looking for help on COUNTIF function. I know of: COUNTIF(range,criteria) Above compares the data with only one criteria. What should I do if I want to...	August 27th, 2004 08:05 AM by JE McGimpsey	2	108
How do I calculate the difference between 2 dates (m,d,y) ? by ady_sandu How do I calculate the difference between 2 dates (m,d,y) ? For example : date1 = 19 feb 1999 date2 = 07 ian 2005 difference = days, months, **years. thank...	September 29th, 2005 05:09 PM by Myrna Larson	8	99
My IF statement won't work for my formula by AdzRay The formula I want to use is =100%-H3/B3. This is to give a failure ratio for products made. My problem is I have tried many IF statements so that if the...	February 3rd, 2007 10:51 PM by AdzRay	5	80
Formula Help by aea2517 I need help setting up the following cell formulas. Can anyone help with this? You'll notice Y changes value depending on it's juxtaposition to...	March 6th, 2009 11:16 PM by T. Valko	5	74

Page 71 of 4390

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 08:12 PM.