+ Post New Thread
Page 953 of 5615 FirstFirst ... 953 ...
Threads 47601 to 47650 of 280702

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,906
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. [SOLVED] Help to include ISBLANK along with IFERROR in my INDEX MATCH formula...

    Started by TomP1988‎, 05-03-2019 03:27 PM
    • 3
    • 440
    TMS
    05-03-2019, 05:10 PM Go to last post

  2. [SOLVED] Vlookup Help

    Started by sjgidman82‎, 05-03-2019 12:52 PM
    1 Attachment(s)
    • 4
    • 217
    José Augusto
    05-03-2019, 03:27 PM Go to last post

  3. Structuring IF Formula

    Started by NMDcorp‎, 05-03-2019 10:19 AM
    1 Attachment(s)
    • 7
    • 400
    TMS
    05-03-2019, 03:03 PM Go to last post

  4. Angry Compound Interest with regular withdrawals

    Started by k.tanton‎, 05-03-2019 02:19 PM
    • 2
    • 1,669
    k.tanton
    05-03-2019, 02:59 PM Go to last post

  5. Multisheet summary with Sumproduct, Sumifs, Indirect, and from to range

    Started by Chrisbou‎, 05-03-2019 02:15 PM
    1 Attachment(s)
    • 0
    • 290
    Chrisbou
    05-03-2019, 02:15 PM Go to last post

  6. Populate cells based in values from another cell

    Started by erick.delcastillo‎, 05-03-2019 11:30 AM
    2 Attachment(s)
    • 1
    • 232
    alansidman
    05-03-2019, 01:44 PM Go to last post

  7. [SOLVED] Dynamic Range From Another Sheet Excluding Blanks

    Started by fredfarmer‎, 05-03-2019 11:44 AM
    1 Attachment(s)
    • 2
    • 271
    fredfarmer
    05-03-2019, 01:21 PM Go to last post

  8. How to check a list for a value and then sum all amounts where value is the same

    Started by g1ose1‎, 05-02-2019 01:24 PM
    • 6
    • 285
    AliGW
    05-03-2019, 12:41 PM Go to last post

  9. [SOLVED] Sum Help - If Column L on Sheet1 says "X", find the sum of Column K on Sheet1.

    Started by kailaingrid‎, 05-02-2019 02:13 PM
    add, countifs, formula, sum 2 Attachment(s)
    • 12
    • 487
    Sam Capricci
    05-03-2019, 10:22 AM Go to last post

  10. [SOLVED] Adding criteria to formula

    Started by Spikyd‎, 05-03-2019 08:11 AM
    1 Attachment(s)
    • 3
    • 357
    canapone
    05-03-2019, 10:16 AM Go to last post

  11. Question [SOLVED] Help Required to Evaluate Advanced Formula

    Started by Treeman_JF‎, 05-03-2019 04:46 AM
    evaluate, formula 2 Attachment(s)
    • 7
    • 429
    Bo_Ry
    05-03-2019, 09:18 AM Go to last post

  12. Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

    Started by belladws‎, 05-03-2019 07:54 AM
    excel, ifstatement, pick list, sum and if
    • 3
    • 426
    belladws
    05-03-2019, 09:13 AM Go to last post

  13. Project Tasks - automatically fill cells based on another cells value and much more

    Started by RookieExcele‎, 05-03-2019 08:57 AM
    automatically, cells, fill 1 Attachment(s)
    • 0
    • 479
    RookieExcele
    05-03-2019, 08:57 AM Go to last post

  14. Converting Kg to UK Stone & pounds

    Started by GoHoSo‎, 05-03-2019 07:33 AM
    1 Attachment(s)
    • 7
    • 600
    Richard Buttrey
    05-03-2019, 08:56 AM Go to last post

  15. [SOLVED] Help with an array INDEX MATCH with multiple criteria!

    Started by TomP1988‎, 05-03-2019 08:22 AM
    1 Attachment(s)
    • 3
    • 228
    canapone
    05-03-2019, 08:50 AM Go to last post

  16. [SOLVED] vlookup but lookup value appears more than once, keep returning the next value on the list

    Started by TomP1988‎, 05-03-2019 03:48 AM
    2 Attachment(s)
    • 2
    • 1,262
    TomP1988
    05-03-2019, 08:13 AM Go to last post

  17. Talking [SOLVED] Automatically SUM the last 6 from range

    Started by Spikyd‎, 05-03-2019 06:34 AM
    • 5
    • 249
    Pete_UK
    05-03-2019, 06:58 AM Go to last post

  18. Master Sheet to divide into 2 separate tabs with formatting

    Started by SBennett212‎, 05-03-2019 06:25 AM
    • 1
    • 249
    Pete_UK
    05-03-2019, 06:55 AM Go to last post

  19. formula to add a hyperlink to a shared worksheet

    Started by JNEWMAN‎, 05-03-2019 06:28 AM
    • 0
    • 200
    JNEWMAN
    05-03-2019, 06:28 AM Go to last post

  20. [SOLVED] Filter highest diploma

    Started by beroberobero‎, 05-02-2019 08:50 AM
    3 Attachment(s)
    • 7
    • 552
    KOKOSEK
    05-03-2019, 06:27 AM Go to last post

  21. SUMIFS for date range (read from a cell) and text criteria not working

    Started by meny_‎, 05-02-2019 08:53 AM
    1 Attachment(s)
    • 7
    • 409
    CARACALLA
    05-03-2019, 06:23 AM Go to last post

  22. Pulling highest value using INDEX MATCH with multiple criteria.

    Started by rachelsteele‎, 04-29-2019 07:06 PM
    6 Attachment(s)
    • 8
    • 387
    XLent
    05-03-2019, 04:08 AM Go to last post

  23. [SOLVED] Help with an IF formula to return incremental line numbers..

    Started by TomP1988‎, 05-02-2019 01:12 PM
    1 Attachment(s)
    • 4
    • 274
    TomP1988
    05-03-2019, 03:17 AM Go to last post

  24. [SOLVED] Change Cell Text Value based on another cells

    Started by calua02‎, 05-02-2019 03:33 PM
    #change#cell#value
    • 2
    • 348
    calua02
    05-03-2019, 02:41 AM Go to last post

  25. Automatically updating links

    Started by melissaoi‎, 05-02-2019 12:18 PM
    • 1
    • 261
    Pepe Le Mokko
    05-03-2019, 02:29 AM Go to last post

  26. [SOLVED] Question on COUNT function

    Started by HaoleBoy‎, 03-05-2019 11:08 PM
    3 Attachment(s)
    • 10
    • 536
    HaoleBoy
    05-03-2019, 01:52 AM Go to last post

  27. Counting the number of consecutive blank cells in a row

    Started by hassan13939‎, 05-01-2019 10:18 AM
    1 Attachment(s)
    • 6
    • 1,390
    FlameRetired
    05-03-2019, 01:49 AM Go to last post

  28. [SOLVED] Simple "lock the cell reference" question

    Started by LewisBosworth‎, 05-02-2019 09:00 PM
    • 2
    • 270
    LewisBosworth
    05-02-2019, 10:58 PM Go to last post

  29. How to remove text after numberic number

    Started by ziyan89‎, 05-02-2019 03:57 AM
    • 4
    • 257
    bebo021999
    05-02-2019, 09:29 PM Go to last post

  30. [SOLVED] Transpose Col A (Account) and Col B (Items) to where a Row has 1 Account and ALL the items

    Started by Tazzin‎, 05-02-2019 07:18 PM
    • 3
    • 227
    FlameRetired
    05-02-2019, 09:23 PM Go to last post

  31. move specific text from one cell to another

    Started by npollaro‎, 04-30-2019 04:44 PM
    4 Attachment(s)
    • 11
    • 1,211
    npollaro
    05-02-2019, 06:39 PM Go to last post

  32. [SOLVED] Need to remove non-matching text from a delimited string

    Started by bramsey‎, 05-02-2019 01:19 PM
    • 3
    • 259
    Richard Buttrey
    05-02-2019, 05:28 PM Go to last post

  33. Trouble with nested If's

    Started by KimMorgan‎, 05-02-2019 02:20 PM
    • 2
    • 307
    KimMorgan
    05-02-2019, 05:16 PM Go to last post

  34. [SOLVED] Formula to have a number in a column go to zero, if adjacent cell goes to zero

    Started by BryanHCR‎, 05-01-2019 06:38 PM
    2 Attachment(s)
    • 8
    • 348
    AliGW
    05-02-2019, 04:45 PM Go to last post

  35. Vlookup - keeping the leading zeros in a cell to allow the vlookup to work

    Started by UFBEE1970‎, 05-01-2019 01:15 PM
    1 Attachment(s)
    • 10
    • 1,819
    protonLeah
    05-02-2019, 04:41 PM Go to last post

  36. Moved: When saving worksheet as a new workbook I cannot reactivate original workbook

    Started by pongmeister‎, 05-02-2019 04:35 PM
    •  
    •  

  37. [SOLVED] Rearrange display in new column

    Started by Rahul15292000‎, 05-01-2019 03:14 PM
    1 Attachment(s)
    • 8
    • 280
    Fluff13
    05-02-2019, 03:53 PM Go to last post

  38. [SOLVED] If Date Statement

    Started by hkbhansali‎, 05-02-2019 03:05 PM
    1 Attachment(s)
    • 5
    • 306
    63falcondude
    05-02-2019, 03:38 PM Go to last post

  39. Looking up data when referenced string is used in multiple cells in the same column

    Started by eqprog‎, 04-30-2019 08:27 PM
    3 Attachment(s)
    • 1
    • 222
    dflak
    05-02-2019, 02:52 PM Go to last post

  40. MOD AGGREGATE to find first non blank cell

    Started by ELFIJKA‎, 05-02-2019 11:36 AM
    2 Attachment(s)
    • 3
    • 268
    canapone
    05-02-2019, 02:21 PM Go to last post

  41. [SOLVED] Match Function for Split Numbers

    Started by soleimani1967‎, 05-02-2019 01:55 PM
    1 Attachment(s)
    • 2
    • 264
    63falcondude
    05-02-2019, 02:05 PM Go to last post

  42. [SOLVED] Help with lookup formula that returns whole columns

    Started by Weebs21‎, 05-02-2019 11:17 AM
    function, lookup 1 Attachment(s)
    • 10
    • 482
    CARACALLA
    05-02-2019, 01:57 PM Go to last post

  43. [SOLVED] Help with lookup or Index formula excluding certain data.

    Started by ODP‎, 05-02-2019 10:34 AM
    • 6
    • 249
    Sam Capricci
    05-02-2019, 01:57 PM Go to last post

  44. Cashflow Modeling: Looking up multiple values over a non-linear timeline

    Started by nkoglin‎, 05-02-2019 12:28 PM
    • 1
    • 403
    shg
    05-02-2019, 01:10 PM Go to last post

  45. [SOLVED] Vlookup multiple criteria

    Started by ricky-84‎, 05-02-2019 10:02 AM
    1 Attachment(s)
    • 6
    • 300
    63falcondude
    05-02-2019, 01:05 PM Go to last post

  46. Displaying hyperlink text in the reference cell

    Started by mattisk‎, 05-02-2019 06:42 AM
    • 1
    • 240
    XLent
    05-02-2019, 12:36 PM Go to last post

  47. [SOLVED] Value based on last letter of entry in cell

    Started by rude314‎, 05-02-2019 11:03 AM
    • 1
    • 306
    6StringJazzer
    05-02-2019, 11:13 AM Go to last post

  48. [SOLVED] Using drop down menu (yes or no) to determine calculation in another cell. PLEASE HELP :(

    Started by cbarton123uk‎, 04-29-2019 11:55 AM
    3 Attachment(s)
    • 7
    • 459
    Greg M
    05-02-2019, 11:13 AM Go to last post

  49. Pleas help? How do i do this?

    Started by ryan14690‎, 05-02-2019 10:11 AM
    2 Attachment(s)
    • 4
    • 226
    Pepe Le Mokko
    05-02-2019, 10:34 AM Go to last post

  50. [SOLVED] Power Query error when importing files from a folder

    Started by Howardc1001‎, 05-01-2019 12:14 AM
    7 Attachment(s)
    • 10
    • 3,068
    Howardc1001
    05-02-2019, 10:28 AM Go to last post
+ Post New Thread
Page 953 of 5615 FirstFirst ... 953 ...

Forum Information and Options

Users Browsing this Forum

There are currently 77 users browsing this forum. (8 members & 69 guests)

  1. Colin Legg,
  2. colin wiz,
  3. Extrudius,
  4. Phuocam,
  5. RaulSerg,
  6. samyraj,
  7. windknife

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1