+ Post New Thread
Page 13 of 5614 FirstFirst ... 13 ...
Threads 601 to 650 of 280679

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

  1. [SOLVED] Need Help Split Text If Possible with specific condition

    Started by ZANDRY10085‎, 03-26-2024 06:59 AM
    5 Attachment(s)
    • 21
    • 163
    TMS
    03-26-2024, 02:16 PM Go to last post

  2. [SOLVED] Formula Name Errors

    Started by billy60‎, 03-26-2024 08:45 AM
    2 Attachment(s)
    • 4
    • 71
    6StringJazzer
    03-26-2024, 02:00 PM Go to last post

  3. Need formula to show which ever category has the highest value, it will show the name

    Started by Depressedcorporate‎, 03-26-2024 01:51 PM
    • 1
    • 65
    Bernie Deitrick
    03-26-2024, 01:58 PM Go to last post

  4. [SOLVED] Sorting names by Surname Alphabetically without using two columns

    Started by Marvo‎, 03-25-2024 07:42 PM
    6 Attachment(s)
    • 18
    • 250
    Marvo
    03-26-2024, 01:42 PM Go to last post

  5. [SOLVED] Formulas for Vehicle Service Overview sheet

    Started by billy60‎, 03-26-2024 11:04 AM
    4 Attachment(s)
    • 5
    • 80
    DJunqueira
    03-26-2024, 12:18 PM Go to last post

  6. Need Help to Show Duplicate Values and Count It (With or Without Specific Criteria)

    Started by ZANDRY10085‎, 03-26-2024 09:11 AM
    3 Attachment(s)
    • 3
    • 94
    Bernie Deitrick
    03-26-2024, 11:25 AM Go to last post

  7. Trying to extract Year and Day out of a table

    Started by boynejs‎, 03-26-2024 10:32 AM
    3 Attachment(s)
    • 4
    • 83
    Glenn Kennedy
    03-26-2024, 10:43 AM Go to last post

  8. Moved: Anfangsbuchstaben von Namen untereinander

    Started by Piezahr‎, 03-26-2024 10:41 AM
    •  
    •  

  9. [SOLVED] Index Formula Help

    Started by Frick‎, 03-26-2024 09:58 AM
    2 Attachment(s)
    • 1
    • 60
    Glenn Kennedy
    03-26-2024, 10:14 AM Go to last post

  10. [SOLVED] Data Validation List Using a Table Name

    Started by cosmica67‎, 03-26-2024 09:40 AM
    2 Attachment(s)
    • 3
    • 70
    cosmica67
    03-26-2024, 09:49 AM Go to last post

  11. Data Relocation from Worksheet to Worksheet

    Started by Vinga‎, 12-16-2023 01:37 PM
    4 Attachment(s)
    • 9
    • 271
    JeteMc
    03-26-2024, 09:48 AM Go to last post

  12. Question Using IF, AND + OR Functions

    Started by bradjenkins‎, 03-26-2024 06:17 AM
    formula, ifs, orr 3 Attachment(s)
    • 6
    • 107
    bradjenkins
    03-26-2024, 09:40 AM Go to last post

  13. Concise Formulas to Make Excel File Smaller

    Started by mtmy99‎, 03-26-2024 12:00 AM
    large excel file, long formulas, slow 2 Attachment(s)
    • 2
    • 161
    Fluff13
    03-26-2024, 08:09 AM Go to last post

  14. The value in vlookup array has spaces but the lookup value does not

    Started by Allan91‎, 03-26-2024 04:12 AM
    excel formulas, remove spaces, substitute, trim, vlookup
    • 4
    • 111
    AliGW
    03-26-2024, 07:17 AM Go to last post

  15. [SOLVED] Position each value found in each line of a table under its competent tens group

    Started by AP41-at-OfficeForum‎, 03-23-2024 04:42 PM
    5 Attachment(s)
    • 12
    • 257
    DJunqueira
    03-26-2024, 06:50 AM Go to last post

  16. Post Сombine in one cell in one column from other column and cells

    Started by Fedor1‎, 03-26-2024 06:02 AM
    3 Attachment(s)
    • 4
    • 85
    AliGW
    03-26-2024, 06:14 AM Go to last post

  17. [SOLVED] Match transactions based on two months interval

    Started by sunboy‎, 03-25-2024 11:09 PM
    6 Attachment(s)
    • 10
    • 206
    windknife
    03-26-2024, 04:44 AM Go to last post

  18. [SOLVED] SUMIFS with dates using operators <= , >= , = {prefer not to have dates inside formula}

    Started by daliye‎, 03-26-2024 03:46 AM
    2 Attachment(s)
    • 14
    • 138
    AliGW
    03-26-2024, 04:30 AM Go to last post

  19. [SOLVED] INDEX and MATCH - return value even though not all criteria are met

    Started by varbergt‎, 03-25-2024 05:50 AM
    index, match 3 Attachment(s)
    • 5
    • 168
    AliGW
    03-26-2024, 03:43 AM Go to last post

  20. [SOLVED] Counts number of Dates falls in the month

    Started by seercoven‎, 03-26-2024 12:11 AM
    2 Attachment(s)
    • 4
    • 132
    wk9128
    03-26-2024, 02:57 AM Go to last post

  21. [SOLVED] Can we use Index/match to return Sumrange for Sumif?

    Started by FT00‎, 03-20-2024 11:57 AM
    1 Attachment(s)
    • 11
    • 210
    wk9128
    03-26-2024, 12:54 AM Go to last post

  22. Disaggregate data from a single row to multiple rows and copy details from original row

    Started by SL0615‎, 03-25-2024 06:04 AM
    6 Attachment(s)
    • 5
    • 122
    kvsrinivasamurthy
    03-26-2024, 12:36 AM Go to last post

  23. [SOLVED] Sumif + Date Range + Lookup Value Problem

    Started by Harro6060‎, 03-25-2024 04:35 AM
    date range, lookup, sumproduct 3 Attachment(s)
    • 5
    • 111
    windknife
    03-25-2024, 10:09 PM Go to last post

  24. Return a specific number dependent on text from drop down menu in previous cell.

    Started by monkeypuzzle‎, 03-25-2024 04:23 PM
    • 2
    • 78
    monkeypuzzle
    03-25-2024, 04:46 PM Go to last post

  25. [SOLVED] IF Nested formula

    Started by Ladyj07‎, 03-25-2024 03:23 PM
    2 Attachment(s)
    • 8
    • 108
    Ladyj07
    03-25-2024, 04:05 PM Go to last post

  26. [SOLVED] Unsing a cell reference in MINIFS

    Started by 19Batonman58‎, 03-25-2024 01:23 PM
    1 Attachment(s)
    • 3
    • 87
    TMS
    03-25-2024, 02:39 PM Go to last post

  27. [SOLVED] Outline Cells in Red That Vary by More Than a Value of 2

    Started by sbrnard‎, 03-25-2024 01:35 PM
    3 Attachment(s)
    • 4
    • 70
    dosydos
    03-25-2024, 02:31 PM Go to last post

  28. [SOLVED] Copy column B. C. D etc. below the data/text in column A

    Started by MrMiaogi‎, 03-25-2024 01:48 PM
    1 Attachment(s)
    • 2
    • 89
    JohnTopley
    03-25-2024, 02:15 PM Go to last post

  29. [SOLVED] Pull only Jan data

    Started by rafcaf‎, 03-18-2024 07:52 PM
    10 Attachment(s)
    • 11
    • 268
    DJunqueira
    03-25-2024, 02:09 PM Go to last post

  30. [SOLVED] Formula to extract Value from Sheet

    Started by Howardc1001‎, 03-25-2024 03:24 AM
    5 Attachment(s)
    • 21
    • 155
    DJunqueira
    03-25-2024, 02:06 PM Go to last post

  31. [SOLVED] Trying to improving the functionality of a workbook

    Started by Marvo‎, 03-24-2024 02:37 PM
    1 Attachment(s)
    • 3
    • 110
    AliGW
    03-25-2024, 01:48 PM Go to last post

  32. [SOLVED] IF/Then Multiple Criteria Help

    Started by LMARTINO‎, 03-25-2024 12:45 PM
    2 Attachment(s)
    • 4
    • 69
    AliGW
    03-25-2024, 01:38 PM Go to last post

  33. exchanging No`s for names

    Started by Bailymaus‎, 03-23-2024 04:18 PM
    5 Attachment(s)
    • 34
    • 381
    Bailymaus
    03-25-2024, 01:37 PM Go to last post

  34. Help with consolidated sheet pulling data from daily sheets & formula date incrementing

    Started by Sean Goldie‎, 03-25-2024 12:36 PM
    1 Attachment(s)
    • 7
    • 102
    AliGW
    03-25-2024, 01:28 PM Go to last post

  35. Conditional formating multiple tabs

    Started by araza123‎, 03-25-2024 12:38 PM
    conditional formating 1 Attachment(s)
    • 1
    • 52
    AliGW
    03-25-2024, 12:40 PM Go to last post

  36. Using Filter to Exclude Data from Calculations

    Started by alexfwalker‎, 03-25-2024 10:08 AM
    1 Attachment(s)
    • 7
    • 95
    Fluff13
    03-25-2024, 12:15 PM Go to last post

  37. Year Formula Partially Works

    Started by PeterGeeJA‎, 03-25-2024 11:03 AM
    • 2
    • 76
    6StringJazzer
    03-25-2024, 11:50 AM Go to last post

  38. Automatic comment in cells when marked, how?

    Started by Papaa_Beard‎, 03-25-2024 08:30 AM
    automatic comments, cells column 1 Attachment(s)
    • 1
    • 86
    Logit
    03-25-2024, 11:26 AM Go to last post

  39. Can I use 2 Countifs in one excel row?

    Started by Sam_Max‎, 03-25-2024 08:45 AM
    3 Attachment(s)
    • 5
    • 100
    AliGW
    03-25-2024, 10:59 AM Go to last post

  40. [SOLVED] Sort unique from multiple columns if criteria met

    Started by KerahJoy‎, 03-21-2024 11:51 PM
    criteria, filter, multiple column 15 Attachment(s)
    • 29
    • 308
    AliGW
    03-25-2024, 10:35 AM Go to last post

  41. If criteria not met then another list

    Started by KerahJoy‎, 03-25-2024 09:33 AM
    criteria not met 2 Attachment(s)
    • 2
    • 94
    AliGW
    03-25-2024, 09:41 AM Go to last post

  42. [SOLVED] Extract figures from Cell

    Started by WAULKMILLFH‎, 03-25-2024 09:16 AM
    1 Attachment(s)
    • 7
    • 77
    Fluff13
    03-25-2024, 09:35 AM Go to last post

  43. Hourly/daily Resource counter

    Started by rsmith89‎, 03-25-2024 09:01 AM
    days of the week, headcount, heatmap, hourly count, hourly staff 1 Attachment(s)
    • 1
    • 68
    AliGW
    03-25-2024, 09:32 AM Go to last post

  44. [SOLVED] Adding IFERROR to formula

    Started by Marvo‎, 03-25-2024 08:48 AM
    • 2
    • 74
    Marvo
    03-25-2024, 08:54 AM Go to last post

  45. Sumproduct pricing table threshold calculation issue

    Started by mimijojo‎, 03-24-2024 03:11 PM
    sumproduct threshold 3 Attachment(s)
    • 9
    • 184
    DJunqueira
    03-25-2024, 08:49 AM Go to last post

  46. [SOLVED] Show written COMPLETED if 100%, inside another formula

    Started by Vincentwega‎, 03-25-2024 06:10 AM
    2 Attachment(s)
    • 9
    • 137
    Glenn Kennedy
    03-25-2024, 07:23 AM Go to last post

  47. [SOLVED] Breaking down a formula

    Started by Marvo‎, 03-25-2024 05:13 AM
    • 8
    • 70
    AliGW
    03-25-2024, 05:39 AM Go to last post

  48. [SOLVED] problem with calenar in excel(no vba, made with functios and formulas)

    Started by kvemperor‎, 03-25-2024 04:39 AM
    2 Attachment(s)
    • 12
    • 99
    AliGW
    03-25-2024, 05:22 AM Go to last post

  49. [SOLVED] Invoices from CSV File

    Started by SBA-Sabres‎, 03-21-2024 06:42 AM
    3 Attachment(s)
    • 9
    • 207
    TMS
    03-25-2024, 04:28 AM Go to last post

  50. [SOLVED] Count No. of persons with multiple conditions

    Started by nagesh.tvsr‎, 03-22-2024 08:33 AM
    3 Attachment(s)
    • 7
    • 185
    windknife
    03-25-2024, 01:30 AM Go to last post
+ Post New Thread
Page 13 of 5614 FirstFirst ... 13 ...

Forum Information and Options

Users Browsing this Forum

There are currently 81 users browsing this forum. (8 members & 73 guests)

  1. cwwazy,
  2. etaf,
  3. HansDouwe,
  4. ilabudovic,
  5. JohnTopley,
  6. leovilla,
  7. Ravana

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