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
I am trying to link by Ego Id Pamela
I am working with an old template that's been used over and over again however my boss wants to finally perfect it..so she has changes that need to made. I...
April 9th, 2009 06:25 PM
by Ego Id Pamela[_2_] Go to last post
2 66
Automatic Worksheet Calculation when Worksheet Name Changes by Sabre472
All, I have some VB functions that are called on one Worksheet. The functions reference the Worksheet's name. The Worksheet starts as a "prototype". I...
April 9th, 2009 06:17 PM
by Bernie Deitrick Go to last post
1 68
Which is Better / More Functional / Accurate by Rob
I was wondering if I can get an opinion on which is better; SUMIF OR SUMPRODUCT. I suspect the answer will be SuMPRODUCT, however there are so many ways...
April 9th, 2009 06:17 PM
by T. Valko Go to last post
2 59
Using NULL in shading cells by Lenny
I have entered conditional formatting in a cell that is basing the results on numbers entered into 2 cells, C7 and C8 with the conditional formatting in Cell...
April 9th, 2009 06:16 PM
by Lenny Go to last post
2 68
Converting number of days by Radrays
How can I convert a number into days, months and possibly years? I have the number 195.4642 which equals a number in days. I need that number represented...
April 9th, 2009 06:09 PM
by Radrays Go to last post
2 62
Problems CONCATENATE expression by tech1NJ
I would like to CONCATENATE the phrases "expire on " with date from Sheet2!D32 and the phrase "your last Manufacturer's preventive maintanence with...
April 9th, 2009 05:45 PM
by T. Valko Go to last post
1 55
sum the current month by tleehh
A B 2/9/09 100 3/1/09 200 4/4/09 150 4/19/09 125 4/29/09 75 5/4/09 ...
April 9th, 2009 05:03 PM
by tleehh Go to last post
2 55
merging data/worksheets by joec
I am charged with combining data from 12 different excel workbooks into one worksheet. Each workbook has data entered on 5 different worksheets. All of the...
April 9th, 2009 04:46 PM
by Bernie Deitrick Go to last post
1 61
How to find a column number using variable criteria? by RobofMN
I'm trying to find a column value return similar to the function the MATCH function performs for rows. I have a large spreadsheet with part numbers for a...
April 9th, 2009 04:41 PM
by RobofMN Go to last post
2 54
Vlookup and return the value from the look up value sheet by Burmalion
Dear anyone, I have come across with vlookup funtion which i have to use it at my work. I have two sheets. Sheet 1 has charge codes and value, and sheet 2 has...
April 9th, 2009 04:39 PM
by Kassie Go to last post
1 59
How do I total amounts on various sheets in excel? by ExcelNewby
How do I use the SUM function to total amounts from one sheet to another within the same document?
April 9th, 2009 04:20 PM
by David Biddulph Go to last post
4 79
Date calculations resulting in negative numbers and averages by Radrays
Thank you for your time - I have a two fold question please. I am currently using =DAYS360(C3,D3) to calculate aging betwen dates. Is there a way to leave...
April 9th, 2009 04:14 PM
by Dave Peterson Go to last post
4 55
Calculate Monthly Inventory Usage by Brian
I'm trying to calculate monthly inventory usage from data retrieved from daily usage reports. The formula below works, but not sure how to ignore rows with...
April 9th, 2009 04:08 PM
by Brian Go to last post
5 50
Get value equal to final point of chart trendline [=Trend( )] ? by ker_01
I don't use trendlines much, and when I do it is just for the visual. Now I find myself in a situation where I need to plot the trendline, but also take the...
April 9th, 2009 04:00 PM
by Bernie Deitrick Go to last post
1 63
How Accurate is Solver? by andysween
I want to compare two different optimal scenarios answers obtained from Solver but they are quite close. I want to say, well scenario X's optimal value is so...
April 9th, 2009 03:50 PM
by Bernie Deitrick Go to last post
1 71
Horizontal Scolling Does not Work by DCJoe
Good evening, I do help desk work and I have a user that is unable to scroll to the right in Excel. It doesn't matter if it is a new spreadsheet or an...
April 9th, 2009 03:47 PM
by Bernie Deitrick Go to last post
1 68
Customized marcos cannot save to tools-bar by Elton Law[_2_]
Dear expert, Wanna customize a macro in Tools-bar. Have right-click the tools-bar, then add the smily face button, have assigned the macro, finally rename and...
April 9th, 2009 03:46 PM
by Bernie Deitrick Go to last post
1 65
format as a table and cannot remove formatting by Kate
After I change a table format I cannot remove the formating thru conditional formatting and clear rules. How do I get it to remove the formatting?
April 9th, 2009 03:06 PM
by Kate Go to last post
0 50
Remove Zero Formula by TGalin
How can I change this formula =SUM(B5:D5) so that it will return a blank cell instead of a zero if B5:D5 is empty?
April 9th, 2009 03:05 PM
by Glenn[_6_] Go to last post
6 82
Percentage to Get Invested Return by Markey
I pulled these numbers manually but would like to learn how to do it with Excel. A small nonprofit would like to receive $25,000 annually from their...
April 9th, 2009 01:27 PM
by Markey Go to last post
2 77
Post New Thread


Display Options
Showing threads 12321 to 12340 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:58 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.