+ Post New Thread
Page 4951 of 5611 FirstFirst ... 4951 ...
Threads 247501 to 247550 of 280549

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

  1. Sales summary for the month

    Started by leovilla‎, 07-23-2020 01:57 PM
    1 Attachment(s)
    • 4
    • 219
    leovilla
    07-24-2020, 10:16 AM Go to last post

  2. search for keywords in one column; if found add different keywords to text another column

    Started by jpf131‎, 07-23-2020 11:15 AM
    2 Attachment(s)
    • 4
    • 313
    jpf131
    07-24-2020, 10:23 AM Go to last post

  3. Function to search 3 exact variables from 3 columns in a matrix

    Started by CapoDiCapi‎, 07-23-2020 03:28 PM
    4 Attachment(s)
    • 16
    • 646
    Haluk
    07-24-2020, 10:48 AM Go to last post

  4. [SOLVED] find horizontal category, then sort vertically

    Started by jistme‎, 07-24-2020 03:39 AM
    5 Attachment(s)
    • 8
    • 303
    alansidman
    07-24-2020, 11:35 AM Go to last post

  5. [SOLVED] Paye as you earn formula

    Started by sunboy‎, 07-23-2020 11:44 PM
    1 Attachment(s)
    • 4
    • 724
    GeoffW283
    07-24-2020, 12:18 PM Go to last post

  6. formatting all line

    Started by john_cash‎, 07-23-2020 05:17 PM
    1 Attachment(s)
    • 2
    • 172
    john_cash
    07-24-2020, 12:18 PM Go to last post

  7. Count Similar Values

    Started by excelingtoexcel‎, 07-23-2020 01:48 PM
    4 Attachment(s)
    • 4
    • 220
    Bo_Ry
    07-24-2020, 01:01 PM Go to last post

  8. Counting specific days in a range?

    Started by zpenacho‎, 07-23-2020 09:26 PM
    count, dates, range 1 Attachment(s)
    • 2
    • 405
    zpenacho
    07-24-2020, 01:16 PM Go to last post

  9. Having something happen randomly a given percentage of the time

    Started by jrsimon25‎, 07-23-2020 09:21 PM
    1 Attachment(s)
    • 2
    • 237
    jrsimon25
    07-24-2020, 01:31 PM Go to last post

  10. [SOLVED] Finding the largest spread in a moving series of cells

    Started by oftel101‎, 07-23-2020 06:14 PM
    2 Attachment(s)
    • 9
    • 419
    GeoffW283
    07-24-2020, 01:31 PM Go to last post

  11. Extracting From Date Ranges

    Started by lettucesee‎, 07-23-2020 01:42 PM
    2 Attachment(s)
    • 5
    • 262
    lettucesee
    07-24-2020, 02:27 PM Go to last post

  12. BicubicInterpolation with lot of missing data

    Started by AnnetteDK‎, 07-24-2020 02:18 AM
    1 Attachment(s)
    • 3
    • 232
    MrShorty
    07-24-2020, 02:31 PM Go to last post

  13. Find blank rows with array formula

    Started by capthollyshort‎, 07-24-2020 03:33 PM
    1 Attachment(s)
    • 6
    • 213
    capthollyshort
    07-24-2020, 04:48 PM Go to last post

  14. CF: a formula that has a num conditions across a num columns, that also uses minus numb

    Started by andylowekcx‎, 07-23-2020 10:55 AM
    2 Attachment(s)
    • 7
    • 233
    GeoffW283
    07-24-2020, 04:54 PM Go to last post

  15. [SOLVED] Using index to find matches across multiple worksheets with multiple matches

    Started by ZOND2‎, 07-23-2020 10:12 PM
    1 Attachment(s)
    • 8
    • 393
    Limor_OP
    07-24-2020, 07:16 PM Go to last post

  16. [SOLVED] Totalling Hours Formula (edited)

    Started by And180y‎, 07-24-2020 04:21 PM
    1 Attachment(s)
    • 5
    • 284
    And180y
    07-24-2020, 08:07 PM Go to last post

  17. [SOLVED] Formulating 1/1/2021-1/2/2021, 1/3/2021-1/9/2021 etc through one row.

    Started by jbposey86‎, 07-21-2020 09:02 PM
    3 Attachment(s)
    • 4
    • 772
    6StringJazzer
    07-24-2020, 08:27 PM Go to last post

  18. [SOLVED] Return Column String based on ID and Range (min and max).

    Started by Jackson2806‎, 07-23-2020 07:58 PM
    datasets, lookups, multiple arguments 1 Attachment(s)
    • 4
    • 323
    Jackson2806
    07-24-2020, 09:55 PM Go to last post

  19. need to calculate interest on invoices each day past due until paid and leaving the int

    Started by deeepan2005‎, 07-25-2020 01:58 AM
    1 Attachment(s)
    • 1
    • 489
    Pepe Le Mokko
    07-25-2020, 02:46 AM Go to last post

  20. [SOLVED] Get value in dropdown

    Started by And180y‎, 07-24-2020 07:30 PM
    2 Attachment(s)
    • 1
    • 250
    oeldere
    07-25-2020, 02:57 AM Go to last post

  21. [SOLVED] Data Validation on the signature

    Started by fgfgicare‎, 07-24-2020 05:23 AM
    3 Attachment(s)
    • 10
    • 314
    fgfgicare
    07-25-2020, 03:38 AM Go to last post

  22. [SOLVED] Extract values with criteria then sort them

    Started by Villalobos‎, 07-25-2020 02:08 AM
    2 Attachment(s)
    • 4
    • 338
    AliGW
    07-25-2020, 05:24 AM Go to last post

  23. [SOLVED] Data Validation on Date and Time

    Started by fgfgicare‎, 07-25-2020 04:24 AM
    1 Attachment(s)
    • 7
    • 326
    AliGW
    07-25-2020, 06:04 AM Go to last post

  24. [SOLVED] Radio Button on the form

    Started by fgfgicare‎, 07-22-2020 03:18 AM
    12 Attachment(s)
    • 22
    • 667
    fgfgicare
    07-25-2020, 06:05 AM Go to last post

  25. Using SUMIFS to categorize expenditures monthly.

    Started by jbposey86‎, 07-24-2020 07:31 PM
    2 Attachment(s)
    • 8
    • 305
    Richard Buttrey
    07-25-2020, 07:52 AM Go to last post

  26. assigning 20 vans to 50 employees based on preference

    Started by Katrix198206‎, 07-24-2020 03:54 PM
    assignment, vlookup
    • 2
    • 483
    alansidman
    07-25-2020, 08:03 AM Go to last post

  27. [SOLVED] trouble with aggregate function in index formula

    Started by chriswrcg‎, 07-25-2020 08:14 AM
    2 Attachment(s)
    • 8
    • 684
    chriswrcg
    07-25-2020, 09:11 AM Go to last post

  28. [SOLVED] Existing formulas don't correctly show the status of cells being either blank or text.

    Started by Smudge.Smith‎, 07-25-2020 03:16 AM
    3 Attachment(s)
    • 6
    • 291
    Smudge.Smith
    07-25-2020, 10:03 AM Go to last post

  29. [SOLVED] Password generator conversion to Xl2003

    Started by CDandVinyl‎, 07-24-2020 05:57 PM
    2 Attachment(s)
    • 5
    • 302
    CDandVinyl
    07-25-2020, 10:13 AM Go to last post

  30. [SOLVED] Add a second aggregate match criteria

    Started by chriswrcg‎, 07-25-2020 09:51 AM
    1 Attachment(s)
    • 8
    • 228
    AliGW
    07-25-2020, 10:33 AM Go to last post

  31. [SOLVED] Not counting cells when empty

    Started by andynw1‎, 07-25-2020 07:14 AM
    1 Attachment(s)
    • 4
    • 295
    andynw1
    07-25-2020, 01:22 PM Go to last post

  32. [SOLVED] Returning a random selection from the content of a cell

    Started by CDandVinyl‎, 07-24-2020 10:38 PM
    • 4
    • 309
    GeoffW283
    07-25-2020, 01:56 PM Go to last post

  33. [SOLVED] Sort numbers within a Cell from Large to Small (Ascending & Decending)

    Started by Gulya‎, 07-24-2020 08:35 AM
    • 5
    • 398
    Haluk
    07-25-2020, 02:21 PM Go to last post

  34. [SOLVED] Formula for days until next payday

    Started by Ady2673‎, 07-25-2020 01:06 PM
    1 Attachment(s)
    • 6
    • 297
    Ady2673
    07-25-2020, 02:40 PM Go to last post

  35. [SOLVED] Compare data from two different size databases - show matches

    Started by Twiest‎, 07-25-2020 08:55 PM
    2 Attachment(s)
    • 1
    • 226
    alansidman
    07-25-2020, 09:05 PM Go to last post

  36. TRUE/FALSE if first column is different + rest are the same

    Started by row2000‎, 07-25-2020 03:22 PM
    1 Attachment(s)
    • 2
    • 240
    FDibbins
    07-26-2020, 12:49 AM Go to last post

  37. Preventing duplicates in separate sections of the same column

    Started by niall2012‎, 07-25-2020 05:46 PM
    • 1
    • 216
    FDibbins
    07-26-2020, 12:57 AM Go to last post

  38. IF/THEN Statement to output tag (logic update to account for dates)

    Started by bdav1216‎, 06-24-2020 11:04 PM
    2 Attachment(s)
    • 15
    • 659
    AliGW
    07-26-2020, 01:23 AM Go to last post

  39. HELP with fixing a formula on the attached spreadsheet

    Started by vharp91‎, 07-25-2020 06:30 PM
    2 Attachment(s)
    • 3
    • 212
    AliGW
    07-26-2020, 01:27 AM Go to last post

  40. How to distribute a value to specific months

    Started by PD1989‎, 07-14-2020 03:50 AM
    4 Attachment(s)
    • 11
    • 708
    AliGW
    07-26-2020, 01:31 AM Go to last post

  41. Exclamation Convert emails into domain urls '[email protected] into excelforum.com'

    Started by danemos‎, 07-22-2015 08:21 AM
    concatenate, convert, email, url
    • 6
    • 1,622
    AliGW
    07-26-2020, 02:20 AM Go to last post

  42. [SOLVED] Formula to extract non blank data so that there are no blank rows betwwen the visible data

    Started by Howardc1001‎, 07-18-2020 11:06 PM
    1 Attachment(s)
    • 6
    • 359
    Howardc1001
    07-26-2020, 02:33 AM Go to last post

  43. Where do these tiny maths error come from?

    Started by vonsworld‎, 07-26-2020 04:07 AM
    • 4
    • 404
    AliGW
    07-26-2020, 05:43 AM Go to last post

  44. [SOLVED] Formula to check if one vale is greater than the other and sum the greater values to match

    Started by khanaran‎, 07-26-2020 05:57 AM
    1 Attachment(s)
    • 2
    • 358
    Bo_Ry
    07-26-2020, 06:37 AM Go to last post

  45. [SOLVED] Extract List with Formulas

    Started by josephteh‎, 07-25-2020 09:30 PM
    4 Attachment(s)
    • 2
    • 305
    josephteh
    07-26-2020, 07:29 AM Go to last post

  46. [SOLVED] Counting Columns Based on Criteria

    Started by VirginiaABC‎, 07-23-2020 02:03 PM
    2 Attachment(s)
    • 9
    • 469
    VirginiaABC
    07-26-2020, 07:48 AM Go to last post

  47. How to check if a 2 specific time falls in between 2 times (Shifts) in Excel?

    Started by athishvikram‎, 07-26-2020 09:27 AM
    duration, excel, shifts, time, time & attendance 1 Attachment(s)
    • 1
    • 614
    arlu1201
    07-26-2020, 09:28 AM Go to last post

  48. [SOLVED] Get Max Value from an Alphanumeric Range with Criteria

    Started by Rajeshkumar R‎, 07-25-2020 03:00 PM
    1 Attachment(s)
    • 3
    • 1,028
    Fluff13
    07-26-2020, 10:04 AM Go to last post

  49. Conditional Formatting based on a Multi-selection Pick list with Partial Content

    Started by mhall1957‎, 07-26-2020 08:32 AM
    2 Attachment(s)
    • 5
    • 359
    Fluff13
    07-26-2020, 12:56 PM Go to last post

  50. Create list of dates in order from lists across sheets

    Started by soundfx‎, 07-26-2020 12:13 PM
    2 Attachment(s)
    • 7
    • 352
    jeffreybrown
    07-26-2020, 04:32 PM Go to last post
+ Post New Thread
Page 4951 of 5611 FirstFirst ... 4951 ...

Forum Information and Options

Users Browsing this Forum

There are currently 51 users browsing this forum. (2 members & 49 guests)

  1. dummy777,
  2. klabtv

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