Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.20 seconds.

  1. Replies
    2
    Views
    45

    Re: Worksheet name from list

    Hi, how about copying a "master" sheet that already has the layout, formulas etc rather than creating new sheets and back applying.

    Something like this, where, for example, the name of the...
  2. Replies
    14
    Views
    3,338

    Re: VLOOKUP multiple results (Custom Function)

    Hi, I think the limitation is the length of the string being returned (32767 chars) versus the number of cells being concatenated.
    ...
  3. Re: Hyperlink to cell in sheet based off of list of values

    Great, although I missed the match_type parameter of the match() function - for robustness you should include the addition in red below:
    ...
  4. Re: Hyperlink to cell in sheet based off of list of values

    If you really wanted to hard code the values and cell references in the formula, you could try like this.

    =HYPERLINK("#"&CHOOSE(MATCH(B2,{"apple","banana","pear"}),"D6","D57","D88"),"Click here..")
  5. Re: Hyperlink to cell in sheet based off of list of values

    Hi, I understand what you are trying to do - I'm asking if there is a way to logically determine that apple links to cell D6 and bananas links to D57?

    If there is no logic, I'd suggest you create...
  6. Replies
    1
    Views
    48

    Re: Help with formula from Pivot Table

    Hi, if, in the cell where you want the formula, you press = and then select the value in the pivot table that you want to retrieve does Excel create a GETPIVOTDATA() function for you?
  7. Re: Hyperlink to cell in sheet based off of list of values

    Hi, how do we know that "apple" links to cell D6 and "banana" links to cell D57 - what is the logic? Are those values in the cells you want to link to?
  8. Replies
    2
    Views
    153

    re: Locked by another user error

    Hi, more options to try here;

    https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/05/14/the-definitive-locked-file-post-updated-772014/

    Turning off the preview pane...
  9. Replies
    3
    Views
    111

    Re: Combine Index with indirect function

    Great, good to hear.

    Try using the "evaluate formula" option on the "formulas" tab to evaluate each step of the calculation.

    Keep in mind we are taking advantage of the fact that LOOKUP()...
  10. Replies
    3
    Views
    111

    Re: Combine Index with indirect function

    Hi, welcome to the forum!

    If I've understood correctly, then I don't think we need the lengths column and here is an option you can try:

    <b>Excel 2013/2016</b><table cellpadding="2.5px"...
  11. Replies
    4
    Views
    71

    Re: VBA instead of array formulae

    Hi, maybe:


    Range("F1:G1").Value = Evaluate("LINEST(B1:B3,A1:A3)")
  12. Re: How do I get VBA that sums cells needs to loop and fill 11 more rows?

    Hi, something like this maybe..



    Sub SumIntPWSalesSheets()


    ' Sum PW Sales in Active Internal Sales Sheets
  13. Replies
    2
    Views
    90

    Re: Minimum range of variable

    Hi, how about testing the variables value before performing the clear - something like:



    LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
    If LastRow > 100 Then
    Range("R" & LastRow & ":" &...
  14. Replies
    5
    Views
    76

    Re: Nested IFs with ISNUMBER

    Hi, pretty sure this covers all the scenarios mentioned.

    =IF(AND(COUNT(AV29,AV31,AV37)=3,OR(ISNUMBER(AV40),AV40="N/A")),MAX(AV29,AV31,AV37,AV40)+1,"HOLD")
  15. Replies
    4
    Views
    86

    Re: How to add AM/PM to a cell

    Hi, you could try:

    =TEXT(NOW(),"AM/PM")
  16. Replies
    12
    Views
    284

    Re: return value if cell contains specific text

    Hi, another option to try to adapt to your two sheet set-up.

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  17. Replies
    2
    Views
    105

    Re: TRANSPOSE the RESULT

    Hi, welcome to the forum,

    You could try like this:

    =SUMIFS(INDEX($K$5:$R$11,0,MATCH($B16,$K$4:$R$4,0)),$J$5:$J$11,C$15)
  18. Re: VBA Use declared variable as part of a formula

    Hi, maybe something like this.


    Cells(YROW, 34).Formula = "=average($B$" & YROW & ":$AF$" & YROW & ")"
  19. Re: How to convert number to date format after vlookup

    Hi, try like this
  20. Re: Formula for adding weight based on a greater than scenario

    Hi, the description is a little confusing - but maybe something like this:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  21. Re: Count A characters in a cell As a given number

    Hi, here is one option..:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  22. Re: Deleting/Replacing Part of a String With 3 Static Characters and 4 Variable Characters

    Hi,

    Here is an option you can try:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  23. Re: Count A characters in a cell As a given number

    Hi, another option you can try that makes use of a technique that Rick posted here:

    http://www.excelfox.com/forum/showthread.php/333-Get-Field-from-Delimited-Text-String

    Note. This is hard...
  24. Replies
    6
    Views
    168

    Re: Conditional Format -[H]:MM - Excel geniuses?

    Hi, you need to set the cell value to exactly as below (including the = sign and quote marks)

    ="-0:00"
  25. Replies
    6
    Views
    168

    Re: Conditional Format -[H]:MM - Excel geniuses?

    Hi, another option.

    > Conditional Formatting
    > New Rule
    > Format only cells that contain
    > Format only cells with: Cell Value | Equal to | ="-0:00"
    > Choose your format
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4