+ Post New Thread
Page 49 of 5611 FirstFirst ... 49 ...
Threads 2401 to 2450 of 280538

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

  1. [SOLVED] How to write a formula with multiple IF conditions?

    Started by rizwanulhasan‎, 12-13-2023 05:33 AM
    1 Attachment(s)
    • 15
    • 333
    JohnTopley
    12-13-2023, 03:24 PM Go to last post

  2. Vlookup find any date in range of dates in column with dates

    Started by Musto85‎, 12-13-2023 12:42 PM
    • 3
    • 131
    etaf
    12-13-2023, 02:28 PM Go to last post

  3. [SOLVED] Arrange Horizontal data in Table Form

    Started by KRIXXXX‎, 12-13-2023 12:19 PM
    1 Attachment(s)
    • 1
    • 160
    Estevaoba
    12-13-2023, 02:17 PM Go to last post

  4. [SOLVED] Two pulldowns pick out result from table

    Started by MrO‎, 12-13-2023 12:00 PM
    1 Attachment(s)
    • 3
    • 118
    AliGW
    12-13-2023, 01:58 PM Go to last post

  5. [SOLVED] Power Query - Get Dynamic Headers from another Table and "VLOOKUP"

    Started by dluhut‎, 12-11-2023 05:08 PM
    3 Attachment(s)
    • 3
    • 225
    alansidman
    12-13-2023, 12:10 PM Go to last post

  6. Question [SOLVED] Dates based on number and text from another sheet

    Started by AndreiD‎, 12-13-2023 10:30 AM
    vlookup 1 Attachment(s)
    • 4
    • 174
    Pepe Le Mokko
    12-13-2023, 12:02 PM Go to last post

  7. [SOLVED] Lookup Column headings and return corresponding column value in another row

    Started by kdrymer85‎, 12-13-2023 09:44 AM
    formula 3 Attachment(s)
    • 11
    • 225
    AliGW
    12-13-2023, 10:17 AM Go to last post

  8. [SOLVED] how to count words in cells (and compare it to quantity before adding it up)

    Started by excel_wnb‎, 12-13-2023 04:19 AM
    1 Attachment(s)
    • 8
    • 204
    windknife
    12-13-2023, 09:38 AM Go to last post

  9. Problem with =IF formula <<

    Started by geoff.s‎, 12-13-2023 06:10 AM
    if formula, if formula help 2 Attachment(s)
    • 7
    • 415
    AliGW
    12-13-2023, 07:58 AM Go to last post

  10. [SOLVED] Help creating a formula that requires different calculations for multiple columns

    Started by Linowood‎, 12-10-2023 07:31 PM
    2 Attachment(s)
    • 8
    • 344
    Gregb11
    12-13-2023, 07:49 AM Go to last post

  11. [SOLVED] Multiple data validation for cells.

    Started by krooms‎, 12-13-2023 05:53 AM
    1 Attachment(s)
    • 5
    • 232
    AliGW
    12-13-2023, 07:48 AM Go to last post

  12. Question [SOLVED] Count number of instances over a 13 week period

    Started by Oliver3443‎, 12-08-2023 05:47 AM
    2 Attachment(s)
    • 10
    • 265
    Oliver3443
    12-13-2023, 07:46 AM Go to last post

  13. Lightbulb [SOLVED] Use LET function to create 2 Sorted tables based on multiple criteria

    Started by Hesham121‎, 06-13-2023 05:51 AM
    5 Attachment(s)
    • 13
    • 348
    HansDouwe
    12-13-2023, 07:05 AM Go to last post

  14. [SOLVED] Vlook up not finding what I am looking for

    Started by OHS Morgan‎, 12-12-2023 08:42 PM
    #vlookup 2 Attachment(s)
    • 8
    • 416
    TMS
    12-13-2023, 04:47 AM Go to last post

  15. [SOLVED] Search letters and numbers to see if exist in another column by at least 7 characters

    Started by MaryMaria‎, 12-08-2023 02:05 PM
    len function, match a list 5 Attachment(s)
    • 12
    • 500
    HansDouwe
    12-13-2023, 04:23 AM Go to last post

  16. Finding more than one occurrence

    Started by John Sio‎, 11-11-2023 04:13 PM
    9 Attachment(s)
    • 26
    • 772
    John Sio
    12-13-2023, 03:19 AM Go to last post

  17. [SOLVED] Average Returns

    Started by ryanhofrichter‎, 12-12-2023 09:20 PM
    • 5
    • 269
    AliGW
    12-13-2023, 03:18 AM Go to last post

  18. [SOLVED] Holiday Tracker - Can't get it to show Non Working Days / Holidays

    Started by Craigness‎, 12-12-2023 11:51 AM
    dates formula, formulas & functions, lookup & references 3 Attachment(s)
    • 2
    • 220
    AliGW
    12-13-2023, 03:13 AM Go to last post

  19. Formula If and Search

    Started by babylock99‎, 12-13-2023 01:24 AM
    • 6
    • 152
    AliGW
    12-13-2023, 02:31 AM Go to last post

  20. Oldest and Newest date base on Criteria

    Started by jlschae154‎, 12-12-2023 08:16 PM
    1 Attachment(s)
    • 2
    • 201
    CARACALLA
    12-13-2023, 12:50 AM Go to last post

  21. Question [SOLVED] Need help combining formulas

    Started by K.dc‎, 12-12-2023 09:49 AM
    3 Attachment(s)
    • 4
    • 224
    windknife
    12-12-2023, 10:20 PM Go to last post

  22. [SOLVED] input number in cell and it brings up correct event from table

    Started by MrO‎, 12-12-2023 11:04 AM
    3 Attachment(s)
    • 4
    • 157
    windknife
    12-12-2023, 10:18 PM Go to last post

  23. Help in calculation in excel

    Started by tanwarrahul‎, 12-11-2023 09:44 AM
    3 Attachment(s)
    • 12
    • 257
    josephteh
    12-12-2023, 07:05 PM Go to last post

  24. Question Using Index Match with two criteria when one of them is a numeric interval

    Started by Adrian B‎, 12-12-2023 05:00 PM
    index match criteria 1 Attachment(s)
    • 3
    • 169
    JohnTopley
    12-12-2023, 06:08 PM Go to last post

  25. Exel sheet copy drop down menu but only every third row! how to do?

    Started by Monster69‎, 12-12-2023 11:58 AM
    • 1
    • 106
    Estevaoba
    12-12-2023, 03:59 PM Go to last post

  26. [SOLVED] Using IF and adding amounts

    Started by GingerLeake‎, 12-12-2023 11:13 AM
    1 Attachment(s)
    • 2
    • 138
    GingerLeake
    12-12-2023, 01:07 PM Go to last post

  27. Exclamation Formula quit working

    Started by sllafleur‎, 12-12-2023 12:02 PM
    formula issue 1 Attachment(s)
    • 8
    • 168
    AliGW
    12-12-2023, 12:36 PM Go to last post

  28. [SOLVED] Excel sheet too big to attach

    Started by Craigness‎, 12-12-2023 11:05 AM
    • 2
    • 98
    Craigness
    12-12-2023, 11:33 AM Go to last post

  29. CONC or TEXTJOIN multiple services for clients

    Started by RookA1‎, 12-11-2023 06:42 PM
    concatenate, multiple cells, textjoin 2 Attachment(s)
    • 3
    • 175
    RookA1
    12-12-2023, 11:25 AM Go to last post

  30. Dependable drop down list based on cell value

    Started by Twixie‎, 12-12-2023 10:03 AM
    2 Attachment(s)
    • 5
    • 126
    Twixie
    12-12-2023, 11:01 AM Go to last post

  31. Conditional Format Formula - Help Please

    Started by smithnjs‎, 12-12-2023 08:36 AM
    2 Attachment(s)
    • 6
    • 133
    The_Snook
    12-12-2023, 10:09 AM Go to last post

  32. Dedup complex fields

    Started by Notsoeasy‎, 12-11-2023 12:38 PM
    3 Attachment(s)
    • 6
    • 232
    Glenn Kennedy
    12-12-2023, 07:54 AM Go to last post

  33. Post From a validation list, how to determine which cells are using it?

    Started by dvd815‎, 12-11-2023 08:06 AM
    2 Attachment(s)
    • 12
    • 274
    rorya
    12-12-2023, 07:47 AM Go to last post

  34. Formula to calculate number of employees per new location added

    Started by Ammaduddin‎, 12-12-2023 05:42 AM
    • 2
    • 170
    josephteh
    12-12-2023, 06:04 AM Go to last post

  35. How to use averageif using wildcard and absolute cell references

    Started by Darren Waters‎, 12-11-2023 04:12 PM
    2 Attachment(s)
    • 3
    • 221
    windknife
    12-12-2023, 05:51 AM Go to last post

  36. Forecasting Values

    Started by pickslides‎, 12-11-2023 01:20 AM
    1 Attachment(s)
    • 1
    • 156
    Kaper
    12-12-2023, 04:50 AM Go to last post

  37. [SOLVED] %percentage and Vlookup

    Started by kimudao‎, 12-12-2023 01:28 AM
    2 Attachment(s)
    • 11
    • 345
    HansDouwe
    12-12-2023, 04:36 AM Go to last post

  38. [SOLVED] Calculate total hours

    Started by meonly123‎, 12-11-2023 06:44 PM
    2 Attachment(s)
    • 3
    • 138
    HansDouwe
    12-11-2023, 07:43 PM Go to last post

  39. [SOLVED] Can't convert string to numbers

    Started by lynnsong986‎, 12-11-2023 06:18 PM
    1 Attachment(s)
    • 3
    • 141
    HansDouwe
    12-11-2023, 07:05 PM Go to last post

  40. [SOLVED] Calculating the number of OT hours between two times from times that cross midnight.

    Started by Maryse Roy‎, 12-11-2023 03:14 PM
    2 Attachment(s)
    • 6
    • 217
    HansDouwe
    12-11-2023, 06:44 PM Go to last post

  41. Calculating Disability premiums that needs If, Then formula

    Started by dbodero‎, 12-11-2023 01:12 PM
    • 1
    • 317
    FlameRetired
    12-11-2023, 05:37 PM Go to last post

  42. [SOLVED] Avoiding Duplicate Values when using INDEX/MATCH

    Started by CharlieVictorEcho‎, 09-14-2015 06:52 PM
    2 Attachment(s)
    • 6
    • 2,371
    FrancisM2411
    12-11-2023, 03:45 PM Go to last post

  43. Need to combine and replace multiple words in Col A sentence with one string in Col B copy

    Started by Ochimus‎, 12-11-2023 02:14 PM
    2 Attachment(s)
    • 2
    • 136
    alansidman
    12-11-2023, 03:01 PM Go to last post

  44. [SOLVED] Count of particular unique items in a list-Revisited

    Started by jomili‎, 12-11-2023 11:42 AM
    1 Attachment(s)
    • 4
    • 141
    Fluff13
    12-11-2023, 02:07 PM Go to last post

  45. [SOLVED] Datedif

    Started by MarkPr‎, 12-08-2023 08:27 AM
    1 Attachment(s)
    • 4
    • 170
    MarkPr
    12-11-2023, 01:35 PM Go to last post

  46. [SOLVED] Use LOOKUP to get 2 values from 2 cells in the same row

    Started by mtouhig‎, 12-10-2023 03:50 AM
    3 Attachment(s)
    • 15
    • 289
    mtouhig
    12-11-2023, 01:33 PM Go to last post

  47. [SOLVED] If Column is Negative, then -Sumif

    Started by FT00‎, 12-11-2023 11:41 AM
    1 Attachment(s)
    • 4
    • 182
    josephteh
    12-11-2023, 12:03 PM Go to last post

  48. [SOLVED] Help Wanted with Excel Formula for Specific Numbers

    Started by Mxmaarten‎, 12-11-2023 06:56 AM
    6 Attachment(s)
    • 9
    • 211
    AliGW
    12-11-2023, 11:26 AM Go to last post

  49. Need help converting a google sheets formula to excel

    Started by Newtonus_Prime‎, 12-06-2023 12:10 PM
    6 Attachment(s)
    • 7
    • 421
    Newtonus_Prime
    12-11-2023, 10:56 AM Go to last post

  50. Data Analysis Addon - What are the formulas for Regression Analysis to add it manually

    Started by daliye‎, 12-11-2023 08:15 AM
    • 1
    • 116
    MrShorty
    12-11-2023, 10:44 AM Go to last post
+ Post New Thread
Page 49 of 5611 FirstFirst ... 49 ...

Forum Information and Options

Users Browsing this Forum

There are currently 118 users browsing this forum. (7 members & 111 guests)

  1. DarrylBurge,
  2. dummy777,
  3. Fluff13,
  4. Kalamari,
  5. LeapyUK,
  6. sweep,
  7. ThomasB61

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