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
Need formula creation by Soth
Hi I need help with formula creation. I'd like to look and find number in column A and B for duplicate numbers, then show its duplicate value or number in...
May 13th, 2009 09:02 PM
by Commish[_2_] Go to last post
1 100
Normalizing Excel data across rows by Greenstorm
I have a large spreadsheet (96 by 100) in Excel 2007 of recorded electrical data. Each row represents data taken from a single source, and each column...
May 13th, 2009 08:04 PM
by Glenn[_6_] Go to last post
2 127
VLookup multiple spreadsheets by Riley[_2_]
I have a database with about 50 spreadsheets, each containing data on different deals. I'm looking for the best way to pull data to a master summary tab,...
May 13th, 2009 07:35 PM
by Bernie Deitrick Go to last post
1 113
Mutliple Function Query - probably using Countif by Damo
Hi, I am trying to create a summary report detailing the number and value of new projects dependent upon whether they are live/closed and by the stage they...
May 13th, 2009 06:40 PM
by Damo Go to last post
2 134
Can I delete the data and keep formulas for a whole worksheet? by Annette
I keep records of individuals donations for our church . I want to close out the worksheet for the past year and delete the information but keep all the...
May 13th, 2009 06:26 PM
by FSt1 Go to last post
2 120
Sorting Dates in format "01/19/09" by SCH
How do I set my Excel to Always sort dates in the following format by Year, Month, and Day? My current setting sorts by Month, date, and then year. For...
May 13th, 2009 06:21 PM
by Ron Rosenfeld Go to last post
4 127
sumarize minutes and get the result in hours by Lucy
Hi.. i have a list of minutes and i want to sumarize them and get the result in hours, maybe excel has a function that makes it... thank u
May 13th, 2009 06:20 PM
by Sean Timmons Go to last post
1 130
Formula for counting and dividing by Preschool Mike[_2_]
Here's my example. Cells A1:H1 have + (plus sign: goal met) and - (minus sign: goal not met) in them and some cells in the same row have nothing if the goal...
May 13th, 2009 06:15 PM
by Sean Timmons Go to last post
1 105
How to use time in an IF formula by kwalker4
Good morning. I'm having trouble using time (minutes and seconds) in an IF formula. I'm trying to assign a rating to four time thresholds. My rating and...
May 13th, 2009 05:56 PM
by David Biddulph Go to last post
4 117
Lastrow by Bishop
I'm familiar with this code to find the last row: LastRow = .Range("A" & Rows.Count).End(xlUp).Row But what if I need LastRow to be at a certain value? If I...
May 13th, 2009 05:22 PM
by Gary''s Student Go to last post
2 98
Keeping a text box on the worksheet by Twin10
I've just recently been upgraded to Office 2007.... I am having trouble with a worksheet that has a text box in it...... When I print the worksheet the text...
May 13th, 2009 05:06 PM
by Twin10 Go to last post
0 153
Sort w/o header row - change default by Niecee
Excel 2003 determines if there is a header row or not. Half the time i'ts wrong. My file will never have one so I'd like to change the default to "no...
May 13th, 2009 04:55 PM
by Niecee Go to last post
0 119
Adding Data from Multiple Spreadsheets by Belle
I have createda spreadsheet which includes separate workbooks with figures for each month of the year, I have also created a workbook within this spreadsheet...
May 13th, 2009 04:37 PM
by creek533 Go to last post
2 96
Row height will not auto format by gladfelterk
I am using Excel 2007, and opening a spreadsheet in an older version of Excel. When I double click on the line between rows to auto format the row to the...
May 13th, 2009 04:18 PM
by gladfelterk Go to last post
0 91
If Month? by RJJ
I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than...
May 13th, 2009 04:12 PM
by RJJ Go to last post
8 141
data return using multiple conditions by Steven M.
I am trying to return the contents of a cell on a row which must meet multiple criteria. I have 2 worksheets, one which contains the criteria, the other...
May 13th, 2009 03:54 PM
by Steven M.[_2_] Go to last post
4 153
help calculated total for each month by jengy1
i am trying to calulate the total intake for each month ie january = 10 february = 6 march = 10 column a column b date ...
May 13th, 2009 03:36 PM
by Marcelo Go to last post
4 121
Visit Calculation by kashish
My data as below, Place Jan Fab Mar Apr A 1,2 3 11,12 3 B 5 2 3 C 30,31 2 5 5,2 C 1 2 10 15 B 3 17,25 24 24 A 17 20 9,10 5
May 13th, 2009 02:47 PM
by kashish Go to last post
2 112
How do I get a index% of two numbers when they are negative or pos by mrbernh
I am trying to get a formula to calculate the index% of two numbers when they are either positive or negative and sometimes when one is positive and the...
May 13th, 2009 02:40 PM
by CLR Go to last post
1 145
i NEED TO GET A FORMULA FOR (x-AVERAGEX) ? by SHALOJEM
I have to get a formula to put in excel for (x-Averagex) where x is given in the table.
May 13th, 2009 02:33 PM
by Glenn[_6_] Go to last post
2 122
Post New Thread


Display Options
Showing threads 11121 to 11140 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 02:10 AM.


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