+ Post New Thread
Page 603 of 5614 FirstFirst ... 603 ...
Threads 30101 to 30150 of 280691

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. [SOLVED] remove text around date

    Started by sick stigma‎, 11-13-2020 11:12 AM
    3 Attachment(s)
    • 10
    • 450
    sick stigma
    11-13-2020, 12:48 PM Go to last post

  2. If Data in Colmun A is true it counts data in Column D

    Started by dl1carp‎, 11-12-2020 10:42 PM
    2 Attachment(s)
    • 6
    • 260
    Glenn Kennedy
    11-13-2020, 12:41 PM Go to last post

  3. What function to use for 2 column with name and number for a total

    Started by 007Buff‎, 11-13-2020 12:15 PM
    • 7
    • 290
    Sam Capricci
    11-13-2020, 12:38 PM Go to last post

  4. Lookup new cell content

    Started by mss90‎, 11-11-2020 12:31 PM
    4 Attachment(s)
    • 5
    • 271
    Kaper
    11-13-2020, 12:19 PM Go to last post

  5. Simple stop substraction help

    Started by Blaz_SLO‎, 11-13-2020 08:50 AM
    • 5
    • 234
    Pete_UK
    11-13-2020, 11:03 AM Go to last post

  6. Working out headcount

    Started by HD1080‎, 11-09-2020 10:21 AM
    • 6
    • 839
    CK76
    11-13-2020, 10:23 AM Go to last post

  7. [SOLVED] Nested Substitute for First Character?

    Started by WaveWalker116‎, 11-13-2020 09:05 AM
    2 Attachment(s)
    • 1
    • 276
    Bo_Ry
    11-13-2020, 09:52 AM Go to last post

  8. Round total quantity from MAX formula

    Started by ladywhite‎, 11-13-2020 08:27 AM
    1 Attachment(s)
    • 2
    • 218
    ladywhite
    11-13-2020, 08:41 AM Go to last post

  9. Question How to detect the language version of Excel with a formula, not using VBA.

    Started by Gustavo.Tangassi‎, 11-10-2020 10:56 AM
    language detection., language id 4 Attachment(s)
    • 12
    • 5,240
    BMV
    11-13-2020, 07:50 AM Go to last post

  10. [SOLVED] Need cell populating with date if certain word is selected from dropdown in different cell

    Started by GREGHAM1982‎, 11-13-2020 05:31 AM
    • 6
    • 350
    AliGW
    11-13-2020, 07:48 AM Go to last post

  11. Conditional Formatting a range of cells based on a range of cells on another sheet.

    Started by operationsahcc‎, 11-12-2020 10:20 PM
    6 Attachment(s)
    • 2
    • 686
    kvsrinivasamurthy
    11-13-2020, 05:47 AM Go to last post

  12. [SOLVED] Index Match with multiple results

    Started by Wizards‎, 11-12-2020 07:07 PM
    index, match, small 1 Attachment(s)
    • 4
    • 538
    hrlngrv
    11-13-2020, 01:38 AM Go to last post

  13. Excel lookup between 2 Dates if Holiday Occurs

    Started by revocats10‎, 11-12-2020 04:12 PM
    dates 1 Attachment(s)
    • 10
    • 778
    revocats10
    11-13-2020, 12:35 AM Go to last post

  14. Eliminating empty cells over multiple columns

    Started by QSGuy‎, 11-12-2020 07:26 AM
    2 Attachment(s)
    • 4
    • 231
    QSGuy
    11-12-2020, 09:37 PM Go to last post

  15. Red face [SOLVED] How to fix the formula in Named ranges that is changing randomly by itself

    Started by qzqzjcjp‎, 11-12-2020 07:11 PM
    2 Attachment(s)
    • 4
    • 185
    qzqzjcjp
    11-12-2020, 08:48 PM Go to last post

  16. What Formula to use for text and numbers? If?

    Started by reginazhao‎, 11-12-2020 03:31 PM
    1 Attachment(s)
    • 5
    • 258
    Pete_UK
    11-12-2020, 07:42 PM Go to last post

  17. How to flag columns based off the result of a formula.

    Started by EXPEDITION123‎, 11-12-2020 06:57 PM
    1 Attachment(s)
    • 1
    • 352
    Pete_UK
    11-12-2020, 07:31 PM Go to last post

  18. Solution to finding formula to see if two columns in the same row contain matching informa

    Started by EXPEDITION123‎, 11-12-2020 07:04 PM
    1 Attachment(s)
    • 1
    • 210
    Pete_UK
    11-12-2020, 07:28 PM Go to last post

  19. [SOLVED] How to find appropriate match based on multiple values?

    Started by jordonix‎, 11-12-2020 05:31 PM
    • 2
    • 205
    jordonix
    11-12-2020, 06:40 PM Go to last post

  20. [SOLVED] If cell is greater than X, add 1 help.

    Started by HeriKuri‎, 11-12-2020 02:57 PM
    • 8
    • 253
    Fluff13
    11-12-2020, 06:31 PM Go to last post

  21. [SOLVED] Calculate G between F & M

    Started by jtglanton‎, 11-11-2020 04:31 PM
    2 Attachment(s)
    • 5
    • 347
    MrShorty
    11-12-2020, 06:11 PM Go to last post

  22. [SOLVED] Need help with Vlookup

    Started by Megatronv‎, 11-12-2020 04:09 PM
    1 Attachment(s)
    • 5
    • 201
    Megatronv
    11-12-2020, 05:32 PM Go to last post

  23. SEARCH function not returning expected values?

    Started by cph020283‎, 11-12-2020 04:46 PM
    1 Attachment(s)
    • 4
    • 203
    hrlngrv
    11-12-2020, 05:27 PM Go to last post

  24. How to reference a certain sheet in an dynamic AVERAGEIFS function

    Started by jarmonking‎, 11-12-2020 02:13 PM
    2 Attachment(s)
    • 9
    • 1,149
    Estevaoba
    11-12-2020, 05:17 PM Go to last post

  25. [SOLVED] match criteria and return earliest date formula help

    Started by lilsnoop‎, 11-12-2020 02:28 PM
    1 Attachment(s)
    • 7
    • 341
    Fluff13
    11-12-2020, 04:33 PM Go to last post

  26. Return the value with the highest occurance, with a tiebreaker.

    Started by dbl_dbl‎, 11-11-2020 06:31 PM
    5 Attachment(s)
    • 9
    • 419
    dbl_dbl
    11-12-2020, 02:58 PM Go to last post

  27. Use data if corresponding times are between certain hours

    Started by rjsnl‎, 11-12-2020 11:15 AM
    3 Attachment(s)
    • 3
    • 252
    Bo_Ry
    11-12-2020, 01:54 PM Go to last post

  28. [SOLVED] Search value on pivot table

    Started by elbarauljr‎, 11-07-2020 04:49 PM
    data, pivot, value change, vlookup 2 Attachment(s)
    • 7
    • 619
    JeteMc
    11-12-2020, 01:32 PM Go to last post

  29. Count occurrances with crieria from other column(s)

    Started by bdav1216‎, 11-12-2020 01:07 PM
    2 Attachment(s)
    • 2
    • 184
    Bo_Ry
    11-12-2020, 01:29 PM Go to last post

  30. [SOLVED] blank rows being returned, dates being returned twice

    Started by Kanuck‎, 11-12-2020 04:09 AM
    3 Attachment(s)
    • 5
    • 379
    Glenn Kennedy
    11-12-2020, 12:58 PM Go to last post

  31. [SOLVED] Remove PAST DUE and NEGATIVE numbers when completed

    Started by Nvable‎, 11-12-2020 10:36 AM
    2 Attachment(s)
    • 4
    • 332
    Nvable
    11-12-2020, 11:11 AM Go to last post

  32. [SOLVED] Counting multiple criteria

    Started by 90paulwilson‎, 11-12-2020 07:53 AM
    1 Attachment(s)
    • 6
    • 248
    Glenn Kennedy
    11-12-2020, 11:06 AM Go to last post

  33. [SOLVED] Formula to return content from cell if two other cells match

    Started by groopezeah‎, 11-12-2020 09:03 AM
    formula assistance
    • 2
    • 263
    groopezeah
    11-12-2020, 10:40 AM Go to last post

  34. [SOLVED] Formula Help - A specific Part number, sum it's quantities, and multiply by 25.

    Started by HayHay‎, 11-10-2020 09:30 PM
    1 Attachment(s)
    • 5
    • 335
    HayHay
    11-12-2020, 10:39 AM Go to last post

  35. Produce Count of Instances a List Has Repeat Text

    Started by andrenow‎, 11-11-2020 10:48 AM
    • 5
    • 246
    Fluff13
    11-12-2020, 10:19 AM Go to last post

  36. Matrix Multiplication

    Started by ChiccoLisoFolmichino‎, 11-12-2020 10:19 AM
    1 Attachment(s)
    • 0
    • 268
    ChiccoLisoFolmichino
    11-12-2020, 10:19 AM Go to last post

  37. [SOLVED] Selecting value multiple times from data validation list

    Started by FloorPlanner‎, 11-12-2020 06:57 AM
    3 Attachment(s)
    • 8
    • 440
    Glenn Kennedy
    11-12-2020, 10:07 AM Go to last post

  38. [SOLVED] Formula to populate result based on 2 cells

    Started by Steve_F_74‎, 11-12-2020 07:11 AM
    2 Attachment(s)
    • 7
    • 352
    AliGW
    11-12-2020, 10:02 AM Go to last post

  39. [SOLVED] Rounding results and need for blank cell when zero

    Started by darothwell‎, 11-11-2020 12:01 PM
    1 Attachment(s)
    • 4
    • 528
    TMS
    11-12-2020, 10:00 AM Go to last post

  40. Need to fill in a cell behind a cell in another tab when 2 values match.

    Started by lexievv‎, 11-12-2020 09:21 AM
    ifs and lookups, tabs sheets, vert.zoeken 1 Attachment(s)
    • 3
    • 490
    Glenn Kennedy
    11-12-2020, 09:59 AM Go to last post

  41. [SOLVED] Generate unique IDs from customers' e-mails

    Started by Rebelexcel‎, 11-10-2020 08:33 AM
    • 2
    • 223
    Rebelexcel
    11-12-2020, 09:20 AM Go to last post

  42. [SOLVED] Allocation of amount between dates

    Started by haroonkhurshid‎, 10-28-2020 05:28 PM
    4 Attachment(s)
    • 8
    • 822
    JeteMc
    11-12-2020, 09:09 AM Go to last post

  43. [SOLVED] Use formulas to show visibility of employees

    Started by adamnc‎, 11-11-2020 11:57 AM
    3 Attachment(s)
    • 11
    • 346
    Squeaky
    11-12-2020, 09:03 AM Go to last post

  44. Converting a small amount of data into a row

    Started by Kalamari‎, 11-12-2020 08:32 AM
    2 Attachment(s)
    • 2
    • 192
    Kalamari
    11-12-2020, 08:46 AM Go to last post

  45. Post [SOLVED] Calculate cumulative sums and obtain highest value based on it

    Started by Rehman5000‎, 11-07-2020 01:40 AM
    aggregate, cumulative sum, lookup, maxifs minifs countifs, sumifs 9 Attachment(s)
    • 15
    • 1,820
    JeteMc
    11-12-2020, 08:43 AM Go to last post

  46. [SOLVED] Vacation half days to be counted and minused

    Started by riverman_27‎, 11-12-2020 06:44 AM
    2 Attachment(s)
    • 3
    • 206
    AliGW
    11-12-2020, 08:08 AM Go to last post

  47. Question can this be automated without VBA?

    Started by xlepws‎, 11-11-2020 05:36 AM
    • 5
    • 275
    kvsrinivasamurthy
    11-12-2020, 07:59 AM Go to last post

  48. Formula required for return a section wise different objects number of quantities.

    Started by Mohammad Munawar‎, 11-12-2020 04:39 AM
    lookup, multiple criteria, quantities. 4 Attachment(s)
    • 7
    • 560
    Mohammad Munawar
    11-12-2020, 07:43 AM Go to last post

  49. Formula help - Find date nearest to Monday

    Started by meegs‎, 11-11-2020 10:18 PM
    1 Attachment(s)
    • 14
    • 345
    kvsrinivasamurthy
    11-12-2020, 07:39 AM Go to last post

  50. [SOLVED] Conditional Formatting

    Started by brickaboodle‎, 11-12-2020 06:16 AM
    2 Attachment(s)
    • 2
    • 218
    AliGW
    11-12-2020, 07:17 AM Go to last post
+ Post New Thread
Page 603 of 5614 FirstFirst ... 603 ...

Forum Information and Options

Users Browsing this Forum

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

  1. HansDouwe,
  2. 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