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
vLookup and Line Breaking by Jon M.
Greetings all, I have a worksheet where cell B8 and B10 perform a vLookup based on a data validation in B6:...
March 10th, 2010 07:56 PM
by Jon M. Go to last post
0 101
Macrs with Validation Rules by Chris
I have a spread sheet with a tab called Estimnates once the Validation Item for the estimated item is changed to "Contracted" I want it to Copy the Entire...
March 10th, 2010 07:37 PM
by Don Guillett[_2_] Go to last post
1 125
Month (MMM) from date (dd/mmm/yy) by Annie1904
In my spreadsheet I have a date column (col A) which I have in format (dd/mmm/yy). I need to show the corresponding month in Col B, in MMM format - April,...
March 10th, 2010 06:08 PM
by Gary''s Student Go to last post
1 127
report by date from a list of records by UKMAN
Hi The list is made up of records for training courses and includes start and end dates and course duration, i.e. Name of person, start: 1 mar 2010, ends 4...
(Multi-page thread 1 2)
March 10th, 2010 05:50 PM
by UKMAN Go to last post
13 358
Custom Cell Formatting Using % With Dates by Jason McDonald
First, thanks in advance for any help. I'm using the NETWORKDAYS function along with the TODAY function to calculate the amount of time that has elapsed for a...
March 10th, 2010 05:13 PM
by Fred Smith[_4_] Go to last post
2 157
how to sheet1 data goes to sheet2 automaticaly ? by ABDUSSALAM
Hai all I would like to know one excel sheet1 data to sheet2 automaticaly,which command use for it ,please....
March 10th, 2010 05:12 PM
by Pete_UK Go to last post
2 129
Dynamic Named Ranges - is this possible? by Code Numpty
Is it possible to take 2 dynamic named ranges that are effectively side by side and print them on one piece of paper, one below the other? I hope so........
March 10th, 2010 05:01 PM
by Code Numpty Go to last post
2 110
Matching Data by Alex Hammerstein
Hi I have two sheets in a single workbook I want to look up where data in sheet 1 Column A matches the data and sheet 2 Column A and where there is a match...
March 10th, 2010 04:51 PM
by RonaldoOneNil Go to last post
1 112
Prevent dragging cell contents by GS
I am trying to prevent dragging cell contents in a form. I cleared "Allow cell drag and drop check box" under Tools. But it works in only one computer. If I...
March 10th, 2010 04:41 PM
by GS Go to last post
0 115
Removing Hyphen(s) by Curtis[_6_]
I have numbers separated by Hyphen(s) and I am looking for an easy way to remove the Hyphen and just leave the text My data could be 1410-4031 or...
March 10th, 2010 04:37 PM
by Iriemon Go to last post
2 124
Locking a cell reference in a formula by odonnjk
I have a worksheet that has formulas built within 6 columns. I want to drag the formula in each column down 100 rows, but as I am calculating a date that...
March 10th, 2010 04:36 PM
by Iriemon Go to last post
1 154
Text Function by UlvaZell
Is there a text function counterpart to the SUMIF. A concatenate if? I have a table of data and based upon a numeric value in the data I would like to...
March 10th, 2010 04:29 PM
by UlvaZell Go to last post
0 94
Changing info from one worksheet to the next by FredDave
Hi all. I have linked my 55 sheets to one which is great. What i need to know now if possible. Each sheet has the same question over 11 columns Each row is...
March 10th, 2010 03:17 PM
by Don Guillett[_2_] Go to last post
1 94
how do I print edge to edge with absolutely NO margins by Girl4chuckie
I'm trying to create a form and want the print edge to go as far to the right as possible. How can I "get ur done"?
March 10th, 2010 03:16 PM
by Fred Smith[_4_] Go to last post
2 129
validation by selvaraj
hi, every one.. How to validate between two workbook..? Is there any option on this
March 10th, 2010 02:14 PM
by Eduardo Go to last post
2 89
Sum and Percentage Question... by Doofus
Hi, I'm after some help on what should be a fairly simple formula... I have 2 columns of data as follows: Column A - Product Name Column B - Quantity In...
March 10th, 2010 11:56 AM
by Doofus Go to last post
2 94
Cells with time constraint by Freshman
Dear experts, In my worksheet, column A is for default dates of each month and column B is for recording staff's reporting time. I want the cells in column B...
March 10th, 2010 09:34 AM
by Bob Phillips[_3_] Go to last post
4 130
Pivot Table Defaults by btexprs
In the pivot table field list, whenever I create a new pivot table and I am inserting fields into the value area, I generally get as default field setting...
March 10th, 2010 09:28 AM
by Roger Govier[_8_] Go to last post
1 109
Lookup changing data range in external workbook by RockCounter
I am using Excel 2007. I need to match an alpha numeric value from one workbook with the same alpha numeric in a different workbook and have the formula...
March 10th, 2010 09:16 AM
by Roger Govier[_8_] Go to last post
5 156
vlookup---using data outside the range specified in the formula by Art
I am sure I can guess the logical answer to this question, but... I have a sheet (Sheet 1) in Excel 2007 with a list of courses. The Course ID is in Column B...
March 10th, 2010 07:01 AM
by Max Go to last post
4 154
Post New Thread


Display Options
Showing threads 2241 to 2260 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 05:23 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.