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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
horizont line above/whereupon font X or V by jafre
hi, i need consul, how make horizont line above/whereupon font X or V, i need for my work. THX
April 21st, 2010 02:58 AM
by T. Valko Go to last post
1 137
How do i extract worksheet cells with the same contents? by doncuba
Office Pro Microsoft Excel . I import three separate lists into one worksheet and want to extract only cells with similar contents to a separate worksheet.
April 21st, 2010 02:41 AM
by JLatham Go to last post
1 186
repeating number in a data by james
hiii sir i am working in a excel with 10,000 number of data...... these are the customers numbers and such time it will be repeated like that First...
April 21st, 2010 02:21 AM
by Ms-Exl-Learner Go to last post
2 236
SUMIF, use List as a Range by Emece
I have a list defined in a cell, using Data Validation. In another cell I want to use the SUMIF function, and as a range use the list selected in the cell...
April 21st, 2010 12:56 AM
by Emece Go to last post
2 262
Date format by Katerinia
Text in Column E is a date mddyyyy I need to calculate the age but the text format of this date is throwing off the number. Any...
April 21st, 2010 12:44 AM
by David Biddulph Go to last post
5 244
Adding digits in a column based on data in a separate column by adriver
I am making a log for incoming documents, and need to add the number of days each type of document takes to be processed. Example: Task Type ...
April 21st, 2010 12:41 AM
by JLatham Go to last post
4 305
median standard deviation by Omics
Hi, Anybody can tell me which function or formula should I use in excel to calculate the median standard deviation? Thanks a lot. Omics
April 21st, 2010 12:03 AM
by Joe User[_2_] Go to last post
7 305
Shading on highlighted range of cells by TippieToe
This is going to be hard to explain but here it goes. I am using Excel 2007. I would like to darken the shading when I highlight a range of cells. The...
April 20th, 2010 11:54 PM
by TippieToe Go to last post
0 232
Transferring files from a MAC by jms2106
A friend sent me an Excel spreadsheet created on her MAC with Excel 2007. I use Excel 2003. When I copied and pasted the cells from her worksheet to my...
April 20th, 2010 11:52 PM
by John Go to last post
1 193
Look up value range in column and then count by AJ
I have a column of numbers ranging from 0 to -100 I need to count the number of cells with in the ranges 0 to -6 -7 to -14 -15 to -28 -85 to -100 Can you tell...
April 20th, 2010 11:50 PM
by AJ Go to last post
3 220
Help with setting a "nof found" statement by Pierre
Hi. I have the following code: Private Sub CommandButton1_Click() Dim myasset As Variant Dim Assettag As Variant Assettag = UserForm1.TextBox1.Value
April 20th, 2010 11:37 PM
by Dave Peterson Go to last post
1 210
Macro problems by Father John
Hi I am trying to record a simple macro where if I press alt+d the location moves 7 "page down" key strokes - about 100 rows. However when I record the macro...
April 20th, 2010 11:24 PM
by Dave Peterson Go to last post
3 245
Average If, with a Moving Target by GroovyKincaid
Hi, I am trying to do something with an average that is similar to a sumif statement. The spreadsheet is a rolling 12 month forecast. What I have is an...
April 20th, 2010 11:12 PM
by GroovyKincaid Go to last post
0 180
Populate List Based on Cell Value - XL2003 by Nate
I have a drop down list of different sales managers. I would like to have the cells below the drop down list fill in the accounts assigned to the sales...
April 20th, 2010 09:54 PM
by Nate Go to last post
1 308
Network days by Sean
Please could someone tell me how to add 17 network days to a network day and have the DATE displayed in a cell and not the amount of network days. Lets say....
April 20th, 2010 09:29 PM
by Sean Go to last post
3 325
Urgent!! compare 2 columns of numbers for duplicates by SBecker
I have 2 columns of loan numbers, Scheduled Sales and Actual Sales (1 column is considerably shorter than the other), and I need to find which of the...
April 20th, 2010 09:23 PM
by SBecker Go to last post
2 237
Calculating a Series by deluth
Please help me put together a function to calculate a sum series as follows: For n = 0 to n=(B3-B1): sum ((A1 + (A3*n)) * A6) Thank you, Deluth
April 20th, 2010 08:57 PM
by Joe User[_2_] Go to last post
1 251
Copying Formula - Please help by musab
I am try to copy a formula for a cell above to the cells below. But the value of the cell above copies to the cell below. How can I fix that. Below is an...
April 20th, 2010 08:45 PM
by Gord Dibben Go to last post
2 215
Keep macros from being ran under the tools option in the menu bar by Jeremy
I have macros that are automated on excell 2003 and I am not wanting users to view or execute macros from clicking on tools then macro. How would I gray out...
April 20th, 2010 08:42 PM
by Gord Dibben Go to last post
3 337
Excel 2007: Slow copy/paste by Mike
I have a very small spreadsheet (last cell = K176) saved in xlsx format. No formulas, data is all manually enterd. When I do a copy/paste, the first...
April 20th, 2010 08:38 PM
by Mike Go to last post
8 242
Post New Thread

Display Options
Showing threads 2001 to 2020 of 139764
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 05:03 PM.

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