+ Post New Thread
Page 389 of 5627 FirstFirst ... 389 ...
Threads 19401 to 19450 of 281347

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

  1. [SOLVED] Index Sheet Names formula not working

    Started by SHELTONUNDERDOG‎, 01-03-2022 01:57 PM
    formula, get file names, index, name manager, sheet names 1 Attachment(s)
    • 4
    • 2,664
    SHELTONUNDERDOG
    01-04-2022, 12:00 PM Go to last post

  2. [SOLVED] Eliminate duplicate text

    Started by QSGuy‎, 02-02-2021 02:11 PM
    9 Attachment(s)
    • 25
    • 706
    JEC.
    01-04-2022, 11:54 AM Go to last post

  3. [SOLVED] Formula to calculate sales up to today's date

    Started by sunboy‎, 01-04-2022 10:45 AM
    2 Attachment(s)
    • 4
    • 197
    sunboy
    01-04-2022, 11:50 AM Go to last post

  4. [SOLVED] Getting data from another Tab

    Started by DEEARO‎, 01-04-2022 10:07 AM
    1 Attachment(s)
    • 2
    • 217
    TMS
    01-04-2022, 11:30 AM Go to last post

  5. [SOLVED] Creating 3 dependent drop-down lists

    Started by esmq‎, 01-04-2022 05:54 AM
    7 Attachment(s)
    • 17
    • 604
    AliGW
    01-04-2022, 11:26 AM Go to last post

  6. [SOLVED] Cond. Format. Not Applied to Entire Range -- Cell Anchoring Results in Manual Updates

    Started by skydivetom‎, 01-04-2022 08:55 AM
    1 Attachment(s)
    • 11
    • 229
    Fluff13
    01-04-2022, 10:36 AM Go to last post

  7. Question [SOLVED] Conditional formatting if values are found in a column

    Started by royeti‎, 01-04-2022 09:55 AM
    conditional formatting 4 Attachment(s)
    • 4
    • 300
    Pepe Le Mokko
    01-04-2022, 10:23 AM Go to last post

  8. [SOLVED] SUMIFS with 1 criteria variable and possible multi criteria

    Started by rpinxt‎, 01-04-2022 08:41 AM
    1 Attachment(s)
    • 5
    • 213
    JohnTopley
    01-04-2022, 08:58 AM Go to last post

  9. [SOLVED] Count amount of X year olds between values

    Started by Ikke1996‎, 01-04-2022 04:29 AM
    4 Attachment(s)
    • 13
    • 364
    Glenn Kennedy
    01-04-2022, 05:55 AM Go to last post

  10. Question [SOLVED] How to sum a colomn, excluding certain rows based on value in that row?

    Started by Seabottom‎, 01-04-2022 03:11 AM
    1 Attachment(s)
    • 6
    • 279
    Keebellah
    01-04-2022, 03:28 AM Go to last post

  11. Question ARRAY ctrl+Shift+Enter not working

    Started by KHoff1‎, 01-04-2022 12:43 AM
    array formula error 1 Attachment(s)
    • 3
    • 299
    FDibbins
    01-04-2022, 01:51 AM Go to last post

  12. [SOLVED] Week numbers sometimes wrong

    Started by areudeadyet‎, 01-02-2022 09:03 PM
    5 Attachment(s)
    • 10
    • 1,239
    kvsrinivasamurthy
    01-04-2022, 12:47 AM Go to last post

  13. [SOLVED] Resource scheduler: HELP! formula that will place 7-week bar on dates based on source date

    Started by bhughes73‎, 01-03-2022 11:16 PM
    1 Attachment(s)
    • 2
    • 238
    bhughes73
    01-04-2022, 12:02 AM Go to last post

  14. [SOLVED] How to keep calendar weeks in formulas

    Started by cableghost‎, 01-03-2022 04:41 PM
    2 Attachment(s)
    • 8
    • 287
    cableghost
    01-03-2022, 11:53 PM Go to last post

  15. Formula for timestamp on column data change

    Started by darandeyoe‎, 01-03-2022 03:35 PM
    3 Attachment(s)
    • 5
    • 249
    6StringJazzer
    01-03-2022, 09:19 PM Go to last post

  16. Question Extract multiple numbers from one string of text. e.g. 12INX24IN returns 12 and 24.

    Started by rickyrakka‎, 01-03-2022 06:24 PM
    2 Attachment(s)
    • 8
    • 252
    rickyrakka
    01-03-2022, 08:25 PM Go to last post

  17. Question [SOLVED] Reporting sum of all sheets into a master sheet

    Started by Overlord84‎, 12-11-2021 07:45 PM
    6 Attachment(s)
    • 10
    • 440
    Overlord84
    01-03-2022, 07:45 PM Go to last post

  18. [SOLVED] IF Function with 3 IF Statements

    Started by Rayds‎, 01-01-2022 10:08 AM
    if function excel 1 Attachment(s)
    • 5
    • 276
    AliGW
    01-03-2022, 04:35 PM Go to last post

  19. [SOLVED] SUMPRODUCT with conditions

    Started by cableghost‎, 01-01-2022 02:25 AM
    sumproduct 2 Attachment(s)
    • 4
    • 476
    cableghost
    01-03-2022, 04:31 PM Go to last post

  20. [SOLVED] Listing all people within a given distance of a given person

    Started by mandersen04‎, 01-01-2022 05:12 PM
    array argument, array conditional 3 Attachment(s)
    • 13
    • 500
    mandersen04
    01-03-2022, 02:21 PM Go to last post

  21. [SOLVED] How to get difference between two numbers based on condition

    Started by KRIXXXX‎, 01-01-2022 02:42 PM
    5 Attachment(s)
    • 6
    • 408
    Glenn Kennedy
    01-03-2022, 01:57 PM Go to last post

  22. [SOLVED] Conditional formatting for SLA

    Started by rizwanulhasan‎, 01-03-2022 10:00 AM
    conditional formating sla 1 Attachment(s)
    • 4
    • 314
    rizwanulhasan
    01-03-2022, 01:20 PM Go to last post

  23. How to apply "Week End" & Date

    Started by ypurcaro‎, 01-03-2022 12:27 PM
    • 2
    • 171
    JohnTopley
    01-03-2022, 12:43 PM Go to last post

  24. employee attendance tracker - need to display April 2016 - March 2017 not 2016, 2017......

    Started by emmavbarrett‎, 07-15-2016 06:29 AM
    4 Attachment(s)
    • 23
    • 1,834
    klhc
    01-03-2022, 10:45 AM Go to last post

  25. [SOLVED] Multiply specific Cells with criteria

    Started by giorgosd‎, 01-03-2022 08:16 AM
    2 Attachment(s)
    • 19
    • 392
    AliGW
    01-03-2022, 09:35 AM Go to last post

  26. [SOLVED] Problem with TEXT and weekday function

    Started by Armator‎, 01-03-2022 06:30 AM
    4 Attachment(s)
    • 13
    • 814
    AliGW
    01-03-2022, 07:45 AM Go to last post

  27. [SOLVED] I need help with automatic display of days

    Started by Hansenjunior‎, 01-02-2022 08:06 PM
    3 Attachment(s)
    • 6
    • 245
    AliGW
    01-03-2022, 05:39 AM Go to last post

  28. [SOLVED] Extracting the 1 level lower part numbers based on Level numbers in multi level BoM

    Started by Sekars‎, 01-03-2022 01:22 AM
    2 Attachment(s)
    • 4
    • 466
    Sekars
    01-03-2022, 05:35 AM Go to last post

  29. [SOLVED] How to use named range in a formula?

    Started by mstgier‎, 01-03-2022 04:44 AM
    defined range, named range 4 Attachment(s)
    • 12
    • 304
    mstgier
    01-03-2022, 05:14 AM Go to last post

  30. [SOLVED] How to arrange the number of the year and month according to cell A1

    Started by choletseng‎, 01-02-2022 07:10 PM
    2 Attachment(s)
    • 6
    • 287
    choletseng
    01-03-2022, 04:40 AM Go to last post

  31. Question [SOLVED] Conditional formatting based on sum of values with the same entries in another column

    Started by Mikaill‎, 12-30-2021 06:36 AM
    changing variables, conditional formatting, multiple columns of data, multiple rows of data, table 3 Attachment(s)
    • 6
    • 485
    Mikaill
    01-03-2022, 04:31 AM Go to last post

  32. [SOLVED] Populating the part numbers based on Level numbers in multi level BoM

    Started by Sekars‎, 12-31-2021 10:51 AM
    2 Attachment(s)
    • 8
    • 418
    JohnTopley
    01-03-2022, 04:12 AM Go to last post

  33. Moved: Needing Foratting formula to set time to 24 hours

    Started by JJFletcher‎, 01-02-2022 08:36 PM
    •  
    •  

  34. beginners question combining data if a name matches

    Started by jamie1970‎, 01-01-2022 10:52 PM
    1 Attachment(s)
    • 2
    • 219
    jamie1970
    01-02-2022, 07:50 PM Go to last post

  35. [SOLVED] How do I extract a value if another cell is TRUE?

    Started by hartwith‎, 08-30-2021 07:40 AM
    2 Attachment(s)
    • 6
    • 295
    Glenn Kennedy
    01-02-2022, 03:23 PM Go to last post

  36. hyperlink formula

    Started by Undo‎, 01-02-2022 02:02 PM
    • 4
    • 202
    Glenn Kennedy
    01-02-2022, 02:28 PM Go to last post

  37. [SOLVED] Finding a value based on three criteria (two in a separate column, one in a separate row)

    Started by sepehr485‎, 12-21-2021 03:38 PM
    1 Attachment(s)
    • 7
    • 432
    FlameRetired
    01-02-2022, 02:16 PM Go to last post

  38. [SOLVED] Formula for multiple conditions

    Started by rizwanulhasan‎, 01-01-2022 01:17 PM
    6 Attachment(s)
    • 10
    • 361
    etaf
    01-02-2022, 12:27 PM Go to last post

  39. [SOLVED] index match not always returning data

    Started by chriswrcg‎, 01-02-2022 10:34 AM
    3 Attachment(s)
    • 3
    • 244
    JohnTopley
    01-02-2022, 12:07 PM Go to last post

  40. I want to pull data from one column that is filtered by two criteria using FILTER

    Started by Tensionhead‎, 01-01-2022 09:31 PM
    • 3
    • 219
    Gregb11
    01-02-2022, 11:10 AM Go to last post

  41. How to convert csv-data to new sheet?

    Started by luukos97‎, 01-01-2022 01:46 PM
    3 Attachment(s)
    • 6
    • 321
    luukos97
    01-02-2022, 10:07 AM Go to last post

  42. [SOLVED] Dynamic Column reference in filter command?

    Started by PrimePorkchop‎, 12-31-2021 06:26 AM
    2 Attachment(s)
    • 4
    • 278
    Bo_Ry
    01-02-2022, 10:00 AM Go to last post

  43. [SOLVED] how to add data from another sheet -vlookup

    Started by sumesh56‎, 01-01-2022 11:54 PM
    1 Attachment(s)
    • 4
    • 225
    sumesh56
    01-02-2022, 09:46 AM Go to last post

  44. Unhappy [SOLVED] EOMonth issue

    Started by wildecoyote1966‎, 12-31-2021 12:00 AM
    accounting, finance, formula 3 Attachment(s)
    • 15
    • 609
    JeteMc
    01-02-2022, 09:45 AM Go to last post

  45. Conditional WORKDAY formula

    Started by rizwanulhasan‎, 01-01-2022 01:37 PM
    4 Attachment(s)
    • 7
    • 417
    Glenn Kennedy
    01-02-2022, 04:16 AM Go to last post

  46. [SOLVED] Populate Based On Criteria

    Started by Kumara_faith‎, 12-31-2021 01:37 PM
    2 Attachment(s)
    • 4
    • 285
    Glenn Kennedy
    01-02-2022, 04:10 AM Go to last post

  47. Question [SOLVED] Problem formatting time from an XML Document

    Started by keenanmurray‎, 01-01-2022 09:38 PM
    duration, summing time, time, time formatting 1 Attachment(s)
    • 2
    • 328
    keenanmurray
    01-02-2022, 01:37 AM Go to last post

  48. Sum of one column on to sheet 2

    Started by ZipFunk‎, 01-01-2022 10:37 PM
    • 2
    • 214
    ZipFunk
    01-01-2022, 11:11 PM Go to last post

  49. How to set up conditional formatting based on another tab

    Started by kyber‎, 12-29-2021 03:29 PM
    1 Attachment(s)
    • 8
    • 313
    JeteMc
    01-01-2022, 02:58 PM Go to last post

  50. count if names match

    Started by MOUNIR75‎, 01-01-2022 02:46 PM
    • 2
    • 229
    etaf
    01-01-2022, 02:54 PM Go to last post
+ Post New Thread
Page 389 of 5627 FirstFirst ... 389 ...

Forum Information and Options

Users Browsing this Forum

There are currently 77 users browsing this forum. (2 members & 75 guests)

  1. TMS

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