+ Post New Thread
Page 49 of 5614 FirstFirst ... 49 ...
Threads 2401 to 2450 of 280663

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

  1. [SOLVED] Formula to mimic nested "for loops" to loop through two dynamic arrays

    Started by excelwrld‎, 12-20-2023 11:01 PM
    array, array 2d 2 Attachment(s)
    • 5
    • 362
    AliGW
    12-21-2023, 08:44 AM Go to last post

  2. [SOLVED] First Unique based on Start date - PowerQuery Help without Merge

    Started by Yadavgiri‎, 12-19-2023 10:46 AM
    2 Attachment(s)
    • 3
    • 159
    DJunqueira
    12-21-2023, 08:00 AM Go to last post

  3. [SOLVED] Get Count Based on Header and Lookup Value

    Started by mohdabrar‎, 12-21-2023 06:17 AM
    1 Attachment(s)
    • 2
    • 98
    mohdabrar
    12-21-2023, 07:19 AM Go to last post

  4. Tiered pricing formula

    Started by Oliver B‎, 12-21-2023 05:44 AM
    2 Attachment(s)
    • 8
    • 151
    Oliver B
    12-21-2023, 06:21 AM Go to last post

  5. Type words into a single cell and have them arrange into alphabetical order same cell.

    Started by sbarwald‎, 12-13-2023 05:28 PM
    alphabetical order 4 Attachment(s)
    • 6
    • 274
    Glenn Kennedy
    12-21-2023, 05:26 AM Go to last post

  6. [SOLVED] Working out a daily percentage of a monthly total

    Started by sa1ntj0hn‎, 12-21-2023 04:24 AM
    2 Attachment(s)
    • 4
    • 142
    AliGW
    12-21-2023, 05:00 AM Go to last post

  7. [SOLVED] How to get automatically in columns with matches

    Started by Ekac‎, 12-20-2023 01:53 PM
    1 Attachment(s)
    • 3
    • 212
    Ekac
    12-21-2023, 03:12 AM Go to last post

  8. Additional CCP2 deduction formula not working correctly

    Started by Jayeshkumar‎, 12-01-2023 12:02 AM
    1 Attachment(s)
    • 9
    • 593
    Jayeshkumar
    12-20-2023, 09:11 PM Go to last post

  9. INDEX and MATCH not returning proper values

    Started by sndameron‎, 12-20-2023 02:16 PM
    index, match 2 Attachment(s)
    • 11
    • 486
    TMS
    12-20-2023, 08:31 PM Go to last post

  10. Post Transforming Data in Array into Single Column, excluding Blanks

    Started by tubes_excel_novice‎, 12-20-2023 05:27 PM
    1 Attachment(s)
    • 2
    • 134
    DJunqueira
    12-20-2023, 06:06 PM Go to last post

  11. How to Sum first 12 cells in a row once a cell has data.

    Started by andrebr‎, 12-20-2023 03:15 PM
    excel, formula, formula help 2 Attachment(s)
    • 7
    • 257
    Estevaoba
    12-20-2023, 04:25 PM Go to last post

  12. [SOLVED] Count lines in a cell and in an column using SCAN function

    Started by DJunqueira‎, 12-19-2023 05:35 PM
    2 Attachment(s)
    • 13
    • 519
    DJunqueira
    12-20-2023, 02:24 PM Go to last post

  13. [SOLVED] subtotal with multiple criteria and or sumproduct

    Started by Perk1961‎, 12-19-2023 08:35 PM
    4 Attachment(s)
    • 6
    • 275
    windknife
    12-20-2023, 11:59 AM Go to last post

  14. nesting two formulas

    Started by becksintex‎, 12-19-2023 06:43 PM
    • 3
    • 149
    TMS
    12-20-2023, 11:14 AM Go to last post

  15. [SOLVED] Need help with formula within formula for subtotal count

    Started by JMB99‎, 12-20-2023 08:58 AM
    formula countif, formula countif condition 5 Attachment(s)
    • 4
    • 240
    Czeslaw
    12-20-2023, 10:41 AM Go to last post

  16. [SOLVED] IF function help

    Started by quiggdavid‎, 12-20-2023 05:48 AM
    3 Attachment(s)
    • 4
    • 247
    Estevaoba
    12-20-2023, 10:01 AM Go to last post

  17. Question Cumulative and Growth Rate

    Started by AdrinBig‎, 12-19-2023 07:00 PM
    • 4
    • 456
    josephteh
    12-20-2023, 08:08 AM Go to last post

  18. COunt Unique from multiple crieteria

    Started by pmbhome‎, 12-20-2023 05:44 AM
    3 Attachment(s)
    • 13
    • 137
    HansDouwe
    12-20-2023, 06:22 AM Go to last post

  19. [SOLVED] Flip rows Excel 2010

    Started by sasamaribor‎, 12-20-2023 02:51 AM
    4 Attachment(s)
    • 6
    • 212
    sasamaribor
    12-20-2023, 05:27 AM Go to last post

  20. Post [SOLVED] i need a formula to display the specific result

    Started by kartik dogra‎, 12-20-2023 05:07 AM
    1 Attachment(s)
    • 1
    • 143
    shukla.ankur281190
    12-20-2023, 05:24 AM Go to last post

  21. Post create a link base on cell value

    Started by Luigem‎, 12-20-2023 01:02 AM
    excel, hyperlink 3 Attachment(s)
    • 6
    • 178
    ORoos
    12-20-2023, 05:02 AM Go to last post

  22. How can I search multiple columns for Xlookup?

    Started by jackb720‎, 12-17-2023 10:23 AM
    xlookup 4 Attachment(s)
    • 13
    • 403
    CARACALLA
    12-20-2023, 03:38 AM Go to last post

  23. [SOLVED] If Function with multiple criteria

    Started by rikknikk‎, 12-04-2023 11:45 AM
    3 Attachment(s)
    • 6
    • 266
    rikknikk
    12-20-2023, 03:07 AM Go to last post

  24. Need help for counting sales frequency with a year based on Criteria

    Started by GoldenChicken‎, 12-19-2023 11:44 PM
    1 Attachment(s)
    • 3
    • 126
    windknife
    12-20-2023, 01:17 AM Go to last post

  25. Conditional Formatting between 2 tables, with 2 criteria.

    Started by Rukik‎, 12-19-2023 07:22 PM
    conditional formatting 3 Attachment(s)
    • 5
    • 198
    DJunqueira
    12-19-2023, 08:54 PM Go to last post

  26. #ref errors, multiple worksheets, etc.

    Started by JeffWest‎, 12-19-2023 04:05 PM
    1 Attachment(s)
    • 1
    • 115
    6StringJazzer
    12-19-2023, 04:50 PM Go to last post

  27. [SOLVED] get value intersect row/col in table

    Started by guillaume0314‎, 12-19-2023 02:11 PM
    4 Attachment(s)
    • 5
    • 129
    Fluff13
    12-19-2023, 02:52 PM Go to last post

  28. [SOLVED] SUMIFS with date and 1 other criteria

    Started by Newtonus_Prime‎, 12-19-2023 01:15 PM
    1 Attachment(s)
    • 3
    • 185
    TMS
    12-19-2023, 01:59 PM Go to last post

  29. [SOLVED] Formula to Extract Month and Year from Sheet Name

    Started by Howardc1001‎, 12-19-2023 10:08 AM
    2 Attachment(s)
    • 5
    • 170
    6StringJazzer
    12-19-2023, 11:56 AM Go to last post

  30. [SOLVED] Need Formula for price comparison

    Started by raeesasif2022‎, 12-14-2023 10:28 PM
    8 Attachment(s)
    • 21
    • 552
    windknife
    12-19-2023, 10:54 AM Go to last post

  31. [SOLVED] Auto-populating formula's and Data Validation based on 1 cells data validation result

    Started by Newtonus_Prime‎, 12-19-2023 09:38 AM
    1 Attachment(s)
    • 2
    • 188
    Newtonus_Prime
    12-19-2023, 10:21 AM Go to last post

  32. [SOLVED] Lookup PowerQuery without Merge

    Started by Yadavgiri‎, 12-19-2023 08:22 AM
    1 Attachment(s)
    • 4
    • 268
    Yadavgiri
    12-19-2023, 10:11 AM Go to last post

  33. Reduce occurances of data.

    Started by RobRobby‎, 12-19-2023 04:52 AM
    2 Attachment(s)
    • 8
    • 166
    AliGW
    12-19-2023, 09:16 AM Go to last post

  34. [SOLVED] Correct LET formula to remove certain filters

    Started by Dom.Knight‎, 12-19-2023 05:10 AM
    2 Attachment(s)
    • 5
    • 197
    HansDouwe
    12-19-2023, 06:07 AM Go to last post

  35. Pulling data from a merged cell

    Started by bonjon2203‎, 12-19-2023 04:47 AM
    formula
    • 2
    • 167
    TMS
    12-19-2023, 06:02 AM Go to last post

  36. [SOLVED] Getting an OVERALL Status based on TWO Columns

    Started by EXCELBENCH‎, 12-19-2023 01:55 AM
    4 Attachment(s)
    • 8
    • 254
    HansDouwe
    12-19-2023, 04:58 AM Go to last post

  37. CF Highlight Week of the Year

    Started by CDALY0793‎, 12-18-2023 07:59 AM
    2 Attachment(s)
    • 2
    • 168
    josephteh
    12-19-2023, 03:10 AM Go to last post

  38. [SOLVED] Strange behavior with rounding

    Started by Venomous Duck‎, 12-17-2023 06:54 PM
    2 Attachment(s)
    • 11
    • 287
    Venomous Duck
    12-19-2023, 01:46 AM Go to last post

  39. Combine two iferror formula

    Started by Learner1‎, 12-15-2023 04:15 AM
    2 Attachment(s)
    • 6
    • 197
    HansDouwe
    12-19-2023, 12:46 AM Go to last post

  40. [SOLVED] Detecting Someone's Age from Date of Birth

    Started by EdWoods‎, 12-18-2023 08:05 PM
    1 Attachment(s)
    • 6
    • 160
    Sam Capricci
    12-18-2023, 11:55 PM Go to last post

  41. [SOLVED] Formula for making multiple sentences

    Started by MarcosD‎, 12-13-2023 05:08 PM
    combination generator, merging, sentences 3 Attachment(s)
    • 8
    • 292
    windknife
    12-18-2023, 10:31 PM Go to last post

  42. [SOLVED] Countifs Excluding Certain Items

    Started by Howardc1001‎, 12-18-2023 09:40 PM
    2 Attachment(s)
    • 3
    • 91
    HansDouwe
    12-18-2023, 10:22 PM Go to last post

  43. [SOLVED] Forumla Doesn't Auto-Increment Correctly

    Started by coltonyyz‎, 12-18-2023 09:12 PM
    excel index row
    • 4
    • 163
    TMS
    12-18-2023, 10:11 PM Go to last post

  44. [SOLVED] IF statement with four columns to choose from

    Started by RookA1‎, 12-18-2023 02:35 PM
    if statement, ifs, multiple columns 2 Attachment(s)
    • 5
    • 170
    HansDouwe
    12-18-2023, 08:35 PM Go to last post

  45. Combine links of images with corresponding products

    Started by Judgin‎, 12-12-2023 04:54 AM
    2 Attachment(s)
    • 2
    • 209
    Judgin
    12-18-2023, 04:26 PM Go to last post

  46. [SOLVED] Sumifs with Multiple Criteria with Dates

    Started by BakersDozen‎, 12-15-2023 12:44 PM
    2 Attachment(s)
    • 3
    • 205
    HansDouwe
    12-18-2023, 02:28 PM Go to last post

  47. Filter Function Issue - Help?!

    Started by GiftedKB‎, 12-18-2023 01:14 PM
    filter, function, match, search 1 Attachment(s)
    • 1
    • 115
    AliGW
    12-18-2023, 01:28 PM Go to last post

  48. [SOLVED] calculate depreciation between two assets during the month

    Started by Megatronv‎, 12-13-2023 06:16 AM
    2 Attachment(s)
    • 5
    • 294
    JeteMc
    12-18-2023, 12:43 PM Go to last post

  49. [SOLVED] Partial Text Lookup/Search with Partial Text in Source

    Started by MonteCat1‎, 12-15-2023 04:17 PM
    3 Attachment(s)
    • 4
    • 443
    MonteCat1
    12-18-2023, 12:37 PM Go to last post

  50. INDEX MATCH not functioning

    Started by toxtricity‎, 12-18-2023 12:21 PM
    #indexmatch
    • 2
    • 130
    TMS
    12-18-2023, 12:26 PM Go to last post
+ Post New Thread
Page 49 of 5614 FirstFirst ... 49 ...

Forum Information and Options

Users Browsing this Forum

There are currently 74 users browsing this forum. (5 members & 69 guests)

  1. AliGW,
  2. kostasgnc,
  3. Narbar_123

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