+ Post New Thread
Page 41 of 5612 FirstFirst ... 41 ...
Threads 2001 to 2050 of 280554

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

  1. Moved: Formulas in a Table with Dropdown List

    Started by welshraz‎, 01-09-2024 12:11 PM
    •  
    •  

  2. Indirect cadence ending in Xlookup

    Started by PewPewPiet‎, 01-08-2024 03:14 PM
    2 Attachment(s)
    • 3
    • 192
    DJunqueira
    01-09-2024, 11:28 AM Go to last post

  3. Semi-advanced SUMPRODUCT cannot calculate last argument as lookup

    Started by MikF‎, 01-08-2024 07:03 PM
    4 Attachment(s)
    • 8
    • 281
    6StringJazzer
    01-09-2024, 11:13 AM Go to last post

  4. Search function that keeps all data hidden, except what is being searched

    Started by little_details‎, 01-09-2024 10:15 AM
    2 Attachment(s)
    • 1
    • 111
    DJunqueira
    01-09-2024, 10:39 AM Go to last post

  5. Double qoutes appearing in copy and paste.

    Started by anavarathan‎, 01-09-2024 09:03 AM
    2 Attachment(s)
    • 4
    • 212
    anavarathan
    01-09-2024, 10:27 AM Go to last post

  6. [SOLVED] Help with LET function

    Started by Newtonus_Prime‎, 01-09-2024 08:49 AM
    1 Attachment(s)
    • 1
    • 81
    Fluff13
    01-09-2024, 08:55 AM Go to last post

  7. [SOLVED] Need help with SUMIFS

    Started by Newtonus_Prime‎, 01-08-2024 06:21 PM
    1 Attachment(s)
    • 2
    • 128
    Newtonus_Prime
    01-09-2024, 08:45 AM Go to last post

  8. [SOLVED] Change Formula to format by Row rather than Column

    Started by Dom.Knight‎, 01-09-2024 06:12 AM
    2 Attachment(s)
    • 3
    • 136
    HansDouwe
    01-09-2024, 07:49 AM Go to last post

  9. extract total of a column from specified period

    Started by shamsu203‎, 01-07-2024 11:14 AM
    6 Attachment(s)
    • 11
    • 332
    Glenn Kennedy
    01-09-2024, 07:31 AM Go to last post

  10. Question [SOLVED] Formula that search for EXACT same text in a cell with MULTIPLE words

    Started by supercrisz1‎, 01-09-2024 06:33 AM
    exact value, isnumber, multiple 3 Attachment(s)
    • 3
    • 127
    Pete_UK
    01-09-2024, 06:55 AM Go to last post

  11. [SOLVED] Extracting dates from text string..

    Started by Ian99099‎, 01-07-2024 07:58 AM
    1 Attachment(s)
    • 10
    • 210
    AliGW
    01-09-2024, 05:58 AM Go to last post

  12. [SOLVED] Added Week Numbers into cell but get the #VALUE error

    Started by dbutler43‎, 01-09-2024 04:33 AM
    5 Attachment(s)
    • 16
    • 214
    AliGW
    01-09-2024, 05:46 AM Go to last post

  13. [SOLVED] Find any dot in string that has numbers in front and back and replace it with comma

    Started by PaulM100‎, 01-08-2024 05:09 AM
    8 Attachment(s)
    • 25
    • 408
    Glenn Kennedy
    01-09-2024, 05:11 AM Go to last post

  14. Cool [SOLVED] Course Enrollment Averages: Calculations to Active Terms

    Started by onelifestyle‎, 01-09-2024 12:28 AM
    9 Attachment(s)
    • 23
    • 307
    AliGW
    01-09-2024, 04:52 AM Go to last post

  15. Cool Data Analysis: Average Enrollment Calculation Using Pivot Table

    Started by onelifestyle‎, 01-09-2024 03:30 AM
    1 Attachment(s)
    • 3
    • 117
    AliGW
    01-09-2024, 03:39 AM Go to last post

  16. Need help with formulas to return name from roster on calendar

    Started by Nicky88‎, 01-09-2024 12:04 AM
    3 Attachment(s)
    • 1
    • 97
    AliGW
    01-09-2024, 02:30 AM Go to last post

  17. How to apply different percentages to total

    Started by Glenn.‎, 01-08-2024 08:49 PM
    1 Attachment(s)
    • 1
    • 114
    AliGW
    01-09-2024, 02:16 AM Go to last post

  18. Conditional formatting with formulas

    Started by mattdennis1402‎, 01-08-2024 10:41 PM
    2 Attachment(s)
    • 6
    • 154
    mattdennis1402
    01-09-2024, 01:48 AM Go to last post

  19. Filter based on tables, wildcards, and OR

    Started by daniel.destefano‎, 01-03-2024 09:35 PM
    3 Attachment(s)
    • 6
    • 255
    DJunqueira
    01-09-2024, 12:26 AM Go to last post

  20. [SOLVED] Replacing SOME data in multiple cells with one value

    Started by Catherine01‎, 01-07-2024 06:22 PM
    6 Attachment(s)
    • 19
    • 397
    HansDouwe
    01-08-2024, 11:34 PM Go to last post

  21. How to make a column automatically show the SUM of the previous cells within the same row

    Started by Mission_AD‎, 01-08-2024 08:07 PM
    • 7
    • 128
    HansDouwe
    01-08-2024, 09:50 PM Go to last post

  22. [SOLVED] Formula to solve If with or condition and duplicate

    Started by johan58‎, 01-07-2024 10:15 AM
    2 Attachment(s)
    • 4
    • 207
    DJunqueira
    01-08-2024, 09:04 PM Go to last post

  23. [SOLVED] Formula stops working when using dynamic array

    Started by Jacc‎, 01-08-2024 02:16 PM
    1 Attachment(s)
    • 2
    • 130
    Jacc
    01-08-2024, 04:43 PM Go to last post

  24. [SOLVED] Lookup and find the in-between days and return number of days

    Started by KRIXXXX‎, 11-09-2023 01:00 PM
    10 Attachment(s)
    • 18
    • 569
    HansDouwe
    01-08-2024, 04:05 PM Go to last post

  25. Post [SOLVED] ROUND formula - dragging to whole column doesn't work.

    Started by Purplerattler‎, 01-08-2024 10:38 AM
    1 Attachment(s)
    • 4
    • 126
    Purplerattler
    01-08-2024, 10:57 AM Go to last post

  26. [SOLVED] Use a cell for a table refernce in a formula

    Started by jsr22788‎, 01-08-2024 07:25 AM
    2 Attachment(s)
    • 7
    • 177
    jsr22788
    01-08-2024, 10:53 AM Go to last post

  27. Question Data Validation

    Started by Skutter‎, 01-08-2024 08:48 AM
    3 Attachment(s)
    • 5
    • 204
    AliGW
    01-08-2024, 10:08 AM Go to last post

  28. SumIFs - Multiple Criteria

    Started by Lorie-Ann‎, 11-23-2023 12:55 PM
    15 Attachment(s)
    • 32
    • 912
    JeteMc
    01-08-2024, 09:50 AM Go to last post

  29. Moved: if cell has value then insert sequence number

    Started by FvdF‎, 01-05-2024 07:10 AM
    •  
    •  

  30. [SOLVED] why is my sum if not working

    Started by makinmomb‎, 01-08-2024 05:26 AM
    3 Attachment(s)
    • 7
    • 163
    AliGW
    01-08-2024, 06:04 AM Go to last post

  31. [SOLVED] Split phrases at punctuation level, but retain the special character

    Started by PaulM100‎, 01-03-2024 09:37 AM
    2 Attachment(s)
    • 6
    • 189
    PaulM100
    01-08-2024, 05:03 AM Go to last post

  32. Searchable Drop Donwn in any cell with Data Validation in Excel

    Started by R K Singh‎, 12-26-2023 02:51 AM
    2 Attachment(s)
    • 15
    • 296
    AliGW
    01-08-2024, 03:07 AM Go to last post

  33. [SOLVED] Add 2 hour grace period to conditional formatting formulas

    Started by Longbow 44‎, 01-07-2024 09:13 PM
    3 Attachment(s)
    • 5
    • 126
    HansDouwe
    01-08-2024, 01:13 AM Go to last post

  34. [SOLVED] to Calculate Remain Qty Using Correct Formulas

    Started by Did13n‎, 01-06-2024 09:09 AM
    3 Attachment(s)
    • 8
    • 248
    DJunqueira
    01-08-2024, 12:59 AM Go to last post

  35. [SOLVED] Numbers starting with 0

    Started by jilaba‎, 01-07-2024 02:22 PM
    1 Attachment(s)
    • 6
    • 170
    HansDouwe
    01-07-2024, 05:55 PM Go to last post

  36. Post need to get right date

    Started by manshyworld‎, 01-07-2024 08:05 AM
    date, date format 6 Attachment(s)
    • 16
    • 362
    JohnTopley
    01-07-2024, 01:39 PM Go to last post

  37. Textsplit output cannot be read in vlookup

    Started by Dimaccio9616‎, 01-07-2024 01:03 PM
    #textsplit, #vlookup 2 Attachment(s)
    • 5
    • 198
    Glenn Kennedy
    01-07-2024, 01:37 PM Go to last post

  38. [SOLVED] Countif, Sumif combination

    Started by jilaba‎, 01-07-2024 12:47 PM
    3 Attachment(s)
    • 7
    • 166
    HansDouwe
    01-07-2024, 01:20 PM Go to last post

  39. [SOLVED] Formula to calculate provisional tax

    Started by sunboy‎, 12-26-2023 05:07 AM
    5 Attachment(s)
    • 11
    • 542
    JeteMc
    01-07-2024, 09:49 AM Go to last post

  40. [SOLVED] Formula or Function to compare dates and calculate relevant cells

    Started by ThomasB61‎, 01-07-2024 05:30 AM
    formula, function, macro, vba 1 Attachment(s)
    • 3
    • 149
    ThomasB61
    01-07-2024, 09:23 AM Go to last post

  41. [SOLVED] Fill address with complete name

    Started by nsr115‎, 01-07-2024 04:02 AM
    2 Attachment(s)
    • 8
    • 141
    DJunqueira
    01-07-2024, 06:45 AM Go to last post

  42. Post [SOLVED] Formula for increasing value after no.of intervals

    Started by maniea‎, 01-07-2024 03:30 AM
    formula, intervalls 2 Attachment(s)
    • 7
    • 157
    AliGW
    01-07-2024, 06:11 AM Go to last post

  43. [SOLVED] Extract middle company's names from text..

    Started by kikola123‎, 01-07-2024 04:12 AM
    4 Attachment(s)
    • 11
    • 281
    Glenn Kennedy
    01-07-2024, 05:25 AM Go to last post

  44. Extract data based on Multiple conditions_V2

    Started by paradise2sr‎, 01-07-2024 05:14 AM
    1 Attachment(s)
    • 1
    • 95
    AliGW
    01-07-2024, 05:17 AM Go to last post

  45. Question Extract line containing ", United States" from a multi-line cell

    Started by Atif Bhatti‎, 12-31-2023 05:29 AM
    extract, multiline cells, specific data 4 Attachment(s)
    • 15
    • 428
    JEC.
    01-07-2024, 05:04 AM Go to last post

  46. [SOLVED] Converting text to number (value formula)

    Started by Mahmoudelnemr‎, 01-06-2024 05:05 AM
    3 Attachment(s)
    • 5
    • 181
    Czeslaw
    01-07-2024, 04:09 AM Go to last post

  47. Groupby with chooscols...

    Started by kikola123‎, 01-06-2024 02:42 PM
    • 8
    • 235
    AliGW
    01-07-2024, 03:22 AM Go to last post

  48. [SOLVED] Error on inventory sheet formula

    Started by ShaunJM‎, 01-06-2024 12:07 PM
    2 Attachment(s)
    • 2
    • 111
    ShaunJM
    01-07-2024, 03:17 AM Go to last post

  49. Data Validation to allow only Alphanumerics

    Started by LaSauce‎, 01-04-2024 06:52 PM
    5 Attachment(s)
    • 14
    • 354
    kvsrinivasamurthy
    01-07-2024, 02:52 AM Go to last post

  50. Insert multiple photos in excel sheet

    Started by sharathnarayanan‎, 01-06-2024 03:11 AM
    • 1
    • 127
    DJunqueira
    01-06-2024, 10:33 PM Go to last post
+ Post New Thread
Page 41 of 5612 FirstFirst ... 41 ...

Forum Information and Options

Users Browsing this Forum

There are currently 45 users browsing this forum. (3 members & 42 guests)

  1. Howardc1001,
  2. ThomasB61,
  3. Tricks420

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