Search:

Type: Posts; User: Jak7217; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    168

    Preceding Zeroes

    Hi All:

    I have a weekly file that spits out numbers stored as text. It breaks out the hundreds and thousands amounts in different cells.

    In thousands cell:205 In hundreds cell:87 ...
  2. Replies
    1
    Views
    143

    Indirect Function Causing #Ref! Error

    The following formula pulls data from the specified workbook, even when the workbook isn't open:
    ='C:\Users\Username\Documents\Report\[Test Workbook - 6-11-2019.xlsx]Sheet1'!A1

    I added an...
  3. Re: Reference another workbook with entire filepath

    It does, thanks!
  4. Re: Reference another workbook with entire filepath

    Both of these work - thank you for this.

    Follow-up: When I use these formulas, the filepath disappears, it only keeps [Test Workbook.xlsx]Sheet1'!A1 ... The problem that I am running into is that...
  5. Re: Select the greatest value in the list and return a cell next to it

    Can you flip the info in column S and T? If so...

    In cell S33 =max(T19:T30)

    In cell T33 =vlookup(S33,S19:T30,2,false)
  6. Reference another workbook with entire filepath

    Hi All:

    I am trying to write a formula to reference cell A1 in this workbook. I am using the entire filepath in hopes of being able to access the data without the other workbook being open.
    ...
  7. Re: Replacing part of a formula with the contents of another cell

    Hi Joe:

    Good observation - it only works when the excel file is open. I am tinkering around with putting the entire filepath in, but can't seem to get it to stick.
    ...
  8. Re: Replacing part of a formula with the contents of another cell

    Thank you! This worked perfectly.
    I ran into another problem after implementing this. I copiedand pasted the formula over to the next day and am getting a #Ref ! error. Ithink the issue is that...
  9. Replacing part of a formula with the contents of another cell

    Hey All:

    I currently have a formula as follows:
    ='[Filename - 6-11-2019.XLSX]Page1_1'!$B$4
    This is pulling a piece of data from another excel workbook.
    What I would like it to do is remove the...
  10. Re: Pasting Excel Data Into Multiple Cells of a Webpage

    Thank you, John. This is really helpful!
  11. Pasting Excel Data Into Multiple Cells of a Webpage

    Hi All!

    Thanks in advance for the help!

    On a daily basis, I am taking hundreds of cells of data fromexcel and typing them into a webpage. With the webpage, each field of inputis separated by a...
  12. Re: Using the text from another cell in a formula

    This solved it! Thank you!
  13. Using the text from another cell in a formula

    Hey all:

    First post here, thanks in advance.

    I want to pull text from another cell and add it to myformula. For example, I have a formula below where I am referencing a differenttab of the...
Results 1 to 13 of 13