Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    6
    Views
    54

    Re: Tiered bonus structure

    This link may also help.
    http://www.mcgimpsey.com/excel/variablerate.html
  2. Replies
    5
    Views
    154

    Re: Unable to break external link

    See if this reference on finding external links helps.
    https://support.office.com/en-us/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1
  3. Replies
    10
    Views
    193

    Re: Index, Match when values the same

    You're welcome. Glad that worked for you. Thanks for the feedback.
  4. Replies
    10
    Views
    193

    Re: Index, Match when values the same

    Maybe something like this?
    You will need Excel ver. 2010 or later with the AGGREGATE function.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  5. Replies
    1
    Views
    70

    Re: I think I need a V Lookup?????

    See if this does what you want.
    You will Excel 2010 or later to use the AGGREGATE function. If you have an earlier ver. of Excel let me know and we can use a different formula.
    Change ranges to...
  6. Replies
    2
    Views
    85

    Re: Count only Unique criteria

    Maybe something like this.
    This is an array formula and must be entered with CTRL-SHIFT-ENTER.
    Drag formula down as needed.

    <table border="0" cellspacing="0" cellpadding="0"...
  7. Replies
    1
    Views
    78

    Re: Vlookup,Index,Match,SumIF

    I see a couple of potential problems with your formula.
    1- I think you have your INDEX and MATCH range reversed.
    2- The value 11 in cell F4 of the DashBoard is numeric and the column SI-No is...
  8. Re: Match multiple values from one column with single value from other column

    Another option if you have a later ver. of Excel with the TEXTJOIN function.
    This is an array formula that must be entered with CTRL-SHIFT-ENTER.

    <table border="0" cellspacing="0" cellpadding="0"...
  9. Replies
    2
    Views
    80

    Re: how to do this sumproduct calculation?

    Try:

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col...
  10. Replies
    3
    Views
    112

    Re: Return value adjacent based on match

    You're welcome. Thanks for the feedback.
  11. Replies
    16
    Views
    512

    Re: How to calculate compound interest?

    Using the FV function in Excel

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt;...
  12. Replies
    3
    Views
    112

    Re: Return value adjacent based on match

    Assuming no dup;icates in column C try VLOOKUP.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; ...
  13. Replies
    4
    Views
    257

    Re: list missing people from a list

    If you have a later ver. of Excel with the TEXTJOIN function, you could use something like this.

    This is an array function and must be entered with CTRL-SHIFT-ENTER.

    <table border="0"...
  14. Replies
    6
    Views
    188

    Re: Standard Deviation Function

    I may not understand your question, but in the example below I use a range from B2:B9 in cell D4 and then in cell D5 I used the whole column B:B without an error.
    Make sure you enter the formula...
  15. Replies
    6
    Views
    188

    Re: Standard Deviation Function

    Try something like this array formula.
    Formula must be entered with CTRL-SHIFT-ENTER.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  16. Re: Typing Statistical Symbols like X̅ in Excel

    See if this link helps.
    https://answers.microsoft.com/en-us/msoffice/forum/all/x-bar-symbol-in-office-365-for-mac/9268f49f-ed9c-4ba1-a7ed-8e6969a70331
  17. Replies
    3
    Views
    134

    Re: What formula should I use?

    You're welcome. Thanks for the feedback and welcome to the forum.
  18. Replies
    3
    Views
    134

    Re: What formula should I use?

    Maybe something like this.

    Copy formulas down as needed.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
  19. Re: VLOOKUP Multiple value return in Single Cell with Repitiion

    If you have Excel 2016 or later with the TEXTJOIN function then here is another option.
    This is an array formula and must be entered with CTRL-SHIFT-ENTER.

    <b>Sheet1</b><br /><br /><table...
  20. Replies
    7
    Views
    179

    Re: Copy nearest index sorted by date

    Maybe something like this.
    This formula will return the first value if there are duplicates. It would return 1 for 22.09.2019. Does that work for you are do you need to return both 1 & 2?

    This is...
  21. Replies
    3
    Views
    123

    Re: SUM and COUNT Issues

    Try:

    COUNTIFS(G3692:G4426,"Fixed",M3692:M4426,">=25000",M3692:M4426,"<=100000")


    SUMIFS(G3692:G4426,"Fixed",M3692:M4426,">=25000",M3692:M4426,"<=100000")
  22. Re: Compare 2 columns in one worksheet to another

    Maybe something like this:

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; ">...
  23. Replies
    4
    Views
    149

    Re: IF AND function with a DATE calculation

    You're welcome. Thanks for the feedback.
  24. Replies
    4
    Views
    121

    Re: Future value formula

    Your formula is calculating simple interest, but the FV function as you are using it is calculating compound interest.

    To use FV for simple interest. Rate = 0 NPER = 26 (days in this case) PMT =...
  25. Replies
    4
    Views
    100

    Re: Multiple IF statements with Variables

    Another way with a list would be to use SUMPRODUCT.
    You could put the list on another Worksheet. The advantage of a list is it would be easy to update pricing. You could make B12 and C12 drop down...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4