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 Reverse Sort Order Replies Views
Vlookup-Doesn't return values under 1 by Carolina
I have Sheet 2 with 6 columns, one of them with ascending numbers on column A 0-8.99 with two decimals. The other 5 columns are payouts per title and if...
March 16th, 2010 04:24 PM
by Carolina Go to last post
2 122
How to change numbers from positive to negative. by tammy p
not sure if there is an easy way to do this other than physically rekeying the number. is there a formula or something for me to use to change a number from...
March 16th, 2010 04:15 PM
by Luke M[_4_] Go to last post
2 101
Delete Rows using Wildcard by Max2073
I'm trying to make delete all rows that DO NOT contain the text "Enter" in column F. I need to use a wildcard - as a number of cells contain additional...
March 16th, 2010 03:53 PM
by Luke M[_4_] Go to last post
2 94
Yearly sum by jam[_3_]
Any help? I have a column that I want the monthly sum and then the yearly sum, any way to make it easier? A B 1 Jan 2 1 100 3 2 150 4 3 260 5 31 100 6 Sum 610
March 16th, 2010 03:40 PM
by Luke M[_4_] Go to last post
3 88
autopopulate based on a cell value by Art
I created a spreadsheet in Excel 2007 for instructors to use to prepare multple choice questions for an exam. Each row represents a different questions. So,...
March 16th, 2010 03:34 PM
by Art Go to last post
2 82
delete columns in spreadsheet after data entered so it wont scroll by Question
can i delete columns in spreadsheet after data entered so it wont scroll to the right endlessly or upto IV... thanks!
March 16th, 2010 03:19 PM
by Jacob Skaria Go to last post
1 74
List top five by Dazed&Confused
Hi there, I've searched this site looking for an answer for this but no luck What I have is imported list of invoices thousands of rows long with about 450...
March 16th, 2010 03:13 PM
by Dazed&Confused Go to last post
4 78
Vlookup-Doesn't return values under 1 by Carolina
I have Sheet 2 with 6 columns, one of them with ascending numbers on column A 0-8.99 with two decimals. The other 5 columns are payouts per title and if...
March 16th, 2010 02:59 PM
by Jacob Skaria Go to last post
1 70
Help to create a formulae by FredDave
I have 5 sheets, Heath, Gary, John and Fred. They go to their sheet Heading: Date Question1 Question2 Question3 They ent 3/3 5 6...
March 16th, 2010 02:33 PM
by Don Guillett[_2_] Go to last post
1 82
Sumproduct for Values over a certain Value eg 0.00 by enna49
Hi I am using the code below and only want to sum the Values over 0.00, but if I add 0 to this it does the COUNT. Please can you let me know if there is...
March 16th, 2010 02:07 PM
by Max Go to last post
3 96
What-if-Analysis feature of spreadsheet by LATA
SEND ME USE OF IT
March 16th, 2010 01:42 PM
by Jacob Skaria Go to last post
1 76
How do I get drop-down list that includes, eg top10 by RichardHouse
I've seen a drop down list on an excel speardsheet that includes top10, all, blanks, sort ascending and also adds to the list everything entered in the...
March 16th, 2010 11:41 AM
by trip_to_tokyo[_3_] Go to last post
1 76
Macro Help by Curtis[_6_]
I am very new to Macro's but am hoping you can simplify your response I have a sheet that contains certain data types in specific columns For example...
March 16th, 2010 10:34 AM
by Jacob Skaria Go to last post
1 70
excel sum values if cell matches a value by Dennis
I am trying to analyze a survey. Results are...
March 16th, 2010 05:43 AM
by Jacob Skaria Go to last post
1 76
Help on percentages greater than 100 by cil
Thanks in advance for your assistance. I have a fairly larger list of numbers that needs to be divided to get a percntage. Due to restrictions, accesses etc...
March 16th, 2010 02:28 AM
by T. Valko Go to last post
3 80
Calculating %'s with IF and Sum/SumIF by Billy B
I have the following formula that works correctly. The formulas is used to calculate grades for my...
(Multi-page thread 1 2)
March 16th, 2010 01:18 AM
by Joe User[_2_] Go to last post
12 168
rename worksheet tabs by fix me
Hello, Maybe you guys can help me. Is there a way rename the worksheet tabs in an Excel file that I've already created? Example... I've already created a...
March 16th, 2010 12:55 AM
by Gord Dibben Go to last post
2 82
REquires a formulae by FredDave
Requires a f
March 16th, 2010 12:44 AM
by FredDave Go to last post
0 83
Formula causing run-time error in Excel Programming by cherman
This is a repost. I have the following line of code that I am trying to drop in a cell via Access VBA but I keep getting a Run-time error 1004,...
March 15th, 2010 11:59 PM
by cherman Go to last post
2 85
Is there a way to use a multiple column array in SUMPRODUCT? by rk
I am attempting to use SUMPRODUCT to pull values froma multiple column spreadsheet and add them together. I am able to get the SUMPRODUCT to work if I am...
March 15th, 2010 11:34 PM
by Teethless mama Go to last post
2 82
Post New Thread


Display Options
Showing threads 2101 to 2120 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 07:28 PM.


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