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
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 99
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 151
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 116
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 113
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 111
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 127
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 140
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 110
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 92
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 110
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 130
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 124
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 128
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 129
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 134
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 113
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 122
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 121
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 188
How can I merge unprotected cells in a protected worksheet? by cnaval
I have a protected worksheet that allows users to edit unprotected cells. Each cells can be formatted but not merge.
April 28th, 2010 12:43 AM
by Gord Dibben Go to last post
1 119
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 02:45 PM.


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