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
Default Cell Values at Change by TheDrescher
I keep getting stuck on a workbook I'm finishing up. Basically it displays information on a front sheet that pulls from arrays on other sheets based on a...
April 28th, 2010 04:41 PM
by TheDrescher Go to last post
2 170
Deleting/Clearing duplicate range of cells by Steve
Below is my data. If a row range of cells is identical to another, could a macro be written to find the duplicated rows, and clear those cells ? As...
April 28th, 2010 03:59 PM
by Steve Go to last post
0 155
Can not copy a sheet to another book by dveer
When I open 2 workbooks in 2 instances of Excel on my computer, I can not copy a sheet from one book to the other. It is also not possible to tile the 2...
April 28th, 2010 03:47 PM
by Gord Dibben Go to last post
7 209
HOW DO I COLLECT TEXT DATA FROM A COLUMN by skr
I have a worksheet of about 400 rows and 5 columns. Most of the data is repeated with varying values. I need to calculate / separate data for each item in...
April 28th, 2010 03:28 PM
by Ron Rosenfeld Go to last post
2 178
If column A = B then pick up value in D. by Peter Gasparik
Hi I have a problem. I have two columns in different spreadsheets: A B D 27238-2807 ...
April 28th, 2010 01:56 PM
by Jacob Skaria Go to last post
3 154
SUMPRODUCT with conditions by CW
Hi All I have a formula which is working as follows: =SUMPRODUCT((Data1!B4:B52="Testing")*(Data1!D4:D52"")) This basically counts the numbers of values in...
April 28th, 2010 01:39 PM
by Pete_UK Go to last post
4 168
Increase PF Usage by EricB
Hi Is it possible to increase PF Usage or Physical Memory to have a program, in my case EXCEL, run faster. When running a big EXCEL file, say 28MB, the file...
April 28th, 2010 01:11 PM
by JLatham Go to last post
2 178
Using cell reference with logical operator in DGET expression by BoxleyFarm
I am using DGET to search an array in the worksheet to find a particular percent to use in a calculation elsewhere in the spreadsheet. The row members of the...
April 28th, 2010 11:31 AM
by ozgrid.com Go to last post
1 180
Establishing a Time Window by NoodNutt
Hi Everyone I am trying to create a formula that will provide one of the following: Arrival Window: 40 Mins = 20 Mins Early to 20 Mins Late. So this is what...
April 28th, 2010 11:23 AM
by NoodNutt Go to last post
2 165
Calendar by [email protected]
Can anybody tell me why Any Year Calendar4 does not work from Microsoft website Thanks
April 28th, 2010 09:10 AM
by [email protected] Go to last post
2 133
Help with Vlookup by ShaneChop
In my table array I only have two columns, the first contains percents and the other contains a letter grade that corresponds to that percent. Such as 100%,...
April 28th, 2010 08:03 AM
by Jacob Skaria Go to last post
2 147
To deal with #NA by Amin
i want to stop the #N/A showing in my cells where the VLookup has been used is it possiblt to stop them from showing when a a lookup value is not yet...
April 28th, 2010 07:06 AM
by Jacob Skaria Go to last post
2 201
How to find the custom xml tags in a workbook by Cyril
We have work books where a user designs a layout using a xsd schema, & we populate the data in those fields. Problem is I need to find where each of the...
April 28th, 2010 05:53 AM
by Cyril Go to last post
0 153
How do I fix loosing 1st digit in zip code in mail merge? by Lori
I have a spreadsheet with headers for a mailing. When I do the mail merge the first digit in the zip code is dropping off. I have the cells formated for...
April 28th, 2010 03:06 AM
by Alex Go to last post
2 168
Drop Down Menu AutoPopulate Contact Info? by Clay H
I have a template for filling out quotes and I was looking to create a drop down menu with all of the names of customers that I regularly send out quotes to...
April 28th, 2010 02:48 AM
by Dave Peterson Go to last post
2 154
FAO Mike H - Formula Answer provided by Pat Convey
Hello Mike, Apologies for the delay in responding to your answer you gave below Pat, with the amount owed in A1 try...
April 28th, 2010 01:59 AM
by T. Valko Go to last post
3 160
Worksheet relative reference by Ciprian
Hi, I have created in a workbook a worksheet containing formulas with relative and absolute references to other worksheets in the same workbook. As I have...
April 28th, 2010 01:37 AM
by ozgrid.com Go to last post
3 142
How do I set a constant multiplier in an equation? by dalmar
When using excel to make a spread sheet with list prices, net prices with constant multipkiers, How do I set a constant multiplier in an equation? The old...
April 28th, 2010 01:31 AM
by Dave Peterson Go to last post
3 148
How to use autofilter in excel with formula reference changing by Marcio
Hi, I have a table A B C 1 forro 120 2 ment 80 40 3 forro 50 30 4 ment 40 10 5 ment 30 10 6 forro 20 10 7 forro 10 10
April 28th, 2010 01:29 AM
by T. Valko Go to last post
1 154
how do i replace #n/a in a vlookup? by infinite1013
Can you please show me how to replace the #N/A result with 0? =VLOOKUP(L2,'March Chargebacks'!A$1:F$613,6,FALSE)
(Multi-page thread 1 2)
April 28th, 2010 01:21 AM
by Gord Dibben Go to last post
15 289
Post New Thread


Display Options
Showing threads 941 to 960 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 06: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.