Pages

Search

Excel Help Forum - Excel Charting & Pivots: 1 pivot out of 2 columns, but different ranges

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
1 pivot out of 2 columns, but different ranges
Dear all, I want to make a pivot with how often an ID was used during that week. For example ID C7214 in week 3 (3 times). This is the count function, I can manage this one. But now the hard part. I also want to know how often the unique ID is used that week.. For example ticket C7214 in...

Excel Help Forum - Excel Formulas & Functions: How to set formular sumif or countif?

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
How to set formular sumif or countif?
I'm beginner of Excel formula setting. Please kindly help me to set formula as the picture below Attachment 188424 (http://www.excelforum.com/attachment.php?attachmentid=188424) How to set formula sumif or countif or any formula for calculation total number of days in Sick and Errand leave...

Excel Help Forum - Excel Programming / VBA / Macros: Hyperlink produced when content of cell is placed in userform textbox

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Hyperlink produced when content of cell is placed in userform textbox
Hi I have spent a considerable amount of time researching this excellent resource and learnt a great deal since joining the forum, but I cant find the answer to this. I have a User form created with a number of fields. One of the fields needs to be a hyperlink that is created once the file...

Office IT Pro General Discussions Forum: Using AudioFrames in Power Point 2008 for Mac (PPT format)

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Using AudioFrames in Power Point 2008 for Mac (PPT format)

Hi,

I was redirected to this forum from this thread.

I use PP 2008 for Mac. Create a new presentation (/testfolder/test.ppt), adding audioframe with external file (/testfolder/subfolder/test.mp3), save presentation in PPT format. Result was successfully opened in PP 2011 for Mac, but does not works correctly in all Power Point versions for Windows (wrong path to the audio file).

The same presentation but created in PP 2007 for Win does not works in PP 2008 for Mac (but works fine in PP 2011 for Mac).

I think that PP 2008 for Mac generates files (with audio frames), which can be used only in PP for Mac. So PP 2008 for Mac can't work correctly with files which generated in Windows versions of PP.

I would like to receive comments on the issue.

Excel Help Forum - Excel Formulas & Functions: Keep copies of a sheet from linking to original sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Keep copies of a sheet from linking to original sheet
I would like to thank everyone for their help. I've learned a great deal from this forum while working on this project. I have two final problems PROBLEM 2 OF 2 The OCTOBER 2012 DATA ENTRY sheet is linked to the OCTOBER 2012 MONTHLY REPORT sheet. When I copy the sheets for the following...

Excel Help Forum - Excel Programming / VBA / Macros: VBA combinations

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA combinations
Can anyone help me with the vba to have excel take values I have given it (A1 to A250), Then give me 72 number unique combinations based off that data whose sum can't exceed 7750? I know it isn't using random number since that keeps duplicating.

Excel Help Forum - Excel General: Consolidate rows with duplicate ID number into one row

Feed2Mail notification - new post on Excel Help Forum - Excel General
Consolidate rows with duplicate ID number into one row
Hi everyone. I had a question that's been bugging me for a bit. If there are duplicates of an ID number in my database, how do I consolidate these into a single row and delete the duplicate? This is best illustrated in the example attached. What I have is on sheet one, what I need is on sheet 2....

Excel Help Forum - Excel Formulas & Functions: Max Date with Unique Name - Updated Request

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Max Date with Unique Name - Updated Request
"mike7952" and "alansidman" had provided an answer to my initial post regarding this but (good news/bad news) - they liked it so much, they said, "wow ... hey, then can you figure out how to do this ... ?" So I sat them down and narrowed down precisely (in their best world scenario) what they...

Excel Help Forum - Excel Programming / VBA / Macros: Archive anything older than 90 days and if actioned = Yes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Archive anything older than 90 days and if actioned = Yes
Hello, Was reading up on this and i'm thinking of merging but the i saw something about advanced filters and thought i'de turn to the boards! Attachment 188408 (http://www.excelforum.com/attachment.php?attachmentid=188408) What i was hoping was that automatically when "Response deadline...

Excel Help Forum - Excel General: creating a Pivot Table out of data in a cross-tab tableau

Feed2Mail notification - new post on Excel Help Forum - Excel General
creating a Pivot Table out of data in a cross-tab tableau
hi folks, i have a tableau of data in cross-tab format / layout. this layout is fixed because it is a data dump from another system. now, i need to generate a report on that data, for which i would like to utilise Pivot Tables. i have attached a sample excel workbook illustrating the as-is...

Excel Help Forum - Excel Charting & Pivots: Can I sort from columns in a PT other than just the first (left most)?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Can I sort from columns in a PT other than just the first (left most)?
Can I sort from columns in a PT other than just the first (left most)..and of course if so, how? Thanks

Excel Help Forum - Excel Formulas & Functions: Creating a List

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Creating a List
Hi excelforum members, I would consider myself an intermediate excel user, but trying to create a complicated spreadsheet. It is for my company's accounts. Can the pros here help me with creating a "LIST' in a column using excel formulas, or even VBA. The working file is attached. ...

Excel Help Forum - Excel Programming / VBA / Macros: Create a new column based on count of two other columns

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Create a new column based on count of two other columns
I am new to VBA scripting but what I want to create a new column that takes the values of two columns for example: Age Frequency 6 1 7 2 8 5 9 4 And create a third column that shows the values of age based on the frequency. They should look as follows:

Excel Help Forum - Excel Formulas & Functions: Conversion Formula

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Conversion Formula
I work with fuel tanks, or fuel farms. Big tanks of fuel that have to be hand gauged to determine how much fuel is in them. For example, for one tank at a gauge of 9-6 3/8 (reads nine feet, six inches and 3/8ths) the amount of fuel is 476156 gallons. We measure in 1/8ths. But we can measure as...

Excel Help Forum - Excel General: Populating a cell with text based on the rank

Feed2Mail notification - new post on Excel Help Forum - Excel General
Populating a cell with text based on the rank
Hello all- I am very new to using excel. I would like to populate cells underneath the raw data but on the same spreadsheet (as a metrics) for the information taken from the raw data and placed in a different order. For example, I would like to populate cell G9 with the information based on...

Office IT Pro General Discussions Forum: How to create different numbering style for figures and tables in Appendix in...

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
How to create different numbering style for figures and tables in Appendix in MS Word-2003?

Dear Friends and Office experts,

I am trying to use different numbering styles for Chapters and Appendices in my MS Word (2003) documents.

According to MS Word KB article, How to insert chapters and numbers...., I could add new list style for Appendices and also include those correctly in my Table of Contents.

I've figures, charts and tables in my Chapters and Appendices. I want to distinguish them by using Chapter numbers. Since, above MS KB article don't provide notes on figures/tables numbering, I applied the tips provided by How to number headings and figures in Appendixes in Microsoft Word.

Though, new label style appeared in the Figure/Table captions, I realised that whenever select a particular style in drop down box named "Chapter starts with style" to either Heading-1 or Heading-6 (for Appendix), numberings for all the figures/tables got flipped to this style - irrespective of whether it is in chapter or Appendix. I tried this in a document and can share this sample document to know more about my issue.

Is there something that I missing here when creating a new label for figure in Appendix?

How can we achieve this correctly? Please guide.

Thanks for your time and help.

Best Regards.

Excel Help Forum - Excel Programming / VBA / Macros: I can't get rid of Microsoft Visual Basic 400

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
I can't get rid of Microsoft Visual Basic 400
I have four worksheets in my workbook with essentially the same macro formulas. However for sheets three and four the shortcuts to run macros isn't working and I am getting a dialogue box that reads visual basic 400. Is there any reason outside of a coding error that this would come up as I...

Excel Help Forum - Excel Formulas & Functions: Display true false with IF formula

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Display true false with IF formula
I am trying to get a true/false value from an "IF" formula... I think I'm doing something wrong or missing something. What I have is - I need cells "C3" and "E3" to have certain values in them so that when they both have the correct value they return a value from "L3" and if either or both of...

Excel IT Pro Discussions Forum: Outlook crashes when copying pivot table charts from Excel

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Outlook crashes when copying pivot table charts from Excel

Hi all
Got an odd issue here with Outlook and Excel.  User is on Win 7 Pro SP1 and Office 2010 SP1. He is creating a pivot table from an Access database then he creates charts from the pivot table. After that, he'll starting copying those charts onto emails in Outlook. The issue occurs after 3-4 charts. Outlook and Excel will both hang and stop responding. He'll have to end both apps and repeat the steps again. It seems to be a bit random as it doesn't happen every single time. I tried both a repair and a re-install but that didn't help. I might try to set him up with a new profile.

Any suggestion?

Thanks
Stephan

Office IT Pro General Discussions Forum: MS Office 2007 - Proffesional Crashes

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
MS Office 2007 - Proffesional Crashes

MS Office Word is crashing when doing work, especially when doing a large amounts of copy and paste... ANY IDEAs !!

Wha I have done;

-RAM Upadated, SP3 installed, Repaired the MS Office and also Uninstall and Install But still Hapening to the  4 Machines.

- Done Full Windows Update.

-Deleted the Profile and created the new One

ANY HELP WILL BE APPRECIATED...

Excel Help Forum - Excel Charting & Pivots: is it possible to link together sliders from different pivot tables

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
is it possible to link together sliders from different pivot tables
I have three pivot tables from three different databases and a slider for each and all have an identical field grouping, U.S. cities, how can i link the three sliders so that when I select Florida in one slider the other two sliders also select Florida?

Excel Help Forum - Excel Formulas & Functions: Filter by various dates 30, 60, 90 days in the future

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Filter by various dates 30, 60, 90 days in the future
Hello, I have two columns in Excel. Column A = Names. Column B Dates. I would like to filter the data so I can only see upcoming dates within 30 days from the current date. The same thing for 60 days, and 90 days. By doing this I can then start contacting the clients that are within 30 days, 60...

Excel Help Forum - Excel Programming / VBA / Macros: Macro activated from multiple sheets causing mixed results

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Macro activated from multiple sheets causing mixed results
I have a macro which is being activated from multiple places and am trying to find a way to limit the way that it works, as it is causing unexpected results The macro in question is a date stamp- it activates when a checkbox is checked, and places a stamp in the next cell Code: ---------...

Excel Help Forum - Excel General: Create bell curve

Feed2Mail notification - new post on Excel Help Forum - Excel General
Create bell curve
Hi all I'm looking to create a seasonality curve in Excel. I've had a hunt through the website but can't find a corresponding thread. Essentially, I want to provide the start point and then have it spit out a bell curve over 52 weeks. I've attached a file showing what I'd like it to do, but need...

Microsoft Word - PROBLEM WITH MICROSOFT WORD 2007 AFTER RECOVERY

Microsoft Word - PROBLEM WITH MICROSOFT WORD 2007 AFTER RECOVERY


PROBLEM WITH MICROSOFT WORD 2007 AFTER RECOVERY

Posted: 21 Oct 2012 10:17 AM PDT

 i have problem with microsoft word 2007 few days ago i got a problem that my BOOTMGN got missing than i do RECOVERy n now the microsoft word is askng for product key and i have preinstalled windows in my laptop and it had sticker at the back of laptop  and when i entered the product key on it  it is saying that its INVALID.please help me i have urgent work to do
REPLY as soon as possible.

Office 2010 x64 File button has an overlapping color. How to fix it

Posted: 19 Oct 2012 07:40 PM PDT

Here the screenshot
http://i93.photobucket.com/albums/l64/cent_89x/Capture.jpg

INSERT WORD FILE

Posted: 18 Oct 2012 01:52 PM PDT

In word 2003 you could insert file.  I use a standard letterhead that I am trying to create several letters in one document.  It does not allow me to insert file with the ease of word 2003.  any one have any ideas?  thanks