+ Post New Thread
Page 4941 of 5615 FirstFirst ... 4941 ...
Threads 247001 to 247050 of 280712

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

  1. [SOLVED] Assign a week commencing date to a random date

    Started by STUARTXL‎, 09-28-2016 02:10 PM
    2 Attachment(s)
    • 6
    • 569
    STUARTXL
    09-28-2016, 02:48 PM Go to last post

  2. Replicate Array without Duplicates

    Started by STUARTXL‎, 06-21-2016 09:02 AM
    • 2
    • 551
    forestview
    06-21-2016, 02:46 PM Go to last post

  3. [SOLVED] Annual Leave Form - Sum the workdays (value of 1) if they fall between Start Day & End Day

    Started by STUARTXL‎, 06-25-2016 09:14 AM
    2 Attachment(s)
    • 7
    • 744
    southward
    06-25-2016, 11:10 AM Go to last post

  4. [SOLVED] Convert Hours into Minutes

    Started by STUARTXL‎, 07-14-2016 10:47 AM
    1 Attachment(s)
    • 2
    • 326
    STUARTXL
    07-14-2016, 11:02 AM Go to last post

  5. [SOLVED] Combine SUMIFS and INDEX MATCH - or an alternative that achieves the same...

    Started by STUARTXL‎, 07-17-2016 08:29 AM
    1 Attachment(s)
    • 2
    • 2,041
    STUARTXL
    07-17-2016, 01:06 PM Go to last post

  6. Extract text based on delimiters using formula. And then incorporate to INDEX MATCH

    Started by STUARTXL‎, 07-19-2016 10:52 AM
    • 3
    • 663
    JohnTopley
    07-20-2016, 03:52 AM Go to last post

  7. Index Match / VLookup to reference Worksheets

    Started by STUARTXL‎, 07-22-2016 09:07 AM
    1 Attachment(s)
    • 4
    • 571
    Jonmo1
    07-22-2016, 09:29 AM Go to last post

  8. Formula to reference the name of a worksheet other than the one being used

    Started by STUARTXL‎, 08-10-2016 05:17 AM
    • 2
    • 390
    Pete_UK
    08-10-2016, 05:27 AM Go to last post

  9. SMALL formula not displaying all data in array - issue with data?

    Started by STUARTXL‎, 08-17-2016 04:13 AM
    1 Attachment(s)
    • 6
    • 412
    Glenn Kennedy
    08-17-2016, 04:30 AM Go to last post

  10. SUMIFS with vertical criteria and horizontal criteria (horiz. crit. is a date range check)

    Started by STUARTXL‎, 09-09-2016 12:07 PM
    2 Attachment(s)
    • 5
    • 1,982
    xlnitwit
    10-03-2016, 03:39 AM Go to last post

  11. [SOLVED] Naming Dependent Lists for Data Validation as a Number

    Started by STUARTXL‎, 09-13-2016 03:31 AM
    1 Attachment(s)
    • 8
    • 553
    TMS
    09-13-2016, 12:10 PM Go to last post

  12. [SOLVED] Simple suumproduct query

    Started by STUARTXL‎, 09-27-2016 09:05 AM
    1 Attachment(s)
    • 6
    • 658
    Jonmo1
    09-27-2016, 10:16 AM Go to last post

  13. [SOLVED] Arranging values from Series of Arrays in Descending Order by Formula - Not Macro

    Started by STUARTXL‎, 06-18-2016 04:27 AM
    6 Attachment(s)
    • 16
    • 1,425
    JohnTopley
    06-19-2016, 06:18 AM Go to last post

  14. If Formula to Generate Result if 1 date is 'X' days on from Second Date

    Started by STUARTXL‎, 10-01-2016 08:39 AM
    4 Attachment(s)
    • 12
    • 648
    STUARTXL
    03-07-2017, 11:05 AM Go to last post

  15. [SOLVED] Adjust SUMPRODUCT formula to ignore blank values and thereby avoid VALUE errors

    Started by STUARTXL‎, 10-02-2016 06:01 AM
    2 Attachment(s)
    • 4
    • 624
    STUARTXL
    10-02-2016, 07:38 AM Go to last post

  16. Create unique references (according to date) across two tabs then summarise on third tab

    Started by STUARTXL‎, 10-09-2016 08:53 AM
    1 Attachment(s)
    • 12
    • 516
    JohnTopley
    10-09-2016, 11:10 AM Go to last post

  17. Periodic cumulative sums of a single array, restarting every time a certain value appears

    Started by STUARTXL‎, 12-02-2016 09:19 AM
    2 Attachment(s)
    • 5
    • 583
    JohnTopley
    12-03-2016, 07:18 AM Go to last post

  18. Couple of simple date issues plus a compound increase problem

    Started by STUARTXL‎, 12-12-2016 03:35 PM
    3 Attachment(s)
    • 2
    • 572
    queuesef
    12-12-2016, 04:53 PM Go to last post

  19. Help Requested in the Creation of a Company Calendar

    Started by STUARTXL‎, 03-07-2017 09:01 AM
    11 Attachment(s)
    • 41
    • 1,000
    Pete_UK
    03-09-2017, 03:28 PM Go to last post

  20. Index Match - Return unique results when Lookup Array contains duplicate values

    Started by STUARTXL‎, 03-13-2017 08:39 AM
    2 Attachment(s)
    • 2
    • 1,675
    micope21
    03-15-2017, 08:22 AM Go to last post

  21. [SOLVED] Find a value based on multiple vertica values and one horizontal value

    Started by STUARTXL‎, 03-20-2017 05:21 AM
    2 Attachment(s)
    • 2
    • 278
    avk
    03-20-2017, 05:47 AM Go to last post

  22. Annual Leave Calendar

    Started by STUARTXL‎, 04-10-2017 08:11 AM
    3 Attachment(s)
    • 5
    • 1,203
    JohnTopley
    04-13-2017, 03:12 AM Go to last post

  23. Check if date falls b/twn start date in one array and end date in 2nd arr & return value

    Started by STUARTXL‎, 04-26-2017 07:05 AM
    1 Attachment(s)
    • 2
    • 426
    samba_ravi
    04-26-2017, 08:06 AM Go to last post

  24. Create a column of data on Tab 3 which replicates all column data in Tab 1 and Tab 2

    Started by STUARTXL‎, 09-12-2017 10:18 AM
    3 Attachment(s)
    • 2
    • 311
    sandy666
    09-12-2017, 02:32 PM Go to last post

  25. [SOLVED] Block access to data validation list if value in column A is blank

    Started by STUARTXL‎, 04-24-2018 08:14 AM
    • 5
    • 298
    JohnTopley
    04-25-2018, 10:30 AM Go to last post

  26. [SOLVED] Use VLOOKUP to duplicate exp. in cashflow, using timings assigned in another table

    Started by STUARTXL‎, 01-19-2016 02:44 PM
    1 Attachment(s)
    • 3
    • 568
    AlKey
    01-19-2016, 03:07 PM Go to last post

  27. Create unique array of information (ignoring duplicates) based on dates meeting criteria

    Started by STUARTXL‎, 01-02-2017 05:42 AM
    4 Attachment(s)
    • 10
    • 618
    Richard Buttrey
    01-02-2017, 01:44 PM Go to last post

  28. Add 1 month to a date to give the EOM of following month

    Started by STUARTXL‎, 08-31-2016 03:34 AM
    • 3
    • 580
    STUARTXL
    08-31-2016, 03:46 AM Go to last post

  29. Can I assign a cell a date vale AND a time value (time value being AM or PM)

    Started by STUARTXL‎, 01-09-2016 03:11 AM
    • 1
    • 570
    zbor
    01-09-2016, 03:20 AM Go to last post

  30. IF statement that also uses index match to verify if date falls with date range

    Started by STUARTXL‎, 01-15-2017 06:24 AM
    1 Attachment(s)
    • 10
    • 591
    JohnTopley
    01-15-2017, 08:02 AM Go to last post

  31. Is automatic division/cell population possible?

    Started by STUARTXL‎, 10-31-2015 06:01 AM
    5 Attachment(s)
    • 9
    • 606
    samba_ravi
    10-31-2015, 07:16 AM Go to last post

  32. Prevent printing if Excel spreadsheet contains an error

    Started by STUARTXL‎, 11-01-2015 09:27 AM
    • 1
    • 426
    mrice
    11-01-2015, 04:23 PM Go to last post

  33. Insert X number of lines based on value in one cell

    Started by STUARTXL‎, 02-25-2016 04:27 PM
    • 1
    • 399
    mehmetcik
    02-26-2016, 02:17 PM Go to last post

  34. [SOLVED] Negative Numbers in Red Brackets, Positive Numbers in Accounting Format

    Started by STUARTXL‎, 12-24-2015 07:18 AM
    • 1
    • 59,358
    samba_ravi
    12-24-2015, 08:29 AM Go to last post

  35. [SOLVED] Automatically insert row below once empty cells have value inserted

    Started by STUARTXL‎, 12-24-2015 12:55 PM
    1 Attachment(s)
    • 1
    • 463
    samba_ravi
    12-24-2015, 02:27 PM Go to last post

  36. [SOLVED] Holiday request form - help with formatting please

    Started by STUARTXL‎, 01-08-2016 12:13 PM
    4 Attachment(s)
    • 9
    • 995
    STUARTXL
    01-15-2016, 04:28 AM Go to last post

  37. Quick and Easy Way to Align Rows

    Started by STUARTXL‎, 01-07-2016 04:40 AM
    2 Attachment(s)
    • 1
    • 615
    dflak
    01-09-2016, 11:36 AM Go to last post

  38. [SOLVED] Assistance with Macros on Stock Sheet

    Started by STUARTXL‎, 01-19-2016 07:16 AM
    1 Attachment(s)
    • 0
    • 365
    STUARTXL
    01-19-2016, 07:16 AM Go to last post

  39. Split data by delimiters but by formula (not Text to Columns)

    Started by STUARTXL‎, 06-19-2016 04:02 AM
    • 4
    • 652
    sandy666
    06-19-2016, 05:44 AM Go to last post

  40. [SOLVED] Total value of last X cells depending on value of another cell

    Started by STUARTXL‎, 02-22-2016 11:33 AM
    1 Attachment(s)
    • 4
    • 789
    InvisibleMan
    02-22-2016, 05:30 PM Go to last post

  41. Help with IF formula - too many ANDs and ORs for my liking!

    Started by STUARTXL‎, 02-22-2016 04:27 PM
    1 Attachment(s)
    • 2
    • 849
    thisoldman
    02-23-2016, 11:54 AM Go to last post

  42. Help with IF formula - too many ANDs and ORs for my liking!

    Started by STUARTXL‎, 02-22-2016 04:30 PM
    1 Attachment(s)
    • 2
    • 467
    6StringJazzer
    02-22-2016, 04:49 PM Go to last post

  43. [SOLVED] Two dimensional lookup

    Started by STUARTXL‎, 03-04-2016 10:52 PM
    1 Attachment(s)
    • 3
    • 571
    benishiryo
    03-04-2016, 11:51 PM Go to last post

  44. Two dimensional lookup Part II

    Started by STUARTXL‎, 03-05-2016 04:59 AM
    3 Attachment(s)
    • 9
    • 761
    jason.b75
    03-07-2016, 11:57 AM Go to last post

  45. [SOLVED] Aged Receivables - Separate Invoice Date from Payment Date in Aged Summary

    Started by STUARTXL‎, 03-15-2016 03:26 AM
    1 Attachment(s)
    • 10
    • 1,150
    JohnTopley
    03-21-2016, 10:07 AM Go to last post

  46. [SOLVED] Formula to replicate data on one spreadsheet but giving me an extra column every other col

    Started by STUARTXL‎, 04-27-2016 04:13 AM
    1 Attachment(s)
    • 2
    • 304
    oeldere
    04-27-2016, 04:27 AM Go to last post

  47. [SOLVED] Embed a Folder

    Started by STUARTXL‎, 04-30-2016 05:08 AM
    • 2
    • 9,126
    cytop
    04-30-2016, 05:15 AM Go to last post

  48. [SOLVED] VLOOKUP to return percentage as "%"

    Started by STUARTXL‎, 05-06-2016 09:28 AM
    • 3
    • 17,532
    cytop
    05-06-2016, 09:45 AM Go to last post

  49. [SOLVED] Conditional Formatting on this Annual Leave Form

    Started by STUARTXL‎, 06-25-2016 12:58 PM
    2 Attachment(s)
    • 2
    • 760
    STUARTXL
    06-25-2016, 01:23 PM Go to last post

  50. [SOLVED] Count If Non-Contiguous Formula - How can I drag this down?

    Started by STUARTXL‎, 06-08-2016 11:03 AM
    1 Attachment(s)
    • 14
    • 2,940
    Tony Valko
    06-08-2016, 05:22 PM Go to last post
+ Post New Thread
Page 4941 of 5615 FirstFirst ... 4941 ...

Forum Information and Options

Users Browsing this Forum

There are currently 107 users browsing this forum. (5 members & 102 guests)

  1. andyjay_4,
  2. CK76,
  3. fysty0102,
  4. td3201

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