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
Keep Dependent Value While Deleting Precedents by Atilla
Lets say I filled Column A with a bunch of data, but I only wanted the data on every 2nd line, so I thought to myself... HMMM. Maybe I should set up a...
August 6th, 2008 08:18 PM
by Atilla Go to last post
3 85
remove duplicate rows from specific data in a column; excel 2007 by DS
I am trying to remove entire rows reletive to duplicate data in one specific column for example: A B C D E F 1 a1 b1 c1 d1 e1 ...
August 6th, 2008 08:16 PM
by Mike H Go to last post
1 85
Formula Error by roxiemayfield
I have the following formula with an error. I am trying to get an na to be a -0- if the lookup is...
August 6th, 2008 08:12 PM
by Mike H Go to last post
3 85
reference a closed filed from a cell and formula in an open file by dh13134
scenario: file ABC.xls has the number 5 in A1 (a closed file) file XYZ.xls has the number 10 in A1 (a closed file) file choose.xls (an open file) has EITHER...
(Multi-page thread 1 2)
August 6th, 2008 08:08 PM
by Peo Sjoblom[_2_] Go to last post
15 195
adding function to an existing formula by chickenita
I am an excel virgin, so please bear with me! I have an existing formula, I would like to divide the subtotal by 2, how would I do that? -- anita
August 6th, 2008 07:36 PM
by Glenn[_6_] Go to last post
2 101
Adding Day to find a next weekday by Dolt
Ok, I am trying to create a function that does the following.. Adds X amount of days to a particular day including ALL days but returning a result that is not...
(Multi-page thread 1 2)
August 6th, 2008 07:31 PM
by gafern Go to last post
12 148
convert yyyy-ww date to actual date by Pierre
Have a string of dates of produced items. All the dates are mmmm-mm (2007-06), for the 6th week in 2007 for instance. Looking for a formula to have it enter...
August 6th, 2008 07:02 PM
by Pierre Go to last post
2 100
Compare data from two worksheets and display difference into 3rd s by auntiespyke
Hi, I'm trying to compare names in two worksheets and display unmatching names on a third worksheet. WS#1 compares a new list of names in column A to WS#2...
August 6th, 2008 07:02 PM
by Pete_UK Go to last post
4 101
IF Statement by Libby
I have a list of 266 budget numbers and I want to create a formula that will translate the four diget code into the name of the program. I've started with...
August 6th, 2008 06:27 PM
by Peo Sjoblom[_2_] Go to last post
6 83
Extracting Data from another worksheet based on user input by Alvyn
Dear Sir/Mdm, Can anyone advise me how to perform the following in Excel? On worksheet B, I have a list of data in column A. Eg, A1=Holland, A2=England,...
(Multi-page thread 1 2)
August 6th, 2008 05:41 PM
by Sandy Mann Go to last post
14 169
precentage formula by Dphel
I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a formula that will tell me what the precentage is for the difference between both...
August 6th, 2008 05:13 PM
by John C[_2_] Go to last post
3 127
SUMIF by Mike
Please assume that my data will look like...
August 6th, 2008 04:53 PM
by Teethless mama Go to last post
1 71
How do I increase the font size when creating a drop down list? by DATA VALIDATION LIST
How do I increase the font size in a data validation list so that when the list appears it is large enough to read? I have already increased the font size...
August 6th, 2008 04:52 PM
by Peo Sjoblom[_2_] Go to last post
1 88
column subtotal by Mel
I use subtotals with filters to total piece work on different employees. When I open the file each time it makes me reclick the boxes I want subtotaled...
August 6th, 2008 04:38 PM
by Mel Go to last post
0 68
Excel 2003 by lindle101
I am trying to open delimited data in Excel. When I do, my part numbers (in this case, some with a dash) turn into dates. Is there a default I can turn off...
August 6th, 2008 04:37 PM
by lindle101 Go to last post
4 77
Can Tab name in worksheet change automatically by referencing a ce by Alvyn
Dear Sir/Mdm, Anyone kind enough to advice whether the following can be achieve and how? Default name for tab in an Excel sheet is Sheet 1, Sheet 2 etc. Is...
August 6th, 2008 04:17 PM
by Alvyn Go to last post
2 91
Cross-sheet formula and sort data by smuggy
Not sure if this is a new issue with Excel 2007 or if it was there before. When entering a formula into a worksheet (call it Sheet1), I firstly clicked open...
August 6th, 2008 04:15 PM
by smuggy Go to last post
0 58
Using lookup formula by [email protected]
I need to find a value in a table where value in Column A = "example" and date across Row 1 = "Aug-08". I am summarising data in a simple table in my first...
August 6th, 2008 04:00 PM
by [email protected] Go to last post
2 82
Copy custom footer across multiple sheets by Clark
Does anyone know how you can copy page settings across multiple pages? Example: margins and custom footers from one page in a file to the rest of the pages...
August 6th, 2008 03:59 PM
by Pete_UK Go to last post
3 93
password protects different worksheets n upload on the web by Kanika
I need to give differenet passwords to different worksheets and publish this on the web for all my users to do entries in this file,entries can be done...
August 6th, 2008 03:28 PM
by JP[_5_] Go to last post
1 105
Post New Thread


Display Options
Showing threads 21981 to 22000 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:22 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.