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
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 726
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 741
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 671
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 577
Excel Spreadsheets formulas don't update by GGirl
Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum.
April 21st, 2010 04:39 AM
by L. Howard Kittle Go to last post
1 237
Excel Spreadsheets formulas don't update by GGirl
Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum.
April 21st, 2010 06:49 AM
by grizzly6969 Go to last post
1 229
Formula to find the last number of a column (lower cell) by yiannis5231
I have a column with numbers. I want a formula that it will be finding the lower cell that has data. For example in column A i have numbers in cells A1, A2...
April 21st, 2010 07:10 AM
by Jacob Skaria Go to last post
1 241
Calculating Sum Series by deluth
Greetings, I can't seem to find a formula to do series of sums. I would like to calculate the following series: For n = 0 to n=B1/B3 sum:...
April 21st, 2010 08:03 AM
by Joe User[_2_] Go to last post
1 229
Visible Shapes in a frame? by Pas
Every time I exit design mode, the shapes in a frame disappear behind the frame. Is there a way to stop that from happening?
April 21st, 2010 08:13 AM
by Pas Go to last post
4 186
Search and Replace, or Add New Row by GEdwards
I am using Excel 2003. Worksheet1 contains columns (A) Invoice (B) Name (C) Address (D) P.O.# ... and others. I need to perform a search of column A...
April 21st, 2010 08:20 AM
by Jacob Skaria Go to last post
1 200
Unusual Date Format by Grey Old Man[_2_]
I am writing an Excel 2002 template. I am importing two columns of dates (date from and date to) from an external source. The date format is 'cyymmdd' so...
April 21st, 2010 08:42 AM
by Grey Old Man[_2_] Go to last post
0 190
Unusual Date Format by Grey Old Man[_2_]
I am writing an Excel 2002 template. Two columns of dates (date from and date to) are both imported from an external source. The date format is 'cyymmdd' so...
April 21st, 2010 08:52 AM
by David Biddulph Go to last post
1 211
How do I insert a file into Excel 2007 spreadsheet ? by Chris J.
The old Excel command Insert-Object does not exist anymore, instead only these Insert {Tables | Illustrations | Charts | Links | Text } I want to insert a...
April 21st, 2010 09:03 AM
by Chris J. Go to last post
0 176
Simple Yes/No drop down box by Debi
Hi, I am looking to create a simple drop down box which has yes or no as the options. For the life of me i can't remember how to do it. Thanks
April 21st, 2010 10:01 AM
by Jacob Skaria Go to last post
2 230
Seperate data by JJ
I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want...
April 21st, 2010 10:01 AM
by JJ Go to last post
5 263
hide columns before printing by Jean-Paul De Winter
Hi, Before actually printing my sheet I want to hide column A and B. Can I do this automatically without having to hide them manually? Thanks -- Mvg.
April 21st, 2010 11:22 AM
by Jarek Kujawa[_2_] Go to last post
6 316
using Sumproduct with named ranges by Jenny S
Hi, Hope someone can help. I have named ranges in tab 1, Column E=B is for Branch, Column F=G is for Game, & Column G=P is for points. Named ranges are...
April 21st, 2010 12:16 PM
by Jacob Skaria Go to last post
1 234
Help with setting a "not found" statement by Pierre
Hi. I have a form that looks for a asset on a s/sheet list. What I need is a statement that checks to see if the asset is on the list and if not, creates a...
April 21st, 2010 12:55 PM
by Dave Peterson Go to last post
3 233
Single Filter to change all Pivot Tables in a Workbook by Kathy L.[_2_]
Hello experts, I've reviewed PT0021 Change All Page Fields sample Excel file (for 2007) on http://www.contextures.com/excelfiles.html#Pivot and am still...
April 21st, 2010 12:58 PM
by Roger Govier[_8_] Go to last post
8 231
find and copy it.. by reza
hi all... hoping u can help me for saving my time. i have a master data in sheet 1 with more than 1000 rows. and now in sheet 2 i want to copy data from...
April 21st, 2010 01:00 PM
by Dave Peterson Go to last post
2 253
Post New Thread


Display Options
Showing threads 137761 to 137780 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 04:34 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.