+ Post New Thread
Page 403 of 5614 FirstFirst ... 403 ...
Threads 20101 to 20150 of 280693

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

  1. Highlighting cells with same last name with different first names

    Started by davidingilbert‎, 11-04-2021 02:46 PM
    1 Attachment(s)
    • 3
    • 320
    Pete_UK
    11-04-2021, 04:51 PM Go to last post

  2. Have table populate rows automatically

    Started by heytherejem‎, 10-28-2021 10:25 AM
    auto-fill, lookup, range, table
    • 5
    • 480
    Coley356
    11-04-2021, 03:48 PM Go to last post

  3. [SOLVED] Counting cells in-between 2 values

    Started by IreSaffa‎, 11-03-2021 12:47 PM
    1 Attachment(s)
    • 6
    • 283
    FlameRetired
    11-04-2021, 03:34 PM Go to last post

  4. Working out days of rest with IFS function (two criteria)

    Started by caseyjayne23‎, 11-04-2021 09:21 AM
    1 Attachment(s)
    • 11
    • 262
    caseyjayne23
    11-04-2021, 03:04 PM Go to last post

  5. add a cell to a formula

    Started by john_cash‎, 11-04-2021 11:13 AM
    4 Attachment(s)
    • 8
    • 267
    john_cash
    11-04-2021, 03:00 PM Go to last post

  6. Finding & Matching Values Then Returning Sum

    Started by justgeminime‎, 10-30-2021 11:37 AM
    hlookup, match, vlookup 3 Attachment(s)
    • 9
    • 569
    justgeminime
    11-04-2021, 02:57 PM Go to last post

  7. Drop down list with hyperlinks or with referral/jump to another cell

    Started by E-Dan‎, 10-16-2021 07:41 PM
    3 Attachment(s)
    • 9
    • 471
    E-Dan
    11-04-2021, 02:15 PM Go to last post

  8. [SOLVED] Extracting Time from "Text"

    Started by Dexter2‎, 10-05-2021 02:16 PM
    1 Attachment(s)
    • 15
    • 521
    Dexter2
    11-04-2021, 01:10 PM Go to last post

  9. Question [SOLVED] Help with the UNIQUE function to count unique rows

    Started by EK923‎, 11-03-2021 01:27 PM
    • 10
    • 325
    Fluff13
    11-04-2021, 12:52 PM Go to last post

  10. [SOLVED] Continue number sequence

    Started by parbynat‎, 11-04-2021 11:32 AM
    1 Attachment(s)
    • 4
    • 264
    parbynat
    11-04-2021, 12:47 PM Go to last post

  11. Pulling cell reference into a formula

    Started by kimi01‎, 11-04-2021 11:23 AM
    1 Attachment(s)
    • 3
    • 254
    Pete_UK
    11-04-2021, 12:23 PM Go to last post

  12. Help with If and Add in one formula

    Started by TDFrench‎, 11-04-2021 06:19 AM
    3 Attachment(s)
    • 10
    • 253
    Keebellah
    11-04-2021, 11:26 AM Go to last post

  13. [SOLVED] =Sheet2!$B$ get number reference from another cell

    Started by heybeckstar‎, 11-04-2021 10:37 AM
    autofill, formula, reference, text retrieval 3 Attachment(s)
    • 3
    • 387
    DJunqueira
    11-04-2021, 11:12 AM Go to last post

  14. Exclamation [SOLVED] Need Help with IF formula in Function in Excel Please

    Started by TalleyMT‎, 11-04-2021 09:50 AM
    if functions and dates 1 Attachment(s)
    • 3
    • 184
    JohnTopley
    11-04-2021, 10:45 AM Go to last post

  15. [SOLVED] My foruma won't work but I can't see why

    Started by heytherejem‎, 11-04-2021 10:25 AM
    concatenate, formula, indirect, syntax, template
    • 4
    • 440
    Fluff13
    11-04-2021, 10:43 AM Go to last post

  16. Unhappy Creating a Structed Reference formula using a variable

    Started by chuckdiaz‎, 11-03-2021 02:18 PM
    structured reference, using variables
    • 4
    • 278
    Pete_UK
    11-04-2021, 09:17 AM Go to last post

  17. Exclamation [SOLVED] Need Help with IF formula in Excel

    Started by TalleyMT‎, 11-03-2021 02:12 PM
    if function 2 Attachment(s)
    • 5
    • 403
    TalleyMT
    11-04-2021, 09:16 AM Go to last post

  18. COUNTIF one cell has specific value and another is blank

    Started by SniS‎, 11-04-2021 08:18 AM
    countif, countifs
    • 1
    • 286
    AliGW
    11-04-2021, 08:22 AM Go to last post

  19. [SOLVED] Referencing multiple worksheets with COUNTIFS

    Started by BenHornsby2021‎, 11-04-2021 07:28 AM
    1 Attachment(s)
    • 1
    • 216
    JohnTopley
    11-04-2021, 07:42 AM Go to last post

  20. Columns to Rows based on email address

    Started by hamcam‎, 11-03-2021 05:50 PM
    3 Attachment(s)
    • 2
    • 230
    JohnTopley
    11-04-2021, 07:21 AM Go to last post

  21. Formula to only retrieve the first instance of something

    Started by oneblondebrow‎, 11-04-2021 05:39 AM
    • 5
    • 179
    AliGW
    11-04-2021, 06:13 AM Go to last post

  22. Trying to make a percent change formula

    Started by AdamW328‎, 11-03-2021 05:16 PM
    • 6
    • 282
    curiouscat408
    11-04-2021, 06:11 AM Go to last post

  23. Frequency Function Issue

    Started by Shallabee‎, 11-04-2021 05:59 AM
    array formula, dynamic range, frequency, structured reference
    • 1
    • 349
    AliGW
    11-04-2021, 06:06 AM Go to last post

  24. Moved: Counting Occurrence in Conjunction with Name on Multiple Sheets

    Started by theexcelnovice123‎, 11-04-2021 04:58 AM
    •  
    •  

  25. [SOLVED] calculate Month total

    Started by skipro‎, 11-02-2021 07:15 PM
    3 Attachment(s)
    • 17
    • 347
    AliGW
    11-04-2021, 05:01 AM Go to last post

  26. [SOLVED] extract only specified values from a table

    Started by Ghost12‎, 11-03-2021 05:38 PM
    3 Attachment(s)
    • 3
    • 311
    T.I.
    11-04-2021, 04:47 AM Go to last post

  27. Separating family name from full name

    Started by Debbie Uniforms‎, 11-04-2021 04:30 AM
    • 1
    • 139
    AliGW
    11-04-2021, 04:32 AM Go to last post

  28. Need correct formula to track stock gains and losses on a daily basis

    Started by AdamW328‎, 11-03-2021 09:04 PM
    • 2
    • 207
    AliGW
    11-04-2021, 04:29 AM Go to last post

  29. Question Need a sumifs/Index & match or any other formula for my requirement

    Started by Madhan_kumar‎, 11-04-2021 03:25 AM
    condional, error, formula, sumifs 1 Attachment(s)
    • 1
    • 429
    AliGW
    11-04-2021, 04:07 AM Go to last post

  30. Excel hyperlink to same sheet

    Started by ashcosta1‎, 11-04-2021 01:30 AM
    1 Attachment(s)
    • 1
    • 200
    Keebellah
    11-04-2021, 03:05 AM Go to last post

  31. Calculate Profit/Loss per Month, based on Data from another Sheet

    Started by ExcelLearner1111‎, 11-02-2021 07:54 PM
    1 Attachment(s)
    • 3
    • 411
    FlameRetired
    11-03-2021, 11:06 PM Go to last post

  32. Question How to repeat formula without changing table array

    Started by ThumperStrauss‎, 11-03-2021 08:31 PM
    • 1
    • 161
    DJunqueira
    11-03-2021, 08:34 PM Go to last post

  33. Cool [SOLVED] Commission Payable based on % target received

    Started by HannahExcelNewbie‎, 11-03-2021 06:51 PM
    #formula 4 Attachment(s)
    • 3
    • 267
    JohnTopley
    11-03-2021, 07:15 PM Go to last post

  34. [SOLVED] Conditional Format based on Sum

    Started by NISMOJim‎, 11-02-2021 01:03 AM
    • 4
    • 251
    NISMOJim
    11-03-2021, 06:53 PM Go to last post

  35. Sum based on filtered dataset

    Started by devonalex‎, 11-03-2021 05:08 PM
    1 Attachment(s)
    • 1
    • 214
    Estevaoba
    11-03-2021, 05:30 PM Go to last post

  36. Show available items sorted by multiple criteria and without calc error

    Started by Sosborg‎, 11-01-2021 11:15 PM
    database, formula arrays, multiple arguments, pick list, xlookup 1 Attachment(s)
    • 1
    • 433
    CRIMEDOG
    11-03-2021, 04:39 PM Go to last post

  37. [SOLVED] SUMIFS Formula Wrong Result

    Started by Big.Moe‎, 11-03-2021 01:13 PM
    1 Attachment(s)
    • 9
    • 248
    Big.Moe
    11-03-2021, 03:02 PM Go to last post

  38. [SOLVED] If between 3 different cirteria

    Started by KevyWevz‎, 11-03-2021 08:58 AM
    • 4
    • 218
    KevyWevz
    11-03-2021, 02:23 PM Go to last post

  39. Date range on "Master" sheet to populate "month" sheets following

    Started by Lundie‎, 10-28-2021 09:56 AM
    3 Attachment(s)
    • 10
    • 381
    janmorris
    11-03-2021, 02:15 PM Go to last post

  40. Currency IF formula

    Started by danielo08‎, 11-03-2021 12:15 PM
    1 Attachment(s)
    • 4
    • 233
    ashishadhib
    11-03-2021, 01:04 PM Go to last post

  41. [SOLVED] Search the nearest number in a range with a criteria

    Started by BeaglePapa61‎, 11-03-2021 11:06 AM
    3 Attachment(s)
    • 11
    • 356
    Fluff13
    11-03-2021, 11:57 AM Go to last post

  42. Return 3 column values if criteria met

    Started by Daniel_ISS‎, 11-03-2021 11:07 AM
    1 Attachment(s)
    • 1
    • 168
    Fluff13
    11-03-2021, 11:24 AM Go to last post

  43. Threshold Formulas - i need a formula to use across 4 thresholds

    Started by vba_newbie83‎, 11-03-2021 08:30 AM
    1 Attachment(s)
    • 3
    • 271
    JohnTopley
    11-03-2021, 11:08 AM Go to last post

  44. How to use TODAY function to cover an entire week?

    Started by sg88‎, 11-03-2021 10:23 AM
    gantt chart, project management, schedule, today function, tracking 2 Attachment(s)
    • 3
    • 472
    MrShorty
    11-03-2021, 11:05 AM Go to last post

  45. Question Help: concatenate, skip blanks, add line break

    Started by tiggynook‎, 11-01-2021 12:01 PM
    blank cell, concatenate, formula 2 Attachment(s)
    • 4
    • 577
    tiggynook
    11-03-2021, 10:30 AM Go to last post

  46. Compare cells, if true, result in another column

    Started by FreddyJay‎, 11-03-2021 09:31 AM
    3 Attachment(s)
    • 7
    • 328
    AliGW
    11-03-2021, 10:21 AM Go to last post

  47. 3 arguments in if statements

    Started by Jr66‎, 11-02-2021 06:14 PM
    1 Attachment(s)
    • 2
    • 216
    Jr66
    11-03-2021, 09:54 AM Go to last post

  48. Moved: Which formula for comparing Domain names and associated status between workbooks?

    Started by Sartoris‎, 09-21-2021 06:19 AM
    •  
    •  

  49. Question Conditional max or sumifs formula required

    Started by Madhan_kumar‎, 11-03-2021 02:59 AM
    sumifs/max 2 Attachment(s)
    • 5
    • 256
    DJunqueira
    11-03-2021, 05:26 AM Go to last post

  50. [SOLVED] Using the Power of two to find which options are selected in a recursive fashion

    Started by J_Andreas_Lindqvist‎, 11-01-2021 09:09 AM
    extract options, power by two, recursion 4 Attachment(s)
    • 12
    • 478
    J_Andreas_Lindqvist
    11-03-2021, 05:17 AM Go to last post
+ Post New Thread
Page 403 of 5614 FirstFirst ... 403 ...

Forum Information and Options

Users Browsing this Forum

There are currently 49 users browsing this forum. (3 members & 46 guests)

  1. boynejs,
  2. DeeWuu,
  3. JohnTopley

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