+ Post New Thread
Page 98 of 5615 FirstFirst ... 98 ...
Threads 4851 to 4900 of 280706

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

  1. [SOLVED] Abbreviate this formula

    Started by mrpb‎, 08-17-2023 02:04 AM
    • 5
    • 151
    AliGW
    08-17-2023, 02:29 AM Go to last post

  2. [SOLVED] sum only values in every winter season

    Started by uqls‎, 08-16-2023 11:11 PM
    5 Attachment(s)
    • 6
    • 190
    Czeslaw
    08-17-2023, 02:29 AM Go to last post

  3. COUNTIFS Formula for Filtered List to Find Unique Values (Ignore Hidden Rows)

    Started by ExcelMeister10520‎, 08-15-2023 08:01 PM
    3 Attachment(s)
    • 4
    • 630
    Glenn Kennedy
    08-17-2023, 01:48 AM Go to last post

  4. [SOLVED] Copy rows from one tab to another where one condition is met

    Started by Paradigmgaming911‎, 08-16-2023 06:41 PM
    2 Attachment(s)
    • 3
    • 195
    azumi
    08-16-2023, 10:36 PM Go to last post

  5. Forecasting Expenses

    Started by ah lee yah‎, 08-16-2023 02:18 PM
    1 Attachment(s)
    • 1
    • 173
    6StringJazzer
    08-16-2023, 10:15 PM Go to last post

  6. Formula for Week Start - Office 16

    Started by InvaderZIM05‎, 08-16-2023 02:36 PM
    1 Attachment(s)
    • 4
    • 181
    Rick Rothstein
    08-16-2023, 08:40 PM Go to last post

  7. [SOLVED] Formula to choose between 2 cells

    Started by BootGuy‎, 08-16-2023 02:12 PM
    2 Attachment(s)
    • 3
    • 147
    6StringJazzer
    08-16-2023, 05:09 PM Go to last post

  8. how to concatenate AND show ranking formulas

    Started by Tony0731‎, 08-15-2023 09:03 AM
    9 Attachment(s)
    • 30
    • 513
    HansDouwe
    08-16-2023, 05:07 PM Go to last post

  9. Insert a new row with value between every record

    Started by aka2023‎, 08-16-2023 09:33 AM
    • 2
    • 252
    aka2023
    08-16-2023, 04:02 PM Go to last post

  10. [SOLVED] Identify clients in a column that fit multi-row criteria

    Started by RookA1‎, 08-16-2023 01:47 PM
    1 Attachment(s)
    • 2
    • 138
    RookA1
    08-16-2023, 03:54 PM Go to last post

  11. Refer to same cell with a formula even if rows added

    Started by dschwichtenberg‎, 08-16-2023 12:49 PM
    google sheets, importrange, linking cells
    • 4
    • 274
    protonLeah
    08-16-2023, 03:26 PM Go to last post

  12. [SOLVED] IF AND formula not working

    Started by Keshy85‎, 08-16-2023 01:54 PM
    1 Attachment(s)
    • 2
    • 187
    Keshy85
    08-16-2023, 03:11 PM Go to last post

  13. XLookup when I don't know lookup column or return value column, just header names

    Started by jomili‎, 08-15-2023 04:14 PM
    3 Attachment(s)
    • 6
    • 237
    jomili
    08-16-2023, 01:16 PM Go to last post

  14. Only run formula if greater than or equal to...

    Started by jrcorwin‎, 08-16-2023 12:38 PM
    1 Attachment(s)
    • 1
    • 144
    protonLeah
    08-16-2023, 12:54 PM Go to last post

  15. Post Columns should not exceed the 60 characters and no words should be split across 2 columns

    Started by Mike1256‎, 08-15-2023 08:55 AM
    excel, excel & formula, excel & if, excel formulas 1 Attachment(s)
    • 3
    • 340
    HansDouwe
    08-16-2023, 12:22 PM Go to last post

  16. Exclamation XLOOKUP advanced problem

    Started by IceQueen85‎, 08-15-2023 07:56 AM
    filter argument, formula assitance, xlookup; multiple results 1 Attachment(s)
    • 3
    • 262
    JeteMc
    08-16-2023, 10:55 AM Go to last post

  17. Post Skip empty rows when importing data from one sheet to other sheet through formula

    Started by Qamer Shehzad‎, 08-16-2023 08:54 AM
    import data 2 Attachment(s)
    • 2
    • 199
    CARACALLA
    08-16-2023, 10:28 AM Go to last post

  18. Wink [SOLVED] Display missing numbers not found within a list

    Started by hasan mougharbel‎, 08-16-2023 07:41 AM
    3 Attachment(s)
    • 2
    • 191
    windknife
    08-16-2023, 09:57 AM Go to last post

  19. Need Formula to find count of shift

    Started by julielara‎, 08-16-2023 09:24 AM
    excel formula 2019 1 Attachment(s)
    • 1
    • 174
    AliGW
    08-16-2023, 09:41 AM Go to last post

  20. [SOLVED] what's the right sum formula to use on this sheet

    Started by raedolwan‎, 08-16-2023 06:27 AM
    2 Attachment(s)
    • 10
    • 226
    AliGW
    08-16-2023, 09:33 AM Go to last post

  21. how to calculate time space as per fixed price difference

    Started by Nabihof‎, 08-16-2023 08:06 AM
    3 Attachment(s)
    • 5
    • 143
    HansDouwe
    08-16-2023, 08:56 AM Go to last post

  22. [SOLVED] Having problems tweaking a VLOOKUP formula

    Started by Evolve812‎, 08-11-2023 09:07 AM
    1 Attachment(s)
    • 7
    • 297
    TMS
    08-16-2023, 08:48 AM Go to last post

  23. [SOLVED] Extracting single text from array

    Started by Jacc‎, 08-16-2023 06:43 AM
    1 Attachment(s)
    • 4
    • 148
    Fluff13
    08-16-2023, 08:11 AM Go to last post

  24. IF statement for only positive numbers. Driving me mad

    Started by nihammon‎, 08-16-2023 05:53 AM
    • 5
    • 187
    TMS
    08-16-2023, 08:11 AM Go to last post

  25. Returned value used for formula in the same cell - Is it possible?

    Started by nihammon‎, 08-16-2023 07:05 AM
    2 Attachment(s)
    • 6
    • 131
    Fluff13
    08-16-2023, 08:07 AM Go to last post

  26. [SOLVED] Excel formula to exclude columns and rows with zero amounts

    Started by sunboy‎, 08-15-2023 10:01 PM
    2 Attachment(s)
    • 6
    • 291
    Gregb11
    08-16-2023, 07:40 AM Go to last post

  27. [SOLVED] Formula to Count Duplicate Value as one

    Started by ulala2‎, 08-15-2023 10:17 PM
    4 Attachment(s)
    • 12
    • 319
    Gregb11
    08-16-2023, 07:30 AM Go to last post

  28. Moved: Calculate Highlighted Cell

    Started by Art_Excel‎, 08-16-2023 06:50 AM
    •  
    •  

  29. Full month tracking

    Started by Alynace‎, 08-13-2023 07:11 PM
    3 Attachment(s)
    • 4
    • 244
    Alynace
    08-16-2023, 05:49 AM Go to last post

  30. [SOLVED] Getting an average value from a range, with 3 variables

    Started by Caibo‎, 08-16-2023 03:49 AM
    2 Attachment(s)
    • 2
    • 213
    Caibo
    08-16-2023, 04:49 AM Go to last post

  31. [SOLVED] 30d moving average

    Started by uqls‎, 08-15-2023 12:13 AM
    2 Attachment(s)
    • 6
    • 192
    TMS
    08-16-2023, 04:13 AM Go to last post

  32. Paste Unique Distinct Value and the value of a corresponding cell in a new worksheet

    Started by ujosan‎, 08-15-2023 04:08 AM
    disitinct value, unique distinct value 2 Attachment(s)
    • 10
    • 221
    AliGW
    08-16-2023, 02:09 AM Go to last post

  33. [SOLVED] Using drop down list item for calulations

    Started by mrpb‎, 08-16-2023 02:07 AM
    1 Attachment(s)
    • 1
    • 118
    AliGW
    08-16-2023, 02:08 AM Go to last post

  34. [SOLVED] Count number in ascending order.

    Started by I need excel help‎, 08-15-2023 12:47 AM
    2 Attachment(s)
    • 9
    • 332
    AliGW
    08-16-2023, 01:16 AM Go to last post

  35. Formula looking at previous column data points

    Started by MatrixFX‎, 08-16-2023 12:00 AM
    2 Attachment(s)
    • 3
    • 196
    HansDouwe
    08-16-2023, 12:51 AM Go to last post

  36. [SOLVED] Adding extra test to a nested IF formula

    Started by afprinter‎, 08-14-2023 04:54 PM
    1 Attachment(s)
    • 5
    • 187
    FDibbins
    08-15-2023, 11:00 PM Go to last post

  37. [SOLVED] Help converting a google sheets formula to excel

    Started by Newtonus_Prime‎, 08-12-2023 09:28 AM
    2 Attachment(s)
    • 5
    • 410
    JeteMc
    08-15-2023, 10:29 PM Go to last post

  38. Index Match formula

    Started by BMD4‎, 08-15-2023 01:34 PM
    2 Attachment(s)
    • 5
    • 162
    BMD4
    08-15-2023, 10:23 PM Go to last post

  39. Index Match result is a 0 instead of blank

    Started by Rookie2016‎, 08-15-2023 02:39 PM
    4 Attachment(s)
    • 13
    • 535
    ExceLogan
    08-15-2023, 07:02 PM Go to last post

  40. [SOLVED] Playoff Schedule

    Started by Bear01‎, 08-14-2023 11:02 AM
    2 Attachment(s)
    • 4
    • 247
    Bear01
    08-15-2023, 03:40 PM Go to last post

  41. [SOLVED] Refer to Cell to Get Table Name for a formula

    Started by Tybudd‎, 08-15-2023 02:15 PM
    • 2
    • 157
    Tybudd
    08-15-2023, 02:58 PM Go to last post

  42. Nesting logic inside of a COUNTIFS

    Started by chewytoy‎, 08-15-2023 01:28 PM
    1 Attachment(s)
    • 2
    • 125
    chewytoy
    08-15-2023, 02:11 PM Go to last post

  43. How can I show both the name and sum total based on a given year

    Started by Fred Houck‎, 08-15-2023 12:24 PM
    1 Attachment(s)
    • 4
    • 163
    dosydos
    08-15-2023, 01:56 PM Go to last post

  44. [SOLVED] Formula to create code from table values

    Started by nwexce‎, 08-15-2023 01:10 PM
    2 Attachment(s)
    • 4
    • 136
    HansDouwe
    08-15-2023, 01:53 PM Go to last post

  45. Sum of array

    Started by lyrad39‎, 08-15-2023 06:00 AM
    5 Attachment(s)
    • 13
    • 320
    HansDouwe
    08-15-2023, 01:09 PM Go to last post

  46. [SOLVED] STACK formula - column follow by row

    Started by dluhut‎, 08-15-2023 12:34 PM
    2 Attachment(s)
    • 2
    • 224
    dluhut
    08-15-2023, 12:48 PM Go to last post

  47. Staff Leave date match entitlement period

    Started by missy9413‎, 08-13-2023 11:21 AM
    3 Attachment(s)
    • 5
    • 208
    AliGW
    08-15-2023, 12:06 PM Go to last post

  48. Exclamation [SOLVED] Formula for returning values based on 3 conditions (If and Sums?)

    Started by LeapyUK‎, 08-15-2023 06:55 AM
    1 Attachment(s)
    • 5
    • 178
    JohnTopley
    08-15-2023, 10:57 AM Go to last post

  49. [SOLVED] Filter Data According to their product Number in Vertical Size

    Started by RUPESHRH‎, 08-15-2023 09:56 AM
    3 Attachment(s)
    • 4
    • 141
    Czeslaw
    08-15-2023, 10:55 AM Go to last post

  50. Question [SOLVED] Marking The Range based on multiple conditions

    Started by mhraja‎, 08-14-2023 01:19 PM
    4 Attachment(s)
    • 6
    • 241
    mhraja
    08-15-2023, 10:25 AM Go to last post
+ Post New Thread
Page 98 of 5615 FirstFirst ... 98 ...

Forum Information and Options

Users Browsing this Forum

There are currently 78 users browsing this forum. (6 members & 72 guests)

  1. FireDept,
  2. FrancisM2411,
  3. MubiJazz,
  4. Pete_UK,
  5. rav43k,
  6. zbor

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