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
permanent format pivot chart by amz
How can I apply a format permanently in a Pivot Chart? For example, adding values to my data graphs and not losing this format upon changing a field to...
June 4th, 2010 06:57 PM
by amz Go to last post
0 408
excel 2007 saving issues by CXH
I have a file created in excel 2003 that has thousands of VLookup functions. I recently installed excel 2007. When I open this file and try to save it, it...
June 4th, 2010 06:52 PM
by CXH Go to last post
0 303
vlookup formula errors by BG Mark
I am trying to enter a vlookup function into a cell to look at data in another work book, but after entering the initial lookup reference followed by the...
June 4th, 2010 06:48 PM
by BG Mark Go to last post
5 398
June 4th, 2010 05:28 PM
by Billns Go to last post
2 398
Using SUMIFs on a changing Pivot Table - Help! by James
Hello all I have a pivot table with revenue as the data, dates as the row fields and the column fields as countries. I am using a SUMIF formula to add...
June 4th, 2010 04:58 PM
by Roger Govier[_8_] Go to last post
2 1,256
Vlookup and Hlookup help by Nikki
I have a situation where I need to lookup Product A but then lookup Company A in a column that changes. vlookup("Product A",A1:T25,hlookup("Company...
June 4th, 2010 04:43 PM
by FloMM2 Go to last post
3 475
hightlight cells by sookie
i need to hightlight a cell when i have one birthday in my list
June 4th, 2010 03:56 PM
by Jackpot Go to last post
1 355
Delete rows with Symbols by Shairal
I receive files from China that always has foreign characters, which sometimes translate to symbols or ASCII characters in it. I would like to be able to...
June 4th, 2010 03:56 PM
by Shairal Go to last post
0 391
How to filter for Dates prior to Today by Tommy
If I have two columns of information or mutiple columns and column A is the date an event happened or will happen, how would write a formula to say if the...
June 4th, 2010 03:51 PM
by Jackpot Go to last post
1 409
Pick list width changes by itself...why? by Joe M.
I have some columns with the width 4. Sometimes the validation pick list is wide like 40 and sometimes it is only as wide as the column. I already know...
June 4th, 2010 02:58 PM
by Joe M. Go to last post
0 384
Formatting Dates from Text to Numbers by Tommy
I receive data daily with dates in the following formats: dd/mm/yyyy, d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs. numbers. ...
June 4th, 2010 02:53 PM
by Jackpot Go to last post
2 374
Excel Text Formula by Grizz
I'm combining text from four different cells into one cell, which works well. However, I would like the information from one of the four cells to be Bold...
June 4th, 2010 02:23 PM
by Grizz Go to last post
2 409
Sum a range based on a column by Metro
In column A I have subaccount numbers which may repeat. In columns B thru F, there are amounts that I need to sum if they meet the specific criteria of what...
June 4th, 2010 02:21 PM
by Metro Go to last post
2 417
List values based on different values selected by maniarasan
State : Type1 : Type2 : Type3 : Alaska Arizona Type1 Alaska1 Type1 Arizona1 Type2 Alaska2 Type2 Arizona2 Type3 Alaska3 Type3 Arizona3
June 4th, 2010 02:12 PM
by steve Go to last post
7 431
import color scheme from another excel (2007) by assenavant
hi, in former versions of excel, import color scheme from another excel: on the menu bartoolsoptionscolor tab in the "copy color from" box, click the...
June 4th, 2010 01:53 PM
by Gary Brown[_6_] Go to last post
1 662
Automatic update of data in excel charts by shantz
How can I set up the excel chart to update as new data is added on a daily basis?
June 4th, 2010 01:46 PM
by wal50 Go to last post
5 537
Excel calculation problem by scarmalt
I think something in Excel 2007 is trying to be too clever by half (or is it a bug?). Col A Formula Result Expected ...
June 4th, 2010 01:45 PM
by Gary Brown[_6_] Go to last post
2 709
Conditional Formating by Going Crazy with excel[_2_]
I have developed a rule for a column of data. =$ak$7:$ak$11 =$ak$4:$ak$6 I want to repeat this same rule to adjacent columns, AL thru AS. Then I want to repeat...
June 4th, 2010 01:42 PM
by Jackpot Go to last post
9 494
Can I display the current XLS filename in a toolbar? by [email protected]
I'm almost certain I have done this before because it makes it easy to paint the filename and copy it into another document for later use. This is a new PC I...
June 4th, 2010 12:59 PM
by Ms-Exl-Learner Go to last post
1 340
Automatic design for Excel by גיא
hi i am using a 3rd party system, that is exporting excel reports. i need to send these reports to customers, so they neeed to be designed in the same way. is...
June 4th, 2010 11:27 AM
by גיא Go to last post
0 313
Post New Thread

Display Options
Showing threads 81 to 100 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 12:04 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.