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

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Keyboard shortcut for current date and time by Raj[_4_] Hi, Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me Ctrl+Shift+; inserts the current time with the date serial as 0 and not the current...	June 2nd, 2010 04:24 AM by Jim Cone[_2_]	1	1,025
VLOOKUP problem by Crystal I'm using the VLOOKUP worksheet function and I'm having some issues with the result affecting my other formulas. Instead of the lookup returning "#N/A" when it...	September 15th, 2003 04:03 PM by Anon	1	1,024
Lookup in an Array by Steve Can somebody tell me how to look up a list of items in a column from an array and then return the information in a cell that is in a column which is the same... ( 1 2 3 ... Last Page)	November 6th, 2003 02:52 PM by Steve	36	1,023
Converting number to text by booshi Is it possible to convert, say 1234 to one thousand two hundred and thirty four Thanks	June 2nd, 2010 06:17 AM by Jacob Skaria	1	1,020
Numbering rows for sorting by Dan If i understand you correctly try this: Say you want your numbers from A1 to A1000 In A1 input the number 1. In A2 input the number 2. Hilight (select just...	September 15th, 2003 02:08 PM by Andy B	1	1,019
Transpose link by Ana via OfficeKB.com Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right corner of a cell. I will automaticly link A1 - C1 A2 - C2 A3 - C3 ect My question is...	June 3rd, 2010 12:42 PM by Jacob Skaria	5	1,018
How to count the maximum number of consecutives? by JP I need to determine the maximum number of consecutive negative numbers in a column. The column contains formulas that evaluate to a positive number, a...	January 2nd, 2010 11:19 PM by JLatham	9	1,017
"COUNTU" function in Excel to count unique entries in a range by WayneL In order to count the number of unique entries in a range of cells, a very complicated nested set of functions (SUM, IF, FREQUENCY, MATCH, LEN, etc.)... ( 1 2 3)	September 19th, 2008 03:50 AM by T. Valko	20	1,017
Opening Excel sheet with macro's on XP machines gives error by Dhanashree Bhat Hello, I have an Excel sheet which has macro's written as well as Calendar control used. This sheet was developed in Excel 97 (windows 98) environment. It...	September 17th, 2003 07:02 AM by Dhanashree Bhat	0	1,016
Add asterisk to excel cell by jblack35 How do you add an asterisk to the begining of a excel cell? or replace the zeros with a asterisk? For example, data come in the cell as 01222 but I want it...	March 8th, 2005 06:25 PM by Bob Tarburton	1	1,016
Counting Number of Cells Including Merged Cells by Daniel D. I am using Micosoft Excel 2000. My worksheet has contiguous cells that represent a "trade show booth." Most clients take only 1 booth but some will take 2, 3,... ( 1 2)	February 24th, 2004 01:27 AM by Harlan Grove	12	1,015
using cell contents in pathname by Don Guillett Since indirect won't work with closed files, couldn't u use indirect to make the reference and then just copy/paste special values? -- Don Guillett SalesAid...	January 2nd, 2004 02:11 PM by Howie	7	1,015
countif by Jim W I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the...	June 3rd, 2010 06:19 AM by L. Howard Kittle	3	1,013
View Message when Mouse Hovers over Cell. (Not the Comments Feild) by Kev - Radio Man Hi, I am interested if there is a way to have a message become visible when the mouse is hovered over a cell. I am currently using 2007. In this problem I...	June 1st, 2010 01:02 AM by Kev - Radio Man	2	1,012
Any experts on "countif" formula using nested conditions by Chuck I'm trying to get the count of the number of cells that contain a multiple condition using dates. Count the number of instances in cells A1 to A300 which are... ( 1 2 3 ... Last Page)	April 8th, 2004 06:54 PM by Chuck	31	1,009
COUNTIF function for multiple criteria by yorkshirelass I hope someone can help me. I devised a s/sheet in Excel 2007 using the COUNTIFS function. However, not all my colleagues like 2007 and have reverted back to...	June 18th, 2009 01:45 PM by Bernd P	8	1,008
Alternative formula to HLookup by Bernie Deitrick BeSmart, (I actually knew someone named B. Smart ;-0) Simply make the row lookup parameter dynamic: in this case, replace the 4 with ROW()-Row($BN$10) This...	March 26th, 2004 12:53 PM by Bernie Deitrick	0	1,006
find all / replace all used in a selected range by oldguy I feel sorry for you, but you should have noted that your selection was cleared after you pressed Find All button, leaving the whole sheet open for Replace All...	February 26th, 2004 01:05 PM by oldguy	0	1,006
MAKE EASY MOENY by Rajkovaca Ante - MAKE EZ AND FAST CASH, NO JOKE, JUS READ!!!!! : MAKE MONEY FAST!!!!!! IT WORKS!!!!!!! : IT'S SIMPLE AND IT'S LEGAL!!!!!!! I found this on : a bulletin board...	January 2nd, 2004 09:51 PM by Rajkovaca Ante	0	1,006
Pivot from multiple sheets by Radhakant Panigrahi hi, i have the below data and i need to make pivot from multiple sheets.i have tried to make by selecting multiple consolidation ranges, bbut it is not...	May 29th, 2010 05:20 AM by Herbert Seidenberg	1	1,005

Page 11 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 06:23 PM.