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
Change Cells Colour to another by Mattlynn via OfficeKB.com
Hi, I have a workbook, with some 170 tabs of pivot tables with macros set up to email each sheet out to each person etc. I coloured all my pivot headers in a...
May 15th, 2009 03:46 PM
by Mattlynn via OfficeKB.com Go to last post
2 223
VBA Wildcard Code by Tony
I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some...
May 15th, 2009 03:34 PM
by Tony Go to last post
8 210
Help to copy notes from 1 sheet to another by Mrbanner
I have 2 sheets in 1 excel file 500 rows need to make it so that if Sheet1:ColB is the same as Sheet2:Colb then the Notes in Columc:Sheet2 are displayed in...
May 15th, 2009 02:43 PM
by Don Guillett Go to last post
2 210
Copy and pasted numbers not acting like numbers by mklapp
Simply put, I have copied a column of numbers from one program into an excel spreadsheet. Most of the time this works just fine, but this time, in order to...
May 15th, 2009 02:28 PM
by Luke M Go to last post
1 196
How do I view Excel spreadsheets on 2 different monitors? by LMK[_2_]
How do I view Excel spreadsheets on 2 different monitors?
May 15th, 2009 01:16 PM
by Eduardo Go to last post
1 173
How do I prevent Excel trying to open a non-existing file at start by Jesperfect
At one time I have tried to make a data connection to an external ftp-server in Excel 2007. Unfortunately the file I tried to connect to doesn't seem to...
May 15th, 2009 01:11 PM
by Jesperfect Go to last post
0 175
Can I Change Displayed Data Through Data Validation? by TEK
I have 2 workbooks which we'll call A & B. Workbook A contains a dropdown box created through data validation which lists each month of the year. Workbook...
May 15th, 2009 12:25 PM
by TEK Go to last post
2 195
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range. by ADC76
Hello, I'm trying to modify an existing formula which only adds the sum range if another range has an "s" in it. Here's the formula:...
May 15th, 2009 11:47 AM
by طارق شكير Go to last post
5 197
How to use an array formula for tables by Dingerz
Hello, I dont really know how to explain what I want so I will try it in the best way i can. If Referenced Cell (G9) matches another cell in table (B3:F40)...
May 15th, 2009 10:46 AM
by Jacob Skaria Go to last post
4 217
Insert colums in Excel by Dragon522fly
Can someone tell me how to get more colums in a spreadsheet. The colums only go up to IV and I need more than that. I tried going to insert column, but...
May 15th, 2009 09:56 AM
by David Biddulph Go to last post
3 320
Calendar Control by donwb
Win XP, Excel 2003 Is there some simple code to set or change the color of a specific day in the Calendar Control, for example to signify that the specific day...
May 15th, 2009 08:31 AM
by donwb Go to last post
0 191
PAUSE CALCULATION ON FIND & REPLACE by FARAZ QURESHI
Although I have set the formula calculations to manual everytime I make a replacement in formulas via Find & Replace each and every cell starts to be...
May 15th, 2009 08:30 AM
by Jacob Skaria Go to last post
3 170
Check multiple cells for a match by Rusty
I am trying to create a formula that checks multiple specific cells and then returns a "YES" if it matches or a "NO" if it doesn't match any of the...
May 15th, 2009 06:57 AM
by Stefi Go to last post
4 175
How to return an array of values that are not zero/Null by apache007
Dear Excel experts I have a workbook with Sheet X and Z. On Sheet X, there are these coloums Class Number of Students Male Female AA ...
May 15th, 2009 06:00 AM
by JLatham Go to last post
9 414
Calculate Items Per Hour by Karthik
Hi, I've items Produced in Column A and the time taken to produce in Column B, I would like to know if there is a way to calculate number of items produced in...
May 15th, 2009 04:40 AM
by Jacob Skaria Go to last post
2 641
how to compare data and see variances by year by ayse
Hi, I am working on a spread sheet that has worksheets for months. Each worksheet (month) has 2007, 2008, 2009 data. I want to be able to see the varience...
May 15th, 2009 04:34 AM
by igorek Go to last post
1 230
how can i mulitply without having a figure yet? by sonia
Hi I want to have a few cells timed by two but haven't got the figures yet of what i'm times-ing. is there a way to format the cell to automatically times...
May 15th, 2009 04:18 AM
by Max Go to last post
1 231
Missing X error bar options by DS
I am working in Excel 2003 and have created a XY Scatter Plot (2-D) I need to add both x and y error bars. While the Y error bar tab is visible, the x error...
May 15th, 2009 04:02 AM
by Jon Peltier Go to last post
1 220
how do I remove line breaks from several cells? by JR
I have imported labels (formatted as first/last name, address, city/state/zip with line breaks between in each cell) and need utilize the "text to colums" in...
May 15th, 2009 03:20 AM
by Sheeloo Go to last post
3 211
Excel Table - Column not sorting on refresh by Wendifer
I built a table that is connected to an external database. When I refresh the table with new data, the new data is not sorted in the same order as when I...
May 15th, 2009 03:09 AM
by Wendifer Go to last post
0 170
Post New Thread


Display Options
Showing threads 20081 to 20100 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 09:05 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.