Pages

Search

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...
Subscribe to: Posts (Atom)