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
How can my cursor move to an input cell without going to formulas by Michel
I have a workbook with working figures. I would prefer to have my cursor move automatically to input cells by ignoring the cell where I have formulas. How...
May 20th, 2010 06:18 PM
by Gord Dibben Go to last post
1 228
Formulas displayed in cell rather than calculated values? by Don M.
I have this problem come up at randon about once or twice a year. I always have my options set to show formula values in a cell, never the formulas...
May 20th, 2010 04:41 PM
by Don M. Go to last post
4 314
If function help by Mezani
I have two cells that each have drop down lists. The first cell has the text yes and no, If i choose yes i want the second cell to return N/A for example, and...
May 20th, 2010 04:30 PM
by Eduardo Go to last post
4 246
Sumproduct seems off... HELP PLEASE! by Hile
WinXPPro SP3, Excel 2k OK so I'm using sumprod and something just doesn't seem right. Col B should clearly have a higher weighted average than Col C. Can...
May 20th, 2010 04:24 PM
by Hile Go to last post
3 210
May 20th, 2010 02:39 PM
by Fred Smith[_4_] Go to last post
2 332
Totals for month if 2 conditions are met by Carrach
Hi, Wonder if anyone could put me on the correct track? I need to show the totals for the following: (if target_name_sheet1=target_name_this sheet)and(if...
May 20th, 2010 11:29 AM
by Carrach Go to last post
3 200
How to Rank Name? by Matlock
I have a Power Ranking Excel Book for my partner Restaurants that lists us from 1st - 14th in different categories through the year. ------- Example 1...
May 20th, 2010 08:08 AM
by Bernd P Go to last post
4 240
changing worksheet reference name when copying down cells by ferne
I have a yearly summary worksheet by week. Each week i add the weekly report to the workbook. I need a formula on the summary sheet that will change the...
May 20th, 2010 02:55 AM
by ferne Go to last post
5 328
Filter formula by Michel
HI I have a database with repeated informations as listed below and is increasing daily Nat Firm Name SPAIN VIAJES EL CORTE INGLES SPAIN VIAJES EL CORTE...
May 20th, 2010 12:25 AM
by Max Go to last post
1 149
function help! by CT
I want to find if one item sold this month is also sold in last month. If so, return the quantify sold last month. How do I do that? thanks a lot. that...
May 20th, 2010 12:12 AM
by Max Go to last post
1 131
Summing multi-level bill of material by Nathan356
All, I have a multi-level bill of material and I want to create a function that will sum it properly without having to sum up each level manually. Here is...
May 19th, 2010 11:37 PM
by Nathan356 Go to last post
0 137
Delete all sheets in workbook that contain "Dump" in the name by Porr via OfficeKB.com
Hello, I have a workbook that generally contains 15-18 worksheets. Is it possible to automate the deletion of only the worksheets with a name that contains...
May 19th, 2010 10:25 PM
by Porr via OfficeKB.com Go to last post
2 213
SumProduct using Date Range by NMK
I need to sum a values using multiple criteria and a date range. Example - I need to sum the total amount of all investors that have an "N" in the n/e...
May 19th, 2010 10:02 PM
by T. Valko Go to last post
1 196
SUMPRODUCT with date range by NMK
I need help with a sumproduct formula that will sum with three difference types of criteria and also use a date range? Any suggestions?
May 19th, 2010 09:40 PM
by T. Valko Go to last post
1 260
networkdays alternative by Gabe
I have several people that are not familiar with the Analysis Toolpak, is there a work around for the networkdays function? I just have two dates in B33...
May 19th, 2010 09:30 PM
by Chip Pearson Go to last post
2 175
pivot table by Stephanie
how do I do a pivot table with data that is on multiple worksheets?
May 19th, 2010 09:10 PM
by Roger Govier[_8_] Go to last post
1 139
UNABLE TO DRAG THE VALUE? by UNABLE TO DRAG THE VALUE?
May 19th, 2010 09:05 PM
by Gord Dibben Go to last post
1 156
Which function will shorten IF-THEN-ELSE ? by Jack Ryan[_2_]
Here's a simplified example of what I want to do: Col A Col B Row 1 yes 5 Row 2 10 Row 3 yes ...
May 19th, 2010 09:03 PM
by Roger Govier[_8_] Go to last post
5 144
Text Functions by Charlie
I'm trying to split a text string ... Apart from it not working quite right yet! I'm sure I've over complicated it. Base Data "Path": \\SERVER\X$\data\Team...
May 19th, 2010 07:59 PM
by Charlie Go to last post
2 203
How can I make a drop down box visible within a worksheet? by skittles_golf
I have created several Drop Down boxes in a worksheet but I want to make them visible so people know there is a drop down box there. Right now the arrow...
(Multi-page thread 1 2 3 ... Last Page)
May 19th, 2010 07:43 PM
by Cheers and Beers Go to last post
40 2,463
Post New Thread


Display Options
Showing threads 421 to 440 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:50 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.