+ Post New Thread
Page 451 of 5613 FirstFirst ... 451 ...
Threads 22501 to 22550 of 280650

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

  1. Thumbs up [SOLVED] extract text form text string( extract 5 charactors in front of all left parenthese)

    Started by happyexcel2021‎, 07-28-2021 04:24 PM
    1 Attachment(s)
    • 4
    • 374
    JeteMc
    07-30-2021, 06:05 PM Go to last post

  2. stock scan formula

    Started by jay.sagar19‎, 07-29-2021 01:35 PM
    • 2
    • 373
    FlameRetired
    07-30-2021, 04:06 PM Go to last post

  3. [SOLVED] Formulas not remaining with correct rows after sort

    Started by joshdog13‎, 07-28-2021 01:05 PM
    2 Attachment(s)
    • 15
    • 535
    joshdog13
    07-30-2021, 03:51 PM Go to last post

  4. [SOLVED] converting a countifs referencing part of the formula to a indirect countifs

    Started by DEEARO‎, 07-30-2021 11:51 AM
    • 4
    • 442
    JohnTopley
    07-30-2021, 03:17 PM Go to last post

  5. Exclamation Treat 0 and 00 as two different values

    Started by ajoy123rocks‎, 07-30-2021 08:47 AM
    data validation formula, duplicate cell contents
    • 4
    • 334
    FlameRetired
    07-30-2021, 02:02 PM Go to last post

  6. [SOLVED] Conditional divison based on cells result

    Started by rohit_35‎, 07-20-2021 10:25 AM
    1 Attachment(s)
    • 12
    • 341
    rohit_35
    07-30-2021, 12:35 PM Go to last post

  7. want to spin words in excell cell randomly need formula thanks

    Started by guatekman9‎, 07-30-2021 11:20 AM
    • 1
    • 168
    JohnTopley
    07-30-2021, 11:25 AM Go to last post

  8. [SOLVED] Index/Match only returning first found from list

    Started by Darkcloud617‎, 07-30-2021 10:05 AM
    formula, index, match, table 1 Attachment(s)
    • 5
    • 494
    AliGW
    07-30-2021, 11:12 AM Go to last post

  9. Exclamation Data validation for check boxes

    Started by ajoy123rocks‎, 07-30-2021 08:52 AM
    • 1
    • 204
    AliGW
    07-30-2021, 11:07 AM Go to last post

  10. Post The Academic Financial Year

    Started by Stegman‎, 07-30-2021 10:30 AM
    • 3
    • 195
    AliGW
    07-30-2021, 11:00 AM Go to last post

  11. Lightbulb [SOLVED] Get Closest upper value from single criteria

    Started by sanjuss2‎, 07-29-2021 12:30 PM
    2 Attachment(s)
    • 2
    • 210
    sanjuss2
    07-30-2021, 10:40 AM Go to last post

  12. Conditional divison based on cells result

    Started by rohit_35‎, 07-30-2021 10:19 AM
    • 1
    • 188
    AliGW
    07-30-2021, 10:24 AM Go to last post

  13. Need to reset one variable against the value of another

    Started by spongmonger‎, 07-30-2021 10:16 AM
    • 2
    • 186
    TMS
    07-30-2021, 10:20 AM Go to last post

  14. Date overlap from a range of dates

    Started by thbutterflycollector‎, 07-30-2021 05:39 AM
    2 Attachment(s)
    • 7
    • 260
    thbutterflycollector
    07-30-2021, 10:06 AM Go to last post

  15. Post [SOLVED] Rearrange name

    Started by vani2004‎, 07-30-2021 09:10 AM
    rearrange name
    • 8
    • 202
    vani2004
    07-30-2021, 09:57 AM Go to last post

  16. Table to sort & display the last 30 results

    Started by cableghost‎, 07-29-2021 10:00 PM
    auto populate, max 2 Attachment(s)
    • 4
    • 378
    cableghost
    07-30-2021, 08:31 AM Go to last post

  17. [SOLVED] Find the most continuous sum and the number must be greater than 0

    Started by rayhen‎, 07-30-2021 04:51 AM
    1 Attachment(s)
    • 9
    • 271
    rayhen
    07-30-2021, 07:09 AM Go to last post

  18. [SOLVED] Mathematical formula but result in a dirrerent cell

    Started by Senoy‎, 07-30-2021 03:23 AM
    4 Attachment(s)
    • 14
    • 285
    Senoy
    07-30-2021, 04:50 AM Go to last post

  19. [SOLVED] Automatically summing weeks into months

    Started by as9178‎, 07-30-2021 01:45 AM
    4 Attachment(s)
    • 15
    • 323
    AliGW
    07-30-2021, 03:34 AM Go to last post

  20. Question [SOLVED] Formula to return all rows that apply

    Started by Denise0618‎, 07-29-2021 03:42 PM
    1 Attachment(s)
    • 4
    • 233
    Limor_OP
    07-30-2021, 03:02 AM Go to last post

  21. [SOLVED] How to get filtered list from sheet1 based on cell input in sheet2.

    Started by RajuN‎, 07-29-2021 08:52 AM
    1 Attachment(s)
    • 9
    • 344
    JohnTopley
    07-30-2021, 02:58 AM Go to last post

  22. [SOLVED] Help with VLOOKUP across different sheets based on criteria

    Started by adonl‎, 07-30-2021 02:21 AM
    help a dummy needed, vlookup 1 Attachment(s)
    • 3
    • 314
    AliGW
    07-30-2021, 02:52 AM Go to last post

  23. Graded round robin needed

    Started by PICKLEBALLER‎, 07-30-2021 02:42 AM
    pickleball, round robin
    • 1
    • 288
    AliGW
    07-30-2021, 02:45 AM Go to last post

  24. Trying to interpolate a table

    Started by curry767‎, 07-11-2021 01:18 AM
    16 Attachment(s)
    • 56
    • 737
    josephteh
    07-30-2021, 02:33 AM Go to last post

  25. [SOLVED] Sorting Numbers as a Text in Ascending Order

    Started by T.I.‎, 07-28-2021 09:44 AM
    2 Attachment(s)
    • 5
    • 405
    wk9128
    07-30-2021, 01:59 AM Go to last post

  26. [SOLVED] If formula with Partial Match

    Started by Ajay45822‎, 07-29-2021 06:34 AM
    3 Attachment(s)
    • 9
    • 290
    Ajay45822
    07-30-2021, 01:46 AM Go to last post

  27. =FILTER function not refreshing properly

    Started by shreksbro‎, 07-30-2021 12:57 AM
    • 5
    • 719
    AliGW
    07-30-2021, 01:33 AM Go to last post

  28. [SOLVED] SUM from VLOOKUP result multiple rows multiple columns

    Started by BrianOfNazareth‎, 07-29-2021 09:48 AM
    1 Attachment(s)
    • 3
    • 382
    AliGW
    07-30-2021, 12:10 AM Go to last post

  29. Duplicates in RANK.

    Started by hp99‎, 07-29-2021 05:25 PM
    duplicates, excel, rank 2 Attachment(s)
    • 2
    • 523
    josephteh
    07-29-2021, 11:05 PM Go to last post

  30. multiple entries from one source

    Started by chance762‎, 07-29-2021 08:32 PM
    1 Attachment(s)
    • 2
    • 185
    alansidman
    07-29-2021, 10:57 PM Go to last post

  31. [SOLVED] Combining Date and Time in One Cell

    Started by BazzaBoy‎, 07-29-2021 08:47 PM
    1 Attachment(s)
    • 3
    • 194
    BazzaBoy
    07-29-2021, 09:41 PM Go to last post

  32. Virtual pivot table?

    Started by Mr. Z‎, 07-22-2021 12:26 PM
    1 Attachment(s)
    • 6
    • 390
    Mr. Z
    07-29-2021, 09:18 PM Go to last post

  33. Moved: IMPORTXML query returning redundant data in several cells

    Started by ISAO‎, 07-29-2021 05:41 PM
    •  
    •  

  34. Exclamation How do I add multiple events under the date from a table with range of dates?

    Started by excel_help_97‎, 07-22-2021 05:47 PM
    calendar formula 4 Attachment(s)
    • 3
    • 392
    JeteMc
    07-29-2021, 06:20 PM Go to last post

  35. Multi-Criteria Table Lookup

    Started by SweetBaboo‎, 07-29-2021 01:38 PM
    2 Attachment(s)
    • 3
    • 266
    SweetBaboo
    07-29-2021, 04:15 PM Go to last post

  36. Help with brushing up formula that copies row data automatically from another sheet

    Started by hionman‎, 07-16-2021 09:31 AM
    formula 12 Attachment(s)
    • 29
    • 773
    JohnTopley
    07-29-2021, 04:08 PM Go to last post

  37. Make an entire row of data follow the lead cell in column A

    Started by chriswrcg‎, 07-29-2021 01:28 PM
    1 Attachment(s)
    • 1
    • 304
    JohnTopley
    07-29-2021, 01:58 PM Go to last post

  38. CONCATENATE 33 rows + characters in between each element

    Started by codeBeast‎, 07-27-2021 11:44 AM
    2 Attachment(s)
    • 3
    • 254
    JeteMc
    07-29-2021, 12:12 PM Go to last post

  39. Pulling specific dates from one sheet into another using data validation drop down

    Started by Streaky‎, 07-29-2021 09:52 AM
    2 Attachment(s)
    • 4
    • 223
    Streaky
    07-29-2021, 11:52 AM Go to last post

  40. [SOLVED] PowerQuery format

    Started by jimmisavage‎, 07-29-2021 10:42 AM
    • 3
    • 252
    jimmisavage
    07-29-2021, 11:40 AM Go to last post

  41. How to add a MTD graph in my dashboard that is made up of daily data ; help!!

    Started by Ascribne‎, 07-28-2021 11:23 AM
    dashboard, mtd 3 Attachment(s)
    • 3
    • 403
    josephteh
    07-29-2021, 11:31 AM Go to last post

  42. Match two columns to multiple other columns, and return another column.

    Started by stranula‎, 07-20-2021 04:37 PM
    2 Attachment(s)
    • 3
    • 303
    stranula
    07-29-2021, 11:24 AM Go to last post

  43. Trying to build a formula to calculate Lunch & Dinner Penalties on a film set

    Started by dgatopga‎, 07-28-2021 04:17 PM
    2 Attachment(s)
    • 6
    • 363
    dgatopga
    07-29-2021, 10:41 AM Go to last post

  44. Question Check to see if nth cell is blank

    Started by Baccawastaken‎, 07-27-2021 06:38 PM
    blank cell, formula
    • 6
    • 685
    davsth
    07-29-2021, 10:33 AM Go to last post

  45. [SOLVED] Check for consecutive upper letters in a cells text

    Started by iustin‎, 07-29-2021 06:46 AM
    3 Attachment(s)
    • 11
    • 706
    iustin
    07-29-2021, 10:14 AM Go to last post

  46. [SOLVED] Remove Data in Bracket from Cells

    Started by woodsedge‎, 07-29-2021 09:34 AM
    • 3
    • 232
    AliGW
    07-29-2021, 09:38 AM Go to last post

  47. [SOLVED] IF and AND Function

    Started by GreenTreee‎, 07-26-2021 04:59 PM
    1 Attachment(s)
    • 6
    • 329
    GreenTreee
    07-29-2021, 09:13 AM Go to last post

  48. [SOLVED] Trying to undersgtand why I am getting an "#NA" error...

    Started by Stu100‎, 07-29-2021 07:39 AM
    1 Attachment(s)
    • 8
    • 265
    AliGW
    07-29-2021, 08:29 AM Go to last post

  49. [SOLVED] Current Streak adding Ties & changing to numerical

    Started by showtimesaints‎, 07-28-2021 08:25 PM
    1 Attachment(s)
    • 10
    • 266
    AliGW
    07-29-2021, 08:10 AM Go to last post

  50. [SOLVED] Help with syntax for SINE & COSINE formula / function

    Started by Malkie‎, 07-29-2021 06:52 AM
    • 5
    • 225
    AliGW
    07-29-2021, 07:34 AM Go to last post
+ Post New Thread
Page 451 of 5613 FirstFirst ... 451 ...

Forum Information and Options

Users Browsing this Forum

There are currently 87 users browsing this forum. (7 members & 80 guests)

  1. aheybruch,
  2. Drexl27,
  3. JCKinNC,
  4. JohnnyB1970,
  5. Nova11,
  6. SparkChaser75,
  7. Talisha Hardy

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