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
Sumif or Sumproduct? by alarson01
I simply can't figure this out... I have multiple locations that I need to find specific criteria and sum: A B C ...
June 12th, 2009 11:07 PM
by Bassman62 Go to last post
3 165
June 12th, 2009 10:36 PM
by Gord Dibben Go to last post
1 269
How do I change the default header date format in Excel 2007? by Jazzman721
Co-worker wants to use Long Date format in header or footer, but it always displays as short. Older versions of Excel there was a format button. I have also...
June 12th, 2009 10:35 PM
by Gord Dibben Go to last post
3 213
Count Unique Values by Richard
Is there a formula that will count the number of unique values based on a crriteria? For example. I have a sheet of part numbers with coresponding purchase...
June 12th, 2009 10:11 PM
by T. Valko Go to last post
7 169
Need Help Developing Formula by RockyFTI
Example of what I need: Columns: A- Qty G- $ x 1.15 I- 135 / Qty J- 85 / Qty K- 60 / Qty L- $ x 1.15 N- $ per each
June 12th, 2009 07:24 PM
by RockyFTI[_3_] Go to last post
4 204
DSUM - Need dynamic functionality by Don[_23_]
I have a large table with approx. 1500 rows and 34 columns. It compiles and summarizes payroll hours, by day of the week, type of hour, and location. Each...
June 12th, 2009 07:13 PM
by Harlan Grove[_2_] Go to last post
8 216
Data comparison for duplication by Donna
I have two workbooks. I want to compare names in one workbook to names in another workbook so that I can delete duplicate names. What would be the easiest...
June 12th, 2009 06:57 PM
by Shane Devenshire[_3_] Go to last post
1 162
Conditional Formatting by it''''''''sh hardy
Hey there... I'm trying to conditionally format multiple cells but am having issues. The format painter does not work properly. Is there a way to do it for...
June 12th, 2009 06:31 PM
by it''''''''sh hardy Go to last post
4 232
ENTERING TIME by Cletus
I have a spreadsheet in excel that I record length of time in. How can I enter the time and have the : automatically entered for me?
(Multi-page thread 1 2)
June 12th, 2009 05:50 PM
by Roger Govier[_3_] Go to last post
13 375
IF formula for time by Joshua
I have two columns Time taken to complete work Completed within 24hrs 23:00 ...
June 12th, 2009 05:27 PM
by T. Valko Go to last post
8 270
Difference between date and time by Joshua
I am trying to get the difference between date and time into the hh:mm format. Example: Start Date End Date Time taken to...
June 12th, 2009 05:22 PM
by Rich/rerat Go to last post
7 224
How to replace a formula string with * in the leading position? by Seaq
It's convenient to use Edit -- Replace tool to change part of a formula string with repeated characters, but strings that starting leading by the asterisk...
June 12th, 2009 04:45 PM
by T. Valko Go to last post
3 243
Index with mulitple value returns and muliple column returns by solar+CSE
Using =INDEX(Sheet2!$A$1:$B$67,SMALL(IF(Sheet2!$A$1:$A$67=Sheet1!$A$2,ROW(Sheet2!$A$1:$A$67)),ROW(1:1)),2) Is there a way to return multiple column values...
June 12th, 2009 04:43 PM
by T. Valko Go to last post
4 145
Delete BOTH sets duplicate data in columns (debits/credits) by Iamconstance
I am trying to find out how to delete BOTH sets of data in a column when there is not a unique entry. For example if I have a 10 in cell A1 and a 10 in cell...
June 12th, 2009 04:13 PM
by Bernie Deitrick Go to last post
1 184
how do I view up to 120,000 rows in office excel 2003 by Chikanox
how do I view up to 120,000 rows in office excel 2003? I received a file in office 2007 format 9 .xlsx that has up to 120,000 rows. I have office 2003 with a...
June 12th, 2009 03:56 PM
by Bernard Liengme[_2_] Go to last post
2 157
change cell colour according to date..... by RichLive
Hello I would be very grateful if anyone could help pont me in the right direction with a formula to do the following: I have a date in field D9 and I need...
June 12th, 2009 03:54 PM
by Bernard Liengme[_2_] Go to last post
2 155
Naming a worksheet tab from a reference cell by Finance Guru
Hi All, Using Excel 2007 Can I name a worksheet tab from a cell contained within the worksheet. I want to name a worksheet from the date contained in say A1...
June 12th, 2009 03:08 PM
by Luke M Go to last post
2 159
Can't analyze web data by willemeulen[_45_]
With help of a web query I update/refresh pricing data from the web, for some reason I cannot get results using sumproduct function. What is the problem with...
June 12th, 2009 02:57 PM
by willemeulen[_45_] Go to last post
0 151
Excel 2007 -- SUMIFS v SUMPRODUCT by MurrayBarn
I have had some very useful help from Jacob on an older version of Excel where he sorted my problem out with SUMPRODUCT (see Problem with Syntax? posted...
June 12th, 2009 02:53 PM
by Jacob Skaria Go to last post
4 197
Cell value determined by the current time and date by jschae
I need a cells value to be displayed depending on the what the current time of day it is. If the current time is between midnight and noon, then I want the...
June 12th, 2009 01:45 PM
by Jacob Skaria Go to last post
4 155
Post New Thread


Display Options
Showing threads 10161 to 10180 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 04:13 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.