+ Post New Thread
Page 510 of 5617 FirstFirst ... 510 ...
Threads 25451 to 25500 of 280809

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

  1. Calculating Difference (in days) between date ONLY IF both cells have date

    Started by howe7032‎, 04-20-2021 03:58 PM
    1 Attachment(s)
    • 2
    • 408
    hrlngrv
    04-20-2021, 06:47 PM Go to last post

  2. [SOLVED] average last 8 values of a columns as new numbers entering

    Started by Excl3454‎, 04-19-2021 03:38 PM
    average dynamic, offset column, offset formula 3 Attachment(s)
    • 8
    • 463
    Excl3454
    04-20-2021, 06:13 PM Go to last post

  3. Re-Arrange Table Data

    Started by dtpunshon‎, 04-20-2021 04:42 PM
    1 Attachment(s)
    • 1
    • 279
    alansidman
    04-20-2021, 06:13 PM Go to last post

  4. Rows 10-59, if Col Z has value, list corresponding cell in Col Y & Col AA, concatenated

    Started by gameoverman‎, 04-19-2021 06:26 AM
    2 Attachment(s)
    • 13
    • 420
    gameoverman
    04-20-2021, 06:08 PM Go to last post

  5. [SOLVED] Add leading zero's

    Started by sick stigma‎, 04-20-2021 04:09 PM
    1 Attachment(s)
    • 1
    • 263
    MrShorty
    04-20-2021, 04:28 PM Go to last post

  6. lookup a value from another sheet, copy and paste the results in another sheet

    Started by sniper1‎, 04-20-2021 03:03 PM
    1 Attachment(s)
    • 1
    • 261
    JohnTopley
    04-20-2021, 03:26 PM Go to last post

  7. Please help - School Project - Trying to setup function.

    Started by Enigma909‎, 04-19-2021 10:38 PM
    2 Attachment(s)
    • 10
    • 450
    Enigma909
    04-20-2021, 03:25 PM Go to last post

  8. [SOLVED] Removing the last part of an ID from when it starts with a letter at the end.

    Started by mightybracket123‎, 04-15-2021 11:17 AM
    4 Attachment(s)
    • 9
    • 363
    FlameRetired
    04-20-2021, 03:17 PM Go to last post

  9. [SOLVED] If statement - 3 conditions

    Started by Iappreciate‎, 04-20-2021 12:33 PM
    • 5
    • 320
    JohnTopley
    04-20-2021, 02:33 PM Go to last post

  10. Unhappy [SOLVED] Count cells based on formula results Dates vs Currency

    Started by MarcusAD79‎, 04-19-2021 10:24 PM
    count, sum 1 Attachment(s)
    • 5
    • 518
    JohnTopley
    04-20-2021, 02:18 PM Go to last post

  11. [SOLVED] Build Delimited List from Column values

    Started by mmsstthomas‎, 04-20-2021 12:01 PM
    delimited list 2 Attachment(s)
    • 9
    • 451
    Fluff13
    04-20-2021, 02:04 PM Go to last post

  12. Return possible permutations

    Started by Corne Rademan‎, 04-20-2021 12:31 PM
    • 1
    • 198
    JohnTopley
    04-20-2021, 12:51 PM Go to last post

  13. Question [SOLVED] changeable date from tab one auto mark on a calendar in tab 2

    Started by tnjone2‎, 04-14-2021 10:32 AM
    calendar 2 Attachment(s)
    • 4
    • 510
    tnjone2
    04-20-2021, 12:39 PM Go to last post

  14. Formula to identify Segments of text and percentages

    Started by BrianJS‎, 04-20-2021 07:23 AM
    formula, vba 5 Attachment(s)
    • 12
    • 411
    Glenn Kennedy
    04-20-2021, 12:21 PM Go to last post

  15. [SOLVED] Formula for multiple currency conversions

    Started by Tally04‎, 04-20-2021 07:44 AM
    currency, exchange rate 2 Attachment(s)
    • 5
    • 445
    JohnTopley
    04-20-2021, 11:59 AM Go to last post

  16. [SOLVED] Pulling out a value from a string

    Started by kimi01‎, 04-20-2021 10:59 AM
    formuals, formula assistence
    • 6
    • 341
    kimi01
    04-20-2021, 11:55 AM Go to last post

  17. [SOLVED] Rept value by count x in rows

    Started by daboho‎, 04-19-2021 06:51 PM
    3 Attachment(s)
    • 3
    • 357
    daboho
    04-20-2021, 11:34 AM Go to last post

  18. Lightbulb [SOLVED] find top highest / largest values on the basis of criteria

    Started by sanjuss2‎, 04-20-2021 10:05 AM
    2 Attachment(s)
    • 3
    • 260
    sanjuss2
    04-20-2021, 10:40 AM Go to last post

  19. [SOLVED] SUMIF with column & row header criteria

    Started by maxi0009in‎, 04-20-2021 09:36 AM
    sumifs & dates, sumifs and and formula 1 Attachment(s)
    • 3
    • 322
    JohnTopley
    04-20-2021, 10:40 AM Go to last post

  20. MID Fonction from right until a character

    Started by Bastien13R‎, 04-19-2021 12:33 PM
    excel, excel & formula, issue, mid and right function 3 Attachment(s)
    • 9
    • 559
    Glenn Kennedy
    04-20-2021, 10:15 AM Go to last post

  21. [SOLVED] Headcount

    Started by sonu1975‎, 04-19-2021 07:27 AM
    3 Attachment(s)
    • 8
    • 364
    sonu1975
    04-20-2021, 10:04 AM Go to last post

  22. [SOLVED] Getting latest information from one sheet to another.

    Started by ghanta28‎, 04-19-2021 04:23 PM
    2 Attachment(s)
    • 3
    • 291
    Glenn Kennedy
    04-20-2021, 10:03 AM Go to last post

  23. [SOLVED] Min if not zero with another condition

    Started by hanif‎, 04-20-2021 09:30 AM
    • 1
    • 223
    hanif
    04-20-2021, 09:35 AM Go to last post

  24. [SOLVED] Multiply, Round, and then divide, multiple sumif formulas

    Started by T.Turner‎, 04-20-2021 07:53 AM
    1 Attachment(s)
    • 4
    • 1,017
    JohnTopley
    04-20-2021, 09:27 AM Go to last post

  25. Question [SOLVED] How to deal with empty Cells / Errors

    Started by TheFaltor‎, 04-20-2021 06:55 AM
    1 Attachment(s)
    • 8
    • 301
    JohnTopley
    04-20-2021, 08:36 AM Go to last post

  26. Auto Strikethrough the rest of word

    Started by KCTOH‎, 04-13-2021 12:29 PM
    1 Attachment(s)
    • 3
    • 240
    KCTOH
    04-20-2021, 08:31 AM Go to last post

  27. Sorting with Text

    Started by Eric Tsang‎, 04-20-2021 05:32 AM
    2 Attachment(s)
    • 3
    • 227
    Eric Tsang
    04-20-2021, 08:25 AM Go to last post

  28. [SOLVED] Return to K3: value either from J3 or G3 and if there is no value, use F3

    Started by Tsinos‎, 04-20-2021 04:18 AM
    return value 2 Attachment(s)
    • 6
    • 694
    Tsinos
    04-20-2021, 07:45 AM Go to last post

  29. Question Find 3 character value throughout concatened string and replace false matches with blank

    Started by therealdees‎, 04-19-2021 08:10 PM
    2 Attachment(s)
    • 4
    • 301
    therealdees
    04-20-2021, 07:37 AM Go to last post

  30. Exclamation MATCH returning #NA

    Started by excelguyb‎, 04-20-2021 03:49 AM
    excel, formulas, formulas & functions, match, match & index 5 Attachment(s)
    • 5
    • 569
    JohnTopley
    04-20-2021, 04:52 AM Go to last post

  31. Conditional Correlation function

    Started by Gertie21‎, 04-19-2021 06:40 PM
    2 Attachment(s)
    • 1
    • 623
    kvsrinivasamurthy
    04-20-2021, 02:47 AM Go to last post

  32. How to sumif with criteria

    Started by lalaarif1‎, 04-18-2021 01:23 PM
    4 Attachment(s)
    • 11
    • 462
    JohnTopley
    04-20-2021, 02:31 AM Go to last post

  33. [SOLVED] sumifs with extra columns

    Started by rayted‎, 04-19-2021 10:52 PM
    sumif 2 Attachment(s)
    • 4
    • 421
    rayted
    04-20-2021, 02:21 AM Go to last post

  34. Smile Fomula to return diff results based on criteria?

    Started by Lozza1‎, 04-15-2021 11:56 PM
    1 Attachment(s)
    • 7
    • 370
    FDibbins
    04-20-2021, 01:48 AM Go to last post

  35. Formula to summarize the sales of items on a promo based on date range

    Started by Nowherefast74‎, 04-19-2021 02:32 PM
    1 Attachment(s)
    • 4
    • 326
    JohnTopley
    04-20-2021, 01:34 AM Go to last post

  36. Vlookup & search function

    Started by itsmeara‎, 04-20-2021 12:08 AM
    search & extract, vlookup
    • 1
    • 321
    alansidman
    04-20-2021, 12:18 AM Go to last post

  37. totally unique cells

    Started by Karen Therapy‎, 04-19-2021 10:13 PM
    1 Attachment(s)
    • 1
    • 202
    bebo021999
    04-19-2021, 11:12 PM Go to last post

  38. Question Formula to determine which cells to format in multiple, separate cells

    Started by Justalex123‎, 04-14-2021 10:29 AM
    formulas 4 Attachment(s)
    • 6
    • 415
    JeteMc
    04-19-2021, 09:46 PM Go to last post

  39. [SOLVED] Help in a very simple sum formula

    Started by Alexisgarci‎, 04-19-2021 06:49 PM
    • 1
    • 245
    Alexisgarci
    04-19-2021, 07:27 PM Go to last post

  40. Finding specific cells adjacent value in formula

    Started by eriocreese20‎, 04-14-2021 05:19 PM
    • 4
    • 324
    eriocreese20
    04-19-2021, 07:08 PM Go to last post

  41. Filter Formula Help

    Started by Timmer2005‎, 04-19-2021 05:55 PM
    • 0
    • 297
    Timmer2005
    04-19-2021, 05:55 PM Go to last post

  42. [SOLVED] Get Total of Specific Background Colored Cells

    Started by jimjones1958‎, 04-19-2021 02:03 PM
    background color, total cumulative 2 Attachment(s)
    • 3
    • 457
    alansidman
    04-19-2021, 05:42 PM Go to last post

  43. [SOLVED] 4 digit julian date

    Started by centenaro‎, 04-19-2021 11:41 AM
    1 Attachment(s)
    • 8
    • 6,649
    6StringJazzer
    04-19-2021, 05:29 PM Go to last post

  44. Angry DURATION, YIELD, PRICE for monthly frequency (12)

    Started by jcc3508‎, 01-09-2015 10:47 AM
    • 5
    • 11,842
    midhenry
    04-19-2021, 04:30 PM Go to last post

  45. Angry how to get VLookup to pick the second row when the first row is blank

    Started by ESIERRA44‎, 04-17-2021 11:37 AM
    help challenging problem, vlook up 4 Attachment(s)
    • 19
    • 785
    ESIERRA44
    04-19-2021, 02:39 PM Go to last post

  46. [SOLVED] SUMPRODUCT to look for dates?

    Started by GreenGiant117‎, 04-19-2021 09:32 AM
    1 Attachment(s)
    • 2
    • 216
    GreenGiant117
    04-19-2021, 02:02 PM Go to last post

  47. [SOLVED] Multiple Data Validations

    Started by abhi_jain80‎, 04-18-2021 05:57 PM
    #datavalidation, #excel 1 Attachment(s)
    • 3
    • 306
    abhi_jain80
    04-19-2021, 01:47 PM Go to last post

  48. [SOLVED] Count duplicate values if they appear in the same month

    Started by AnnieMM‎, 04-18-2021 09:43 AM
    4 Attachment(s)
    • 12
    • 636
    Vraag en antwoord
    04-19-2021, 01:32 PM Go to last post

  49. [SOLVED] Interpolated data look-up in xls sheet using 4 variables. How to do this?

    Started by FlyingRoland‎, 04-17-2021 02:15 PM
    6 Attachment(s)
    • 8
    • 496
    shg
    04-19-2021, 12:35 PM Go to last post

  50. Help with if than

    Started by bobeknr1‎, 04-18-2021 07:57 PM
    • 13
    • 327
    ChemistB
    04-19-2021, 12:24 PM Go to last post
+ Post New Thread
Page 510 of 5617 FirstFirst ... 510 ...

Forum Information and Options

Users Browsing this Forum

There are currently 52 users browsing this forum. (2 members & 50 guests)

  1. 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