+ Post New Thread
Page 1002 of 5614 FirstFirst ... 1002 ...
Threads 50051 to 50100 of 280663

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,895
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. [SOLVED] RANK/SUMPRODUCT formula not sorting properly...

    Started by KomicJ‎, 02-18-2019 11:25 AM
    1 Attachment(s)
    • 11
    • 708
    AliGW
    02-19-2019, 05:34 AM Go to last post

  2. Accessing another workbook data while closed.

    Started by vancey‎, 02-19-2019 05:32 AM
    • 0
    • 182
    vancey
    02-19-2019, 05:32 AM Go to last post

  3. [SOLVED] FIND first 9 characters?

    Started by Hannah12‎, 02-07-2019 06:20 AM
    1 Attachment(s)
    • 5
    • 422
    FDibbins
    02-19-2019, 04:28 AM Go to last post

  4. Exclamation [SOLVED] Calculate rates in periods

    Started by zrs‎, 02-18-2019 06:39 AM
    excel, formula 4 Attachment(s)
    • 6
    • 414
    zrs
    02-19-2019, 03:53 AM Go to last post

  5. [SOLVED] Excel Conditional Formatting on Multiple Sheets

    Started by TheTr00per‎, 02-15-2019 03:01 PM
    3 Attachment(s)
    • 15
    • 8,503
    kvsrinivasamurthy
    02-19-2019, 02:09 AM Go to last post

  6. [SOLVED] Formula to list floors based on data input

    Started by chullan88‎, 02-18-2019 02:44 AM
    2 Attachment(s)
    • 8
    • 257
    chullan88
    02-19-2019, 01:35 AM Go to last post

  7. [SOLVED] Negative days between dates formula

    Started by petsean007‎, 02-19-2019 12:54 AM
    1 Attachment(s)
    • 3
    • 449
    petsean007
    02-19-2019, 01:14 AM Go to last post

  8. Conditional Moving Average Based on Start Date

    Started by Brandoeats‎, 02-05-2019 11:49 AM
    2 Attachment(s)
    • 4
    • 329
    JeteMc
    02-19-2019, 12:09 AM Go to last post

  9. MIN/MAX function plus IF Statements

    Started by Chambew‎, 02-06-2019 07:08 AM
    2 Attachment(s)
    • 5
    • 325
    JeteMc
    02-18-2019, 10:54 PM Go to last post

  10. Post [SOLVED] Dropdown list with formula for months of the current year till date

    Started by mohanys‎, 02-14-2019 08:28 AM
    1 Attachment(s)
    • 4
    • 5,568
    mohanys
    02-18-2019, 10:37 PM Go to last post

  11. Populate table based on cell value in another worksheet

    Started by danganm123‎, 02-17-2019 10:39 PM
    3 Attachment(s)
    • 6
    • 734
    danganm123
    02-18-2019, 10:20 PM Go to last post

  12. Lookup across multiple columns

    Started by Yoepy‎, 02-18-2019 07:15 PM
    3 Attachment(s)
    • 7
    • 462
    Greg M
    02-18-2019, 10:17 PM Go to last post

  13. Creating Dynamic Links

    Started by jpl69‎, 02-18-2019 04:25 PM
    1 Attachment(s)
    • 2
    • 270
    jpl69
    02-18-2019, 09:38 PM Go to last post

  14. [SOLVED] Transpose Formulas From Range 1 to Range 2 ???

    Started by Logit‎, 02-18-2019 06:17 PM
    • 3
    • 321
    Logit
    02-18-2019, 07:57 PM Go to last post

  15. Tracker - Looking for formula's to speed up/avoid manual input

    Started by Gladoo‎, 11-14-2018 04:27 PM
    2 Attachment(s)
    • 1
    • 365
    TMS
    02-18-2019, 06:46 PM Go to last post

  16. [SOLVED] Sum Dynamic Range Based on Matching Value in Another Cell

    Started by lsteinbach‎, 02-18-2019 03:21 PM
    dynamic range, index match, sum, vlookup
    • 4
    • 528
    TMS
    02-18-2019, 06:32 PM Go to last post

  17. Question Automatically Adjusting Values Based on Master Value

    Started by sunshinebee‎, 02-18-2019 05:55 PM
    1 Attachment(s)
    • 7
    • 294
    AliGW
    02-18-2019, 06:26 PM Go to last post

  18. Changing Weekly data into monthly

    Started by Jimbo123456‎, 02-18-2019 05:22 PM
    1 Attachment(s)
    • 2
    • 457
    MarvinP
    02-18-2019, 06:00 PM Go to last post

  19. Moved: Extracting data on a specific date

    Started by lauderdale‎, 02-18-2019 06:43 AM
    •  
    •  

  20. Question Conditional formatting - based on multiple conditions which can change

    Started by SForest‎, 02-18-2019 01:16 PM
    2 Attachment(s)
    • 4
    • 282
    SForest
    02-18-2019, 05:40 PM Go to last post

  21. Summary & Data Help with Update

    Started by ruthschoenb‎, 02-18-2019 03:59 PM
    • 3
    • 253
    AliGW
    02-18-2019, 04:52 PM Go to last post

  22. [SOLVED] Sum increases as contributors are added

    Started by FivestarMac‎, 02-18-2019 04:30 PM
    1 Attachment(s)
    • 1
    • 214
    modytrane
    02-18-2019, 04:37 PM Go to last post

  23. [SOLVED] conditional formatting using formulas.

    Started by pmw19800‎, 02-18-2019 04:07 AM
    1 Attachment(s)
    • 3
    • 361
    AliGW
    02-18-2019, 04:13 PM Go to last post

  24. [SOLVED] How to calculate majority based on condition

    Started by masond3‎, 02-18-2019 02:27 PM
    1 Attachment(s)
    • 2
    • 710
    masond3
    02-18-2019, 03:26 PM Go to last post

  25. Calculating a persons "Sign on" time based on text in the next column

    Started by Beh162‎, 02-14-2019 09:17 PM
    4 Attachment(s)
    • 7
    • 363
    Beh162
    02-18-2019, 02:48 PM Go to last post

  26. Post Removing First Name and Leaving First Initial

    Started by JFKatz‎, 02-18-2019 02:33 PM
    • 1
    • 225
    JLGWhiz
    02-18-2019, 02:46 PM Go to last post

  27. [SOLVED] Finding blank cells in an array formula not working. Why?

    Started by RICK JAMES‎, 02-18-2019 01:00 PM
    1 Attachment(s)
    • 7
    • 591
    AliGW
    02-18-2019, 02:21 PM Go to last post

  28. Question [SOLVED] Multiple Drop Down menu starts from Top

    Started by toci‎, 02-18-2019 12:23 PM
    3 Attachment(s)
    • 3
    • 235
    toci
    02-18-2019, 01:44 PM Go to last post

  29. Post Combining IF AND and OR which includes an 'iserror' Function...

    Started by Ourkid123uk‎, 02-18-2019 12:48 PM
    • 4
    • 317
    Ourkid123uk
    02-18-2019, 01:39 PM Go to last post

  30. [SOLVED] To much iIF's?

    Started by Frigide‎, 02-18-2019 10:44 AM
    • 8
    • 357
    AliGW
    02-18-2019, 12:19 PM Go to last post

  31. [SOLVED] Conditional Formatting - Multiple Conditions

    Started by jharvey87‎, 02-18-2019 11:39 AM
    2 Attachment(s)
    • 1
    • 261
    Bo_Ry
    02-18-2019, 12:11 PM Go to last post

  32. [SOLVED] How to update and Extract Daily data to Weekly

    Started by Ravindran Raman‎, 02-05-2019 09:35 AM
    2 Attachment(s)
    • 1
    • 370
    JeteMc
    02-18-2019, 11:52 AM Go to last post

  33. Question Modify TEXTJOIN formula to avoid duplicate returns

    Started by Thintin‎, 02-18-2019 09:18 AM
    excel 365, textjoin function 1 Attachment(s)
    • 3
    • 975
    XLent
    02-18-2019, 11:06 AM Go to last post

  34. COUNTIFS SUMIFS with a criteria that is a RANGE

    Started by RoundaboutCJP‎, 02-18-2019 06:05 AM
    • 4
    • 428
    rorya
    02-18-2019, 10:32 AM Go to last post

  35. [SOLVED] Collect non empty cell before know value

    Started by jomaor1‎, 02-18-2019 08:44 AM
    array, index, inverted array, non empty cell 1 Attachment(s)
    • 7
    • 467
    KOKOSEK
    02-18-2019, 09:49 AM Go to last post

  36. [SOLVED] average formula calculation.

    Started by juco‎, 02-18-2019 05:28 AM
    1 Attachment(s)
    • 4
    • 268
    AliGW
    02-18-2019, 09:46 AM Go to last post

  37. why doesn't excel want me to combine a range into one cell?

    Started by glupaka‎, 02-16-2019 06:08 AM
    array, cell, formula, range 2 Attachment(s)
    • 5
    • 566
    AliGW
    02-18-2019, 09:35 AM Go to last post

  38. how to return multiple values from a range with nth value?

    Started by glupaka‎, 02-18-2019 09:10 AM
    index, match, nth, vlookup
    • 2
    • 343
    XLent
    02-18-2019, 09:34 AM Go to last post

  39. Count value in a row IF the adjacent row equals a certain value

    Started by JerryA‎, 02-04-2019 03:57 PM
    2 Attachment(s)
    • 5
    • 319
    JeteMc
    02-18-2019, 08:57 AM Go to last post

  40. [SOLVED] Error using Address + Indirect with Array

    Started by jomaor1‎, 02-18-2019 07:50 AM
    address, address array, array, error, indirect address
    • 2
    • 980
    jomaor1
    02-18-2019, 08:23 AM Go to last post

  41. Search and Return Phrase From Cell

    Started by timma‎, 02-17-2019 12:55 PM
    3 Attachment(s)
    • 9
    • 421
    Ghozi Alkatiri
    02-18-2019, 06:58 AM Go to last post

  42. [SOLVED] Conditional formatting

    Started by juco‎, 02-17-2019 06:28 PM
    • 3
    • 271
    Pete_UK
    02-18-2019, 05:50 AM Go to last post

  43. [SOLVED] to calculate minimum value from 3 different transposed arrays row by row

    Started by Vivek2705‎, 02-16-2019 07:03 AM
    1 Attachment(s)
    • 7
    • 832
    Vivek2705
    02-18-2019, 05:15 AM Go to last post

  44. [SOLVED] Checking a date to knowing the schedule

    Started by azbi‎, 02-18-2019 03:44 AM
    1 Attachment(s)
    • 8
    • 233
    AliGW
    02-18-2019, 05:15 AM Go to last post

  45. How to Automatically Match Data side by side in Excel.

    Started by cliffe007‎, 02-17-2019 08:41 AM
    1 Attachment(s)
    • 7
    • 546
    AliGW
    02-18-2019, 04:39 AM Go to last post

  46. [SOLVED] Elegant Solution to summarise progress information

    Started by chullan88‎, 02-17-2019 08:44 AM
    3 Attachment(s)
    • 5
    • 334
    chullan88
    02-18-2019, 03:24 AM Go to last post

  47. Designate Which Sheet to Call Upon by Cell

    Started by summoner49‎, 02-17-2019 11:41 PM
    • 1
    • 312
    FDibbins
    02-18-2019, 01:32 AM Go to last post

  48. Red face [SOLVED] Formula to keep cell blank

    Started by Alli...‎, 02-17-2019 07:30 PM
    • 2
    • 605
    Alli...
    02-17-2019, 10:11 PM Go to last post

  49. [SOLVED] Matching Similar Text Strings

    Started by BrooksN123‎, 02-17-2019 03:33 PM
    fuzzy lookup, match 2 Attachment(s)
    • 4
    • 7,041
    BrooksN123
    02-17-2019, 09:05 PM Go to last post

  50. Help! need formula to compare values

    Started by murree‎, 02-01-2019 12:56 PM
    compare values 1 column, lookup 2 Attachment(s)
    • 7
    • 532
    JeteMc
    02-17-2019, 07:13 PM Go to last post
+ Post New Thread
Page 1002 of 5614 FirstFirst ... 1002 ...

Forum Information and Options

Users Browsing this Forum

There are currently 80 users browsing this forum. (2 members & 78 guests)

  1. btparkhe1920,
  2. Narbar_123

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