Results 1 to 7 of 7

Thread: Is there a way I can post the cell's with formlas here or do I have to submit a image?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2005
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Is there a way I can post the cell's with formlas here or do I have to submit a image?

    Hi everyone

    Can some please advise the best way to submit here, the cells and formulas that I am playing with at the moment.

    Many thanks Wayne

  2. #2
    Board Regular
    Join Date
    Jul 2013
    Location
    Cork, Ireland
    Posts
    618
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way I can post the cell's with formlas here or do I have to submit a image?

    click the link at the bottom of my sig, download that and you can copy cell values and formulas from excel and paste them into your posts on this site.

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    - List of VBA Books/Tutorials And Sites

    - Use the Board HTML Maker to post your data to the board



  3. #3
    Board Regular
    Join Date
    Jul 2013
    Location
    Cork, Ireland
    Posts
    618
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way I can post the cell's with formlas here or do I have to submit a image?

    If you use the "Board HTML Maker" you will be able to post your data like below:

    Excel 2007
    A B C D E F G H I J
    1 Words Range Duration Total Duration Cell Address of Answers
    2 2105 300-699 300 50 147350 $G$2
    3 1330 700-2099 700 60 79800 $G$3
    4 3618 2100-3199 2100 70 289440 $G$4
    5 5150 3200-4999 3200 80 463500 $G$5
    6 >5000 5000 90
    Sheet1

    Worksheet Formulas
    Cell Formula
    G2 =LOOKUP($A2,$D$2:$D$6,$E$2:$E$6)*A2
    G3 =LOOKUP($A3,$D$2:$D$6,$E$2:$E$6)*A3
    G4 =LOOKUP($A4,$D$2:$D$6,$E$2:$E$6)*A4
    G5 =LOOKUP($A5,$D$2:$D$6,$E$2:$E$6)*A5

    Array Formulas
    Cell Formula
    J2 {=CELL("address",INDEX($G$2:$G$5,MATCH(G2,$G$2:$G$5,0)))}
    J3 {=CELL("address",INDEX($G$2:$G$5,MATCH(G3,$G$2:$G$5,0)))}
    J4 {=CELL("address",INDEX($G$2:$G$5,MATCH(G4,$G$2:$G$5,0)))}
    J5 {=CELL("address",INDEX($G$2:$G$5,MATCH(G5,$G$2:$G$5,0)))}
    Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
    Note: Do not try and enter the {} manually yourself
    Last edited by DeusXv; Aug 26th, 2013 at 06:38 AM.

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    - List of VBA Books/Tutorials And Sites

    - Use the Board HTML Maker to post your data to the board



  4. #4
    Board Regular
    Join Date
    Jan 2005
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way I can post the cell's with formlas here or do I have to submit a image?

    That's what I am looking for thank you for your help and advice...

    Wayne

  5. #5
    Board Regular
    Join Date
    Jul 2013
    Location
    Cork, Ireland
    Posts
    618
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way I can post the cell's with formlas here or do I have to submit a image?

    No problem glad I could help

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    - List of VBA Books/Tutorials And Sites

    - Use the Board HTML Maker to post your data to the board



  6. #6
    Board Regular
    Join Date
    Jan 2005
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way I can post the cell's with formlas here or do I have to submit a image?

    DeusXv

    It does not seem to be opening as I thought and I am reading the readme.doc which says I need to add a standard .xla add-in file where do I find this file as it's not located in the online DIR

  7. #7
    Board Regular
    Join Date
    Jul 2013
    Location
    Cork, Ireland
    Posts
    618
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way I can post the cell's with formlas here or do I have to submit a image?

    Download the Zip file and in it there will be a word and an excel file, take the excel file and add it to your add-ins folder,

    Which for me at work is found in: C:\Documents and Settings\macfari\Application Data\Microsoft\AddIns

    Then open excel and click the excel button (Top left) > Then Excel options > Add-Ins > Go > Put a tick next to "HTML Maker"

    and then highlight the cells you want to link > Add-Ins Tab > Select the option you want

    Hope this helps

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    - List of VBA Books/Tutorials And Sites

    - Use the Board HTML Maker to post your data to the board



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •