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 206
Delete Rows using If and Wildcard by Max2073
I'm trying to delete all rows that DO NOT contain the text "ENTER" in column F. I have tried a few different methods based upon research from this site, but...
March 16th, 2010 04:24 PM
by Don Guillett[_2_] Go to last post
2 176
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 174
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 163
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 230
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 242
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 151
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 220
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 136
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 125
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 136
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 125
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 181
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 125
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 119
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 118
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 276
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 130
REquires a formulae by FredDave
Requires a f
March 16th, 2010 12:44 AM
by FredDave Go to last post
0 131
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 154
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 09:33 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.