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

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
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
Vlookup won't work by mkcma I believe I have tried everything and cannot get these particular two worksheets to bring me the matching data - there are over 6,000 lines so I really need to... ( 1 2)	December 29th, 2008 03:52 PM by xlmate via OfficeKB.com	18	238
Setting up functions and rules by Lori Hi all! I have a column with different numers (actually prices). I want to be able to set something up so each number can be given a certain value in the... ( 1 2)	January 18th, 2009 05:39 AM by Ragdyer	18	169
Some kind of Array-Sumproduct Function by ryguy7272 I have clients in Column C, and Revenue in Column V. I want to sum the revenue for all clients, probably using an array and a Sumproduct function. There is... ( 1 2)	January 24th, 2009 04:02 AM by Max	18	181
Excel crashes when typing "false" in VLookup function by pcbins While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following... ( 1 2)	January 30th, 2009 09:24 PM by Glenn[_6_]	18	221
Test 2 numbers by Dave Hello, two number in (say) a1 & b1 In another cell If the numbers are different how can i get Excel to return 1 or if the numbers are the same 2 d ( 1 2)	February 7th, 2009 09:03 PM by Shane Devenshire[_3_]	18	137
Pick Ref# randomly on an average by Kashyap Hi I have 2 columns as below.. Col A Col B Ref# \| Name 4565 \| ABC 6585 \| ABC 4314 \| ABC 5648 \| MNO 6546 \| MNO ( 1 2)	March 2nd, 2009 12:24 PM by Max	18	148
Matching data in two columns by Max Hello, I need help with finding the last game that two teams played each other, either home or away. This is to decide who will have the home town advantage... ( 1 2)	February 23rd, 2009 04:22 AM by T. Valko	18	214
Displaying items from a column list in another sheet? by pieman3 Hi Does anyone know how to display content from sequential cells in a column which is in another sheet in the same workbook and then continue repeat this? I... ( 1 2)	April 7th, 2009 03:03 PM by simon	18	141
VLOOKUP by Connie Martin I have such a struggle with this formula. I've looked in Help and Online in MS, but to no avail. It still remains a mystery! I have this formula that... ( 1 2)	October 31st, 2008 04:53 AM by Jack	18	242
How to create filter using criteria from other cells. by JLewis I have a spreadsheet with golf tournament data. I have an analysis sheet showing the counts of various scores on each hole. (10 Birdies, 5 Aces, etc). Now I... ( 1 2)	October 30th, 2008 12:46 AM by Peo Sjoblom	18	163
If statement by [email protected] I'm trying to create an if statement with multiple values but it doesn't seem to be working. ie...I have a column that has different values (1,2,3,4,5).... ( 1 2)	December 5th, 2007 07:12 PM by TRYING	18	79
Understanding SUMPRODUCT() by Jakobshavn Isbrae I am trying to use SUMPRODUCT instead of COUNTIF to count the number of even values between A1 and A20. The following attempts do not... ( 1 2)	February 4th, 2008 08:41 AM by Bob Phillips	18	222
sum a value depending on the value of a cell?? by UKMAN Hi I have 2 rows of data (31 columns wide), in each cell of the the top row is a variable i.e. B, B.5, P,; (upto 10 differant variables). In each cell of the... ( 1 2)	February 27th, 2008 05:00 PM by RagDyeR	18	141
Find position of first non-matching character by Greg Lovern I have two strings that start with the same characters, but at some unknown and varying point they begin to differ. I want the position number of the first... ( 1 2)	June 1st, 2008 01:52 AM by Harlan Grove[_2_]	18	113
Calculating of time by H. Nissen Hi I need to make a sheet, in which i can calculate different ours. The groundschedule is made with (t):mm and lokes like this: =IF(G3=$D$3;0;G3) ex: 15:00... ( 1 2)	July 5th, 2008 09:28 PM by H. Nissen[_2_]	18	129
Using an Excel sheet for batch delete by Colin Hayes HI All I have an Excel worksheet with a list of file names in column A. I'd like to use this list to look into a named directory (perhaps built in to the... ( 1 2)	September 23rd, 2008 04:38 PM by pgarcia	18	420
Date range lookup....tough one! by deeds I have 3 columns with the titles 01/01/08-03/31/08 04/01/08-07/31/08 08/01/08-12/31/08 CAT DOG ... ( 1 2)	October 23rd, 2008 04:58 PM by deeds	18	105
Formula for Dates by Daren Hello, I have four sets of dates that are supposed to occur in order. They are formatted as the 3/14/2001 format in Excel. Column A has a start date,... ( 1 2)	October 25th, 2008 03:35 AM by ShaneDevenshire	18	192
Copying a column list from one sheet to another and repeating??? by simon Hi Does anyone know how to copy a list of text in a column from one sheet and display it in another sheet but then continue to repeat the original list? I... ( 1 2)	April 22nd, 2009 08:06 PM by simon	18	166

Page 19 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 09:04 AM.