+ Post New Thread
Page 22 of 5614 FirstFirst ... 22 ...
Threads 1051 to 1100 of 280687

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

  1. Populate an amount into the correct column based on a weekly paycheck

    Started by AlexG80‎, 03-02-2024 10:25 AM
    6 Attachment(s)
    • 12
    • 293
    MohamedGadAllah
    03-03-2024, 05:57 PM Go to last post

  2. Scientific Calculator formula VS Excel different answers

    Started by Blastfurnace‎, 03-03-2024 01:21 PM
    1 Attachment(s)
    • 1
    • 131
    Pete_UK
    03-03-2024, 01:31 PM Go to last post

  3. Vlookup fomula is not working

    Started by Mofasol‎, 03-02-2024 12:14 PM
    2 Attachment(s)
    • 8
    • 173
    Fluff13
    03-03-2024, 10:37 AM Go to last post

  4. is there any formula for countif in range?

    Started by lalaarif1‎, 02-29-2024 11:46 AM
    5 Attachment(s)
    • 10
    • 267
    windknife
    03-03-2024, 06:43 AM Go to last post

  5. Need to count number of tiimes same employee with same certification in an excel sheet

    Started by vijavad‎, 03-03-2024 05:35 AM
    2 Attachment(s)
    • 5
    • 115
    AliGW
    03-03-2024, 06:20 AM Go to last post

  6. [SOLVED] Better way to write formulas with TEXTBEFORE and TEXTAFTER?

    Started by JN831‎, 03-03-2024 04:37 AM
    1 Attachment(s)
    • 10
    • 136
    AliGW
    03-03-2024, 05:02 AM Go to last post

  7. [SOLVED] Formulas for showing cocktail ingredients for a particular from a lsit on another sheet

    Started by amar87‎, 09-25-2022 12:13 AM
    formula; vlookup 4 Attachment(s)
    • 7
    • 333
    AliGW
    03-03-2024, 03:14 AM Go to last post

  8. [SOLVED] How to fill in the corresponding table with the names of each unit according to their job

    Started by metrostar‎, 03-01-2024 08:57 AM
    3 Attachment(s)
    • 6
    • 344
    windknife
    03-02-2024, 09:24 PM Go to last post

  9. Smile [SOLVED] Tracking last 30 days

    Started by rafcaf‎, 03-02-2024 04:32 PM
    2 Attachment(s)
    • 2
    • 120
    DJunqueira
    03-02-2024, 05:34 PM Go to last post

  10. Mark Up Percentage Reducing As Price Increases

    Started by Jinkserr‎, 03-02-2024 02:35 PM
    2 Attachment(s)
    • 7
    • 188
    JohnTopley
    03-02-2024, 03:19 PM Go to last post

  11. if statement not differentiating between blank cell and a zero

    Started by carrollm‎, 03-02-2024 09:09 AM
    blank cell, if formula help 1 Attachment(s)
    • 4
    • 160
    AliGW
    03-02-2024, 01:48 PM Go to last post

  12. [SOLVED] Basic Checkbook Register Formula Problem

    Started by dwoodlives‎, 03-01-2024 09:37 AM
    2 Attachment(s)
    • 10
    • 237
    BadlySpelledBuoy
    03-02-2024, 11:36 AM Go to last post

  13. Average EOY Headcount based off projected gains and Losses

    Started by nsrea76‎, 02-26-2024 01:07 PM
    1 Attachment(s)
    • 1
    • 178
    JeteMc
    03-02-2024, 11:20 AM Go to last post

  14. [SOLVED] Difference between two dates for one unique value thats repeats itself

    Started by ExcelNewbie92‎, 03-02-2024 04:57 AM
    4 Attachment(s)
    • 14
    • 246
    DJunqueira
    03-02-2024, 07:27 AM Go to last post

  15. [SOLVED] How to use conditional formatting only on filled cells?

    Started by rizwanulhasan‎, 02-28-2024 12:36 AM
    8 Attachment(s)
    • 30
    • 457
    DJunqueira
    03-02-2024, 07:24 AM Go to last post

  16. Sum vs sumif formula query

    Started by jedoob‎, 03-01-2024 09:22 AM
    2 Attachment(s)
    • 8
    • 175
    DJunqueira
    03-02-2024, 03:33 AM Go to last post

  17. [SOLVED] How To Reference Row Number in Column Dynamically?

    Started by JN831‎, 03-02-2024 12:31 AM
    2 Attachment(s)
    • 3
    • 226
    DJunqueira
    03-02-2024, 02:26 AM Go to last post

  18. [SOLVED] Data validation without creating empty cells (Search+Offset+CountIf)

    Started by AleXSR700‎, 02-28-2024 04:48 AM
    8 Attachment(s)
    • 18
    • 301
    wk9128
    03-02-2024, 01:02 AM Go to last post

  19. Formula MAP, LAMBDA (point and comma)

    Started by Mxmaarten‎, 03-01-2024 11:09 AM
    2 Attachment(s)
    • 2
    • 110
    6StringJazzer
    03-01-2024, 11:55 AM Go to last post

  20. Searching specific cells on varying alternate rows

    Started by Aajt8888‎, 02-29-2024 11:00 AM
    6 Attachment(s)
    • 15
    • 234
    Chelsea27021954
    03-01-2024, 11:16 AM Go to last post

  21. [SOLVED] Error (BYROW, LAMBDA, INDEX)

    Started by Mxmaarten‎, 03-01-2024 09:53 AM
    2 Attachment(s)
    • 3
    • 130
    Fluff13
    03-01-2024, 10:49 AM Go to last post

  22. [SOLVED] Index Match help

    Started by Doc_62‎, 03-01-2024 02:36 AM
    10 Attachment(s)
    • 33
    • 357
    AliGW
    03-01-2024, 07:55 AM Go to last post

  23. Moved: Conditional Formatting in Pivot Table in Excel based on Source Data

    Started by T.Turner‎, 02-29-2024 05:42 AM
    •  
    •  

  24. [SOLVED] Need formula to show converted units of measurement

    Started by ricky-84‎, 02-27-2024 03:49 AM
    2 Attachment(s)
    • 9
    • 189
    Glenn Kennedy
    03-01-2024, 03:39 AM Go to last post

  25. Help - IF date is less to or equal to then formula

    Started by halsallb‎, 02-28-2024 09:18 AM
    4 Attachment(s)
    • 9
    • 181
    TMS
    02-29-2024, 08:04 PM Go to last post

  26. [SOLVED] Excel FILTER FORMULA with 2 dimensional criteria

    Started by dxfoxd‎, 02-28-2024 07:43 PM
    7 Attachment(s)
    • 15
    • 341
    TMS
    02-29-2024, 05:48 PM Go to last post

  27. Create unique data points

    Started by NHEE789‎, 02-29-2024 10:18 AM
    1 Attachment(s)
    • 1
    • 109
    dflak
    02-29-2024, 05:36 PM Go to last post

  28. [SOLVED] Summing Values Based On When They Occured In A Fiscal Year

    Started by Mvaldesi‎, 02-29-2024 02:34 PM
    2 Attachment(s)
    • 4
    • 167
    etaf
    02-29-2024, 04:59 PM Go to last post

  29. [SOLVED] Ranking - No Duplicates

    Started by Terry-J‎, 02-27-2024 02:41 PM
    6 Attachment(s)
    • 11
    • 322
    DJunqueira
    02-29-2024, 04:27 PM Go to last post

  30. Add Gross Margin line to a pivot table

    Started by dwb014‎, 02-28-2024 12:53 PM
    2 Attachment(s)
    • 1
    • 103
    dflak
    02-29-2024, 04:03 PM Go to last post

  31. [SOLVED] Change AVERAGEIFS formula to AGGREGATE or similar formula

    Started by Dbroek‎, 02-29-2024 01:04 PM
    2 Attachment(s)
    • 2
    • 149
    Dbroek
    02-29-2024, 02:51 PM Go to last post

  32. Lightbulb Date color change question

    Started by ajamesritt‎, 02-29-2024 02:19 PM
    • 1
    • 79
    etaf
    02-29-2024, 02:22 PM Go to last post

  33. Post [SOLVED] Check if a cell contains a word in listA, if not, then check if it contains a word in list

    Started by mrbatata‎, 02-29-2024 11:29 AM
    excel 1 Attachment(s)
    • 6
    • 149
    mrbatata
    02-29-2024, 01:55 PM Go to last post

  34. [SOLVED] Formula to calculate stepped charges

    Started by fragandclear‎, 02-29-2024 11:22 AM
    3 Attachment(s)
    • 12
    • 161
    JohnTopley
    02-29-2024, 01:47 PM Go to last post

  35. Search within a range of matched IDs and find a matched pair of numbers

    Started by SmokeNebulus‎, 02-29-2024 10:34 AM
    2 Attachment(s)
    • 3
    • 98
    DJunqueira
    02-29-2024, 01:37 PM Go to last post

  36. [SOLVED] Extract Date From String

    Started by HaroonSid‎, 02-18-2024 12:57 PM
    3 Attachment(s)
    • 5
    • 168
    Sekars
    02-29-2024, 12:39 PM Go to last post

  37. Lightbulb IRR True Up's for Minimum Return Thresholds

    Started by myzee‎, 02-29-2024 03:32 AM
    2 Attachment(s)
    • 1
    • 130
    josephteh
    02-29-2024, 12:25 PM Go to last post

  38. VLookup full list and return value (Formula fix)

    Started by SrDaan‎, 02-29-2024 09:42 AM
    excel formulas, fix, lookup 2 Attachment(s)
    • 6
    • 159
    etaf
    02-29-2024, 12:00 PM Go to last post

  39. [SOLVED] Add 2 Criteria to Filter Formula

    Started by billy60‎, 02-29-2024 09:25 AM
    • 7
    • 119
    billy60
    02-29-2024, 10:59 AM Go to last post

  40. Create formula that "resets" when it reaches a new date?

    Started by Vedes‎, 02-29-2024 08:51 AM
    2 Attachment(s)
    • 1
    • 122
    DJunqueira
    02-29-2024, 10:46 AM Go to last post

  41. [SOLVED] Enter a total amount and calculate the number of sheets based on different banknotes

    Started by choletseng‎, 02-29-2024 09:27 AM
    2 Attachment(s)
    • 4
    • 154
    JohnTopley
    02-29-2024, 10:37 AM Go to last post

  42. Calculating months between two dates

    Started by lguest‎, 02-29-2024 09:57 AM
    3 Attachment(s)
    • 8
    • 180
    etaf
    02-29-2024, 10:26 AM Go to last post

  43. UNIQUE and CHOOSECOLS return 0 for blank cells

    Started by varbergt‎, 02-29-2024 09:17 AM
    filter, unique 2 Attachment(s)
    • 1
    • 356
    Fluff13
    02-29-2024, 09:29 AM Go to last post

  44. Angry COUNTIF Function for Dates not working

    Started by Maisy‎, 02-29-2024 07:34 AM
    countif, formula, formulahelp 1 Attachment(s)
    • 6
    • 146
    JohnTopley
    02-29-2024, 09:20 AM Go to last post

  45. Weekly data into monthly data inc. splitting weeks that overlap months

    Started by dc007c0231‎, 02-29-2024 08:21 AM
    sumproduct 1 Attachment(s)
    • 2
    • 154
    AliGW
    02-29-2024, 08:41 AM Go to last post

  46. Unique and Filter multiple criteria from SAME column

    Started by varbergt‎, 02-28-2024 11:24 AM
    filter, unique 1 Attachment(s)
    • 5
    • 148
    Fluff13
    02-29-2024, 08:18 AM Go to last post

  47. My IF function is 99% complete

    Started by Regal383‎, 02-29-2024 07:50 AM
    1 Attachment(s)
    • 1
    • 99
    AliGW
    02-29-2024, 08:18 AM Go to last post

  48. [SOLVED] Help needed to convert Table to Sumif by period

    Started by FT00‎, 02-28-2024 12:12 PM
    3 Attachment(s)
    • 5
    • 125
    Fluff13
    02-29-2024, 08:17 AM Go to last post

  49. How to simply sum the 1st 12 rows of a filtered result?

    Started by Btmacdou‎, 02-23-2024 04:03 PM
    2 Attachment(s)
    • 8
    • 191
    DJunqueira
    02-29-2024, 07:46 AM Go to last post

  50. [SOLVED] Formula error

    Started by RUPESHRH‎, 02-29-2024 07:02 AM
    2 Attachment(s)
    • 4
    • 104
    AliGW
    02-29-2024, 07:31 AM Go to last post
+ Post New Thread
Page 22 of 5614 FirstFirst ... 22 ...

Forum Information and Options

Users Browsing this Forum

There are currently 47 users browsing this forum. (0 members & 47 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