A Microsoft Office (Excel, Word) forum. 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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Views Reverse Sort Order
Need an input box when user selects a value in a drop down box by Susan
Hello... I need some help... not sure how to do the following: I have a spreadsheet that contains a drop down list in column B (note only various rows in...
September 8th, 2008 06:14 PM
by Sara Go to last post
4 131
Update by robzrob
Is there any way to update a workbook (which is getting data from another workbook) without shutting it down, opening it again and clicking 'Yes' to the update...
June 16th, 2008 11:31 PM
by robzrob Go to last post
2 131
Counting in a spreadsheet by P. Zicari
I am creating a spreadsheet to keep track of how many people sign up for a particular course. Is there a way that I can get a count of how many cells in a...
June 23rd, 2008 08:18 PM
by ryguy7272 Go to last post
2 131
How do I change date yyyymmdd to a Excel-supported date format? by dan
I have a column of imported data information of the format yyyymmdd, e.g., 18400314. Excel does not recognize this date format. How do I change it so that...
July 6th, 2008 11:05 PM
by dan Go to last post
4 131
Sum up all up changes and down changes by Tetsuya Oguma
Hi all, Suppose I have a data series like below A B Data Chg 46.1250 47.1250 1.0000 46.4375 -0.6875 46.9375 0.5000 44.9375 ...
July 16th, 2008 06:48 AM
by Max Go to last post
3 131
Nested if using range names by DianeG
Hi I know that you can use VLOOKUP instead of IF's to get a result but I'm trying to get Chip Pearson's example to work. The problem is as follows: I have a...
July 22nd, 2008 06:06 PM
by Bernard Liengme Go to last post
1 131
Working with Functions on French Computer by Cazzy123
Hi, I have just bought a French computer and can't get the simplest of formula's to work. I am trying to do an IF or Si statement but it won't work but if I...
August 7th, 2008 11:17 AM
by Niek Otten Go to last post
3 131
match with isna formula question by Belinda7237
I want to bridge info from one workbook to a new workbook with a formula in column V. but i have two criteria instead of one to consider the match before...
August 28th, 2008 12:52 PM
by Belinda7237 Go to last post
2 131
#NAME? by 77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
August 28th, 2008 06:54 PM
by 77Debbie77 Go to last post
5 131
Inserting rows in a protected sheet - Office 2003 by Todd A[_2_]
Hello, The function 'Insert Row' in the window when Protect sheet is selected is supposed to allow row insertion in a protected sheet. I have 24 sheets that...
June 11th, 2008 05:50 PM
by Todd A[_2_] Go to last post
2 131
How can I convert text to number? by northerner
-- Have a great day!
May 21st, 2008 02:28 PM
by Niek Otten Go to last post
1 131
Problem with fomula IF, AND, OR... help by [email protected]
Hy, I am trayng to do formula for sport betting. but i have problem with 1x and x2. How to make formula for this; A B C 1 1 1 1 2 0 1 x ...
April 14th, 2008 10:32 PM
by Max Go to last post
5 131
Save file as semi-colon delimited? by Colin Hayes
HI I need to save a file as semi-colon (;) separated. Does any one know how to do this? I can only see tab , space or comma CSV options in the 'save as...
April 22nd, 2008 08:21 AM
by Stefi Go to last post
2 131
Nesting by LWilson
I've got a table of data... Loan number, tran code, acct, amt. I need to sum the amounts for the loan number that equal a certain tran code and acct...
(Multi-page thread 1 2)
May 9th, 2008 08:43 PM
by LWilson Go to last post
12 131
Complicated working days function by Chris
I have a start date in F2 and an end date in G2. I am currently using this formula for the number of working days, which works...
May 1st, 2008 08:47 AM
by Bob Phillips Go to last post
7 131
How to set macro to Paste Special Value to next empty column by [email protected]
Range("P32,Q7:Q32").Select Range("Q7").Activate ActiveWindow.SmallScroll Down:=-12 Range("Q7:Q32").Select Selection.Copy ...
May 5th, 2008 11:57 PM
by Max Go to last post
9 131
Two columns of data - How to get the unmatching cell data to colum by Cpviv
Hi, I have column A with 95 cells data and column B with 183 cells data. Column A has some cells data that not match with column B cells data. How to get...
May 16th, 2008 05:51 PM
by Gaurav[_6_] Go to last post
1 131
Auto "convert" a number to a different number by Rick
I have a cell that will display a number, i.e. 0.25, by the use of the formula =LARGE(P3:P43,1). I want to use this cell in a division formula in a second...
May 17th, 2008 11:16 PM
by Rick Go to last post
4 131
XIRR Problem by Dkline
I am trying to use XIRR to solve for the rate for a known schedule of dates and value. That schedule is below. I have solved for the rate using IRR and also...
May 20th, 2008 10:10 PM
by Dkline Go to last post
8 131
countif criteria sg by Fred Loh
i have a column (column B) of cells with numbers in the cells. i want to count for. example, how many cells have a number between 12 and 29. i used...
September 8th, 2008 03:35 PM
by Don Guillett Go to last post
7 131
Post New Thread


Display Options
Showing threads 20001 to 20020 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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 01:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.