Worksheet Functions - Page 30 - 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 30 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
sum a row, but just the cells, where there is a number. by ??RUTH?? hi, I want to calculate numbers in a row, but just, when there is a number in the cell. if there is no number, don't count. I...	August 30th, 2006 05:51 PM by tim m	1	59
Look-up (match) and merge data by ?Info? I need to match a column on two sheets. Then use that match to pull over multiple other cells related to that matched cell. For example: Each Sheet...	May 22nd, 2008 11:56 PM by Max	1	168
?ÈZÈk ?ˆ¡??ˆra? ??ˆs?Çþ by ?ˆ¡?_???ÈD	March 19th, 2009 05:34 AM by ?ˆ¡?_???ÈD	0	48
?ÈZÈk ?ˆ¡??ˆra? ??ˆs?Çþ by ?ˆ¡?_???ÈD	March 19th, 2009 05:34 AM by ?ˆ¡?_???ÈD	0	39
how to use vlookup/find etc to extract rows by a For a table like: ATOM 11 C ASN 2 35.233 -19.675 10.91 1 21.57 1L25 247 ATOM 12 O ASN 2 36.364 -19.365 10.571 1 14.91 1L25 248 ATOM 13 CB...	December 26th, 2007 07:03 PM by Herbert Seidenberg	1	78
SQL like function? by a In excel, is there any function like select colA from tableB where colC="a string" so a new column colD with cells packed together will be generated?	December 18th, 2007 10:43 PM by a	0	69
Advanced filter by a please I want to know what is benefit of using advanced Filter? Any example or web page demonstrate advanced Filter Thank you	February 4th, 2008 08:11 AM by Max	1	109
intersection of row and column by a Hello, I have the following table on sheet 2 attribute a attribute b attribute 3 attribute...	April 19th, 2005 05:01 PM by Gord Dibben	5	110
Problem with Using "Multiply by 1" by A I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip...	June 11th, 2009 03:27 PM by A	5	160
VLOOKUP by a I am trying to build a worksheet with 50 tabs and a summary page. Each contain lists of data. I want the summary page to look up and match the data on each...	November 5th, 2007 11:52 PM by Gord Dibben	3	42
aligning text by A Under format cells/alignment, I have seen the option to horizontally align text to "Centre across Selection" (the text is also wrapped across this...	August 22nd, 2007 03:25 PM by Gord Dibben	4	67
Populating several cells by A I have two worksheets, one has a complete list of customers (many columns: name, phone, address; each row is a different customer, there are well over 2000,...	September 15th, 2005 05:58 PM by Gary''s Student	1	71
Auto sort by A I want to take a list of customers and sort them by 'date of next visit' (closest date being at the top of the page). After each visit, I would assign a new...	March 29th, 2006 11:13 PM by Dave Peterson	1	69
Excel File corrupted by a Dear Members, I was working in Excel in a file and light gone, when I started the same file next day this msg appear "this file is not in a...	July 22nd, 2009 08:18 AM by a	0	124
Converting a Grid (or range) of Data to a List by a Hi - I need help converting the following Grid of data into a list. Sample of my data is below: ( I have A LOT of lines of...	April 12th, 2007 10:14 PM by Dave Peterson	1	96
recursive formula question by a For an array like: 893.0186 985.561 1045.56 1154.58 1271.604 1272.623 ....	May 8th, 2007 09:29 AM by a	0	75
Cell References by a How do I make a cell equal to the name of the worksheet that I am currently using without typing the name in each worksheet?	September 15th, 2009 08:57 PM by Nebulous	4	74
HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL by a babe in need Hi can anyone help me I am trying to work out a VAT return short cut if my col A has a total of 0.00 in it I want to add its number next door in B i.e. a1 ...	January 27th, 2009 02:36 AM by Guy	4	115
Date Functions for Excel published to HTML by A Bald I publish my Excel as HTML or Web pages but am losing the DATE functionality in the browser (i.e. as per Tools Add-Ins Analysis and Analysis VBA). How do I...	March 5th, 2007 04:03 AM by A Bald	0	63
How do I replace negative numbers with zero in Excel. by A Blaylock =IF(A1 0,0,IF(A1 0,A1)) "callmewelldolunch" wrote: I need a formula in excel to only output numbers greater than zero and replace any negative number...	March 16th, 2006 09:08 PM by A Blaylock	0	134

Page 30 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 11:54 AM.