+ Post New Thread
Page 390 of 5619 FirstFirst ... 390 ...
Threads 19451 to 19500 of 280939

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

  1. Lightbulb Find matching cell contents in a 2D array and returning the rows in a horizontal array

    Started by MacClaus‎, 12-11-2021 03:46 AM
    4 Attachment(s)
    • 7
    • 573
    AliGW
    12-11-2021, 06:45 AM Go to last post

  2. [SOLVED] Formula Required for LATE IN, EARLY OUT, ON TIME

    Started by raeesasif2022‎, 12-09-2021 03:46 PM
    1 Attachment(s)
    • 2
    • 665
    raeesasif2022
    12-11-2021, 06:27 AM Go to last post

  3. [SOLVED] Excel Formula - Flag the first duplicate

    Started by Abdur_rahman‎, 12-11-2021 04:25 AM
    2 Attachment(s)
    • 4
    • 344
    BadlySpelledBuoy
    12-11-2021, 05:09 AM Go to last post

  4. Smile [SOLVED] fill blank cells in a column by duplicating values of first unique instance

    Started by hasan mougharbel‎, 12-11-2021 03:00 AM
    1 Attachment(s)
    • 2
    • 246
    hasan mougharbel
    12-11-2021, 03:46 AM Go to last post

  5. Create a Drop Down List Contingent on Date Entered in Separate Cell

    Started by mattiek‎, 12-10-2021 07:51 PM
    2 Attachment(s)
    • 1
    • 233
    JohnTopley
    12-11-2021, 03:43 AM Go to last post

  6. How to get unique text value from column values?

    Started by genetist‎, 12-11-2021 12:23 AM
    1 Attachment(s)
    • 2
    • 221
    Czeslaw
    12-11-2021, 02:37 AM Go to last post

  7. IF VLOOKUP LARGE combination

    Started by JR1996‎, 07-07-2021 02:28 AM
    3 Attachment(s)
    • 8
    • 329
    Gregb11
    12-10-2021, 11:56 PM Go to last post

  8. [SOLVED] Problem using MID function to parse a string with slash "/"

    Started by glentall‎, 12-10-2021 11:14 AM
    mid function, parse error, slash 8 Attachment(s)
    • 6
    • 670
    TMS
    12-10-2021, 08:39 PM Go to last post

  9. Lightbulb [SOLVED] Excel stubbornly will not return value of cell (UNLESS FILE IS SAVED)

    Started by HollowMan‎, 12-10-2021 01:07 PM
    1 Attachment(s)
    • 3
    • 174
    Pete_UK
    12-10-2021, 08:38 PM Go to last post

  10. [SOLVED] Formula Help with Dynamic Amortization Schedule

    Started by millyactual‎, 12-10-2021 05:57 PM
    1 Attachment(s)
    • 0
    • 312
    millyactual
    12-10-2021, 05:57 PM Go to last post

  11. Formula to identify column heading

    Started by Rogo1107‎, 12-10-2021 05:10 PM
    • 2
    • 198
    Fluff13
    12-10-2021, 05:54 PM Go to last post

  12. [SOLVED] How to count red text

    Started by kyber‎, 12-10-2021 04:11 PM
    1 Attachment(s)
    • 3
    • 216
    TMS
    12-10-2021, 04:37 PM Go to last post

  13. Need help around correct formulae nested if or index for attached query

    Started by sui898‎, 12-10-2021 01:21 PM
    2 Attachment(s)
    • 1
    • 202
    Bernie Deitrick
    12-10-2021, 02:18 PM Go to last post

  14. [SOLVED] Dynamic array difficulty: LOOKUP/SUMIF/UNIQUE/FILTER/XLOOKUP based on multiple criteria

    Started by Rabk‎, 12-10-2021 12:22 AM
    dynamic array, sumif, unique, xlookup 4 Attachment(s)
    • 7
    • 827
    Glenn Kennedy
    12-10-2021, 02:17 PM Go to last post

  15. IF function using dates

    Started by Jonmck‎, 12-10-2021 12:47 PM
    • 1
    • 221
    TMS
    12-10-2021, 02:07 PM Go to last post

  16. Pull Data from other Tabs into a Summary Tab only if certain data selected in Column

    Started by ClairW34‎, 12-06-2021 08:32 PM
    2 Attachment(s)
    • 3
    • 260
    FlameRetired
    12-10-2021, 01:56 PM Go to last post

  17. Question [SOLVED] How to - Show Cell Contents with COUNTIFS formula?

    Started by Abbo_‎, 12-10-2021 07:18 AM
    1 Attachment(s)
    • 4
    • 241
    TMS
    12-10-2021, 01:46 PM Go to last post

  18. VLOOKUP across multiple sheets

    Started by catley666‎, 12-05-2021 10:00 AM
    7 Attachment(s)
    • 36
    • 759
    JohnTopley
    12-10-2021, 12:50 PM Go to last post

  19. [SOLVED] Strange #REF issue

    Started by Funky dingo 41‎, 12-10-2021 08:57 AM
    • 7
    • 311
    Funky dingo 41
    12-10-2021, 12:23 PM Go to last post

  20. [SOLVED] How Can I Remove Numbers From A Cell?

    Started by zanshin777‎, 12-09-2021 12:45 PM
    2 Attachment(s)
    • 5
    • 287
    zanshin777
    12-10-2021, 12:11 PM Go to last post

  21. IF formula to calculate values between a range of dates

    Started by jerryong‎, 12-10-2021 12:43 AM
    1 Attachment(s)
    • 3
    • 275
    Glenn Kennedy
    12-10-2021, 12:05 PM Go to last post

  22. Pulling multiple data from a column

    Started by Smashsmash‎, 12-09-2021 06:33 PM
    1 Attachment(s)
    • 3
    • 253
    Glenn Kennedy
    12-10-2021, 11:45 AM Go to last post

  23. Find duplicate values with NON-MATCHING values in another column

    Started by spaich711‎, 12-09-2021 01:40 PM
    3 Attachment(s)
    • 7
    • 334
    PietBom
    12-10-2021, 10:53 AM Go to last post

  24. [SOLVED] Need help calculating totals between dates

    Started by waldzwastaken‎, 12-10-2021 09:22 AM
    1 Attachment(s)
    • 6
    • 234
    AliGW
    12-10-2021, 10:45 AM Go to last post

  25. [SOLVED] Multi IF with filter function

    Started by mazan2010‎, 12-10-2021 09:46 AM
    1 Attachment(s)
    • 5
    • 238
    Fluff13
    12-10-2021, 10:36 AM Go to last post

  26. [SOLVED] How to get the price group to populate once i have chosen the finish from drop-down?

    Started by Purplerattler‎, 12-09-2021 03:36 PM
    1 Attachment(s)
    • 9
    • 261
    JohnTopley
    12-10-2021, 10:29 AM Go to last post

  27. Auto-adjust data to achieve a specific total

    Started by lux aeterna‎, 12-10-2021 10:08 AM
    1 Attachment(s)
    • 0
    • 230
    lux aeterna
    12-10-2021, 10:08 AM Go to last post

  28. Question [SOLVED] Sum Frequency Within a Date Range?

    Started by excel_noob122‎, 12-09-2021 02:01 PM
    frequency, frequency function, sum - range of cells 2 Attachment(s)
    • 4
    • 549
    Fluff13
    12-10-2021, 09:23 AM Go to last post

  29. Split cell value based on number, after every number appereance in cell

    Started by iustin‎, 12-10-2021 06:48 AM
    3 Attachment(s)
    • 4
    • 236
    iustin
    12-10-2021, 08:28 AM Go to last post

  30. [SOLVED] How to simplify Xlookup query with data from multiple sheets

    Started by protexx‎, 12-10-2021 05:05 AM
    • 7
    • 316
    AliGW
    12-10-2021, 06:20 AM Go to last post

  31. IF with SUMPRODUCT from multiple sheets !

    Started by sonu1975‎, 12-08-2021 09:25 AM
    2 Attachment(s)
    • 4
    • 230
    sonu1975
    12-10-2021, 05:12 AM Go to last post

  32. [SOLVED] Adding to an IF Statement or change to IFS statement

    Started by Stenner‎, 12-10-2021 04:44 AM
    1 Attachment(s)
    • 5
    • 204
    TMS
    12-10-2021, 05:01 AM Go to last post

  33. How to compare two columns and make a list with extra product

    Started by akshay6s‎, 12-09-2021 09:28 AM
    2 Attachment(s)
    • 5
    • 253
    TMS
    12-10-2021, 04:11 AM Go to last post

  34. [SOLVED] Running aggregate using dynamic array

    Started by hullez‎, 12-09-2021 03:16 AM
    3 Attachment(s)
    • 5
    • 327
    Glenn Kennedy
    12-10-2021, 03:23 AM Go to last post

  35. [SOLVED] Summing Data With Criteria Q1, till Q2, till Q3 etc...

    Started by Jhon Mustofa‎, 12-09-2021 11:00 AM
    2 Attachment(s)
    • 5
    • 410
    Jhon Mustofa
    12-10-2021, 03:03 AM Go to last post

  36. Tat calculation

    Started by Rushendra‎, 12-09-2021 03:41 AM
    2 Attachment(s)
    • 10
    • 305
    samba_ravi
    12-10-2021, 02:41 AM Go to last post

  37. [SOLVED] Trim cell character to make computation

    Started by chasoe‎, 12-08-2021 11:12 PM
    3 Attachment(s)
    • 8
    • 336
    wk9128
    12-10-2021, 01:39 AM Go to last post

  38. [SOLVED] Returning data from a column, based on a date that references multiple columns and a row

    Started by misgett‎, 12-09-2021 08:02 PM
    2 Attachment(s)
    • 2
    • 255
    misgett
    12-10-2021, 12:12 AM Go to last post

  39. Index and match multiple returns from multiple sheets

    Started by Otawata‎, 12-09-2021 10:39 PM
    • 1
    • 183
    Gregb11
    12-09-2021, 10:49 PM Go to last post

  40. Columns don’t add up

    Started by Testie1‎, 12-08-2021 10:36 PM
    • 12
    • 302
    Testie1
    12-09-2021, 07:58 PM Go to last post

  41. Formula to apply excess cash to outgoing payment

    Started by mp0812‎, 12-07-2021 12:15 AM
    1 Attachment(s)
    • 1
    • 311
    JeteMc
    12-09-2021, 07:10 PM Go to last post

  42. [SOLVED] Sum cells based on contents of cell directly above

    Started by GreenMan36‎, 12-09-2021 04:15 PM
    1 Attachment(s)
    • 3
    • 194
    Fluff13
    12-09-2021, 04:37 PM Go to last post

  43. Macros? Buttons? Inventory Tracking for Sales and Products?

    Started by mark.k.conroy‎, 12-09-2021 03:29 PM
    1 Attachment(s)
    • 3
    • 251
    alansidman
    12-09-2021, 04:34 PM Go to last post

  44. [SOLVED] Excel Division Question

    Started by bmeyer0312‎, 12-09-2021 12:16 PM
    1 Attachment(s)
    • 5
    • 284
    Glenn Kennedy
    12-09-2021, 04:18 PM Go to last post

  45. Temperature forecast - smoothening in excel monthly average

    Started by tos‎, 12-09-2021 10:35 AM
    1 Attachment(s)
    • 3
    • 250
    MrShorty
    12-09-2021, 02:42 PM Go to last post

  46. Find multiple payments and pull details

    Started by MARGI123‎, 12-06-2021 03:53 PM
    1 Attachment(s)
    • 1
    • 244
    JeteMc
    12-09-2021, 01:53 PM Go to last post

  47. Post [SOLVED] Trying to complete Advent of Code 21 in Excel [D2/P2]

    Started by LilGanja1337‎, 12-09-2021 12:16 PM
    2 Attachment(s)
    • 2
    • 230
    Bernie Deitrick
    12-09-2021, 01:20 PM Go to last post

  48. [SOLVED] Conditional Formatting of date ranges from start/ finish dates

    Started by shredder91‎, 12-09-2021 12:37 PM
    2 Attachment(s)
    • 3
    • 196
    Glenn Kennedy
    12-09-2021, 12:51 PM Go to last post

  49. Nested IF Formula

    Started by DavePhil2‎, 12-09-2021 11:42 AM
    2 Attachment(s)
    • 6
    • 262
    DavePhil2
    12-09-2021, 12:09 PM Go to last post

  50. Post Productivity % for individual

    Started by Ma2911‎, 12-06-2021 09:58 AM
    5 Attachment(s)
    • 22
    • 405
    Ma2911
    12-09-2021, 12:04 PM Go to last post
+ Post New Thread
Page 390 of 5619 FirstFirst ... 390 ...

Forum Information and Options

Users Browsing this Forum

There are currently 40 users browsing this forum. (0 members & 40 guests)

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