+ Post New Thread
Page 391 of 5614 FirstFirst ... 391 ...
Threads 19501 to 19550 of 280695

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. Red face arabic and english text are are not concatenated properly

    Started by hasan mougharbel‎, 11-30-2021 06:22 AM
    1 Attachment(s)
    • 2
    • 460
    DJunqueira
    11-30-2021, 08:39 AM Go to last post

  2. [SOLVED] I need to extract dates from a column that contains other information. Format varies.

    Started by LewisSR‎, 11-30-2021 07:21 AM
    2 Attachment(s)
    • 13
    • 354
    AliGW
    11-30-2021, 08:25 AM Go to last post

  3. [SOLVED] Find result from different page for corresponding name

    Started by Marvo‎, 11-30-2021 06:58 AM
    1 Attachment(s)
    • 2
    • 202
    Marvo
    11-30-2021, 07:12 AM Go to last post

  4. [SOLVED] How do i get everything right of a character in cells

    Started by emerald_joc‎, 11-29-2021 07:09 PM
    1 Attachment(s)
    • 7
    • 540
    emerald_joc
    11-30-2021, 06:53 AM Go to last post

  5. Formula required to calculate monthly totals from a list

    Started by marchingontogether‎, 11-30-2021 04:29 AM
    3 Attachment(s)
    • 5
    • 220
    AliGW
    11-30-2021, 05:32 AM Go to last post

  6. [SOLVED] Look for value in several sheets

    Started by entillanna‎, 11-29-2021 09:19 AM
    2 Attachment(s)
    • 7
    • 295
    Glenn Kennedy
    11-30-2021, 04:19 AM Go to last post

  7. Excel Formula for Changing Last Digit

    Started by Breck09‎, 11-29-2021 05:11 PM
    • 7
    • 308
    TMS
    11-30-2021, 04:09 AM Go to last post

  8. [SOLVED] Why v lookup is not showing the result

    Started by akshay6s‎, 11-29-2021 08:41 AM
    3 Attachment(s)
    • 7
    • 282
    AliGW
    11-30-2021, 03:56 AM Go to last post

  9. Different result in total interest paid (cumipmt vs loan ammortization table)

    Started by hdjc‎, 05-27-2020 02:42 AM
    1 Attachment(s)
    • 8
    • 1,014
    curiouscat408
    11-30-2021, 03:21 AM Go to last post

  10. Formula help to determine when a number first occurs after another

    Started by KTB01‎, 11-30-2021 02:27 AM
    1 Attachment(s)
    • 1
    • 207
    AliGW
    11-30-2021, 02:54 AM Go to last post

  11. Return all matches values

    Started by Peelah‎, 11-30-2021 12:44 AM
    index and small, index match, small 3 Attachment(s)
    • 4
    • 380
    Crooza
    11-30-2021, 02:14 AM Go to last post

  12. problem with datedif function if difference between dates needs to return a negative value

    Started by PeterOD‎, 11-29-2021 09:48 PM
    2 Attachment(s)
    • 3
    • 532
    FDibbins
    11-30-2021, 12:38 AM Go to last post

  13. Need help fixing vlookup formula or formatting

    Started by dlittle4‎, 11-29-2021 07:49 PM
    • 7
    • 325
    Gregb11
    11-29-2021, 11:41 PM Go to last post

  14. Parking Fees

    Started by spiralcookie‎, 11-21-2021 08:58 PM
    3 Attachment(s)
    • 16
    • 571
    Estevaoba
    11-29-2021, 10:37 PM Go to last post

  15. = 1 if 0% < A2< 2:5% formula

    Started by ymarei‎, 11-29-2021 01:54 PM
    • 5
    • 272
    GeoffW283
    11-29-2021, 06:33 PM Go to last post

  16. Problem RMZ Function

    Started by Mason12‎, 11-29-2021 01:58 PM
    • 5
    • 427
    GeoffW283
    11-29-2021, 04:36 PM Go to last post

  17. [SOLVED] Color fonts and formulas in different colors

    Started by jomili‎, 11-29-2021 01:48 PM
    • 3
    • 242
    Fluff13
    11-29-2021, 03:49 PM Go to last post

  18. [SOLVED] Conditional Formatting with Searching for Values

    Started by Webbers‎, 11-29-2021 11:58 AM
    1 Attachment(s)
    • 4
    • 253
    Bernie Deitrick
    11-29-2021, 01:41 PM Go to last post

  19. Vlookup with conditional formatting

    Started by Kcadzow‎, 11-22-2021 07:49 AM
    2 Attachment(s)
    • 11
    • 355
    Fluff13
    11-29-2021, 12:59 PM Go to last post

  20. [SOLVED] Conditional formatting to change the month to a colour on a calander

    Started by paulanderson‎, 11-28-2021 03:06 PM
    2 Attachment(s)
    • 2
    • 334
    paulanderson
    11-29-2021, 12:56 PM Go to last post

  21. [SOLVED] Drop-down menu with the exclusion of empty cells

    Started by Berna11‎, 11-29-2021 11:49 AM
    1 Attachment(s)
    • 3
    • 352
    JohnTopley
    11-29-2021, 12:48 PM Go to last post

  22. Pivot table calculated Field function slow

    Started by HKworker‎, 11-29-2021 12:24 PM
    • 0
    • 376
    HKworker
    11-29-2021, 12:24 PM Go to last post

  23. Trying to get Xlookup to look at 2 Tables

    Started by gjjh25‎, 11-29-2021 07:09 AM
    1 Attachment(s)
    • 1
    • 300
    Glenn Kennedy
    11-29-2021, 10:53 AM Go to last post

  24. [SOLVED] Formula in cell help

    Started by jimpatel1993‎, 11-29-2021 09:27 AM
    3 Attachment(s)
    • 5
    • 224
    Fluff13
    11-29-2021, 10:26 AM Go to last post

  25. [SOLVED] how to retreive column headings according to cell reference

    Started by akshay6s‎, 11-22-2021 07:42 AM
    3 Attachment(s)
    • 7
    • 536
    JeteMc
    11-29-2021, 10:13 AM Go to last post

  26. [SOLVED] in excel How do I create a dropdown list that populates a row from a range of 4 columns

    Started by Divsion8‎, 11-16-2021 12:37 PM
    drop down, excel, list excel 2 Attachment(s)
    • 6
    • 639
    JeteMc
    11-29-2021, 10:10 AM Go to last post

  27. [SOLVED] Combining two columns of data with no duplicates resulting in empty cell and/or 0

    Started by lilsnoop‎, 11-22-2021 03:28 PM
    1 Attachment(s)
    • 5
    • 448
    JeteMc
    11-29-2021, 10:08 AM Go to last post

  28. Help - Dynamic Drop Downs

    Started by Steve-1974‎, 11-29-2021 06:45 AM
    2 Attachment(s)
    • 6
    • 255
    Steve-1974
    11-29-2021, 09:53 AM Go to last post

  29. Question Copying from one tab to another..but only up to the first blank entry

    Started by MrMarmite‎, 11-29-2021 08:46 AM
    • 1
    • 165
    DJunqueira
    11-29-2021, 09:29 AM Go to last post

  30. How to identify which patients have two types of samples collected?

    Started by mhzg‎, 11-28-2021 07:02 PM
    • 5
    • 256
    Gregb11
    11-29-2021, 07:53 AM Go to last post

  31. Get cell to be as near zero as possible by deducting several cell values from a start cell

    Started by gjjh25‎, 11-28-2021 12:57 PM
    3 Attachment(s)
    • 7
    • 252
    gjjh25
    11-29-2021, 07:04 AM Go to last post

  32. [SOLVED] Index match from another tab

    Started by rayted‎, 11-29-2021 06:29 AM
    index, match 1 Attachment(s)
    • 5
    • 602
    AliGW
    11-29-2021, 06:37 AM Go to last post

  33. [SOLVED] Formula to calculate average

    Started by shiva_reshs‎, 11-29-2021 03:29 AM
    3 Attachment(s)
    • 8
    • 228
    AliGW
    11-29-2021, 04:58 AM Go to last post

  34. How to calculate investment return with contribution and withdrawal

    Started by needhelp13‎, 11-29-2021 12:03 AM
    3 Attachment(s)
    • 3
    • 1,327
    curiouscat408
    11-29-2021, 04:21 AM Go to last post

  35. index and match formula with an if condition

    Started by jay.tee‎, 11-28-2021 03:57 AM
    1 Attachment(s)
    • 2
    • 337
    DJunqueira
    11-29-2021, 04:17 AM Go to last post

  36. I NEED SOME HELP ON SUM a criteria with a specific name

    Started by Khail‎, 11-29-2021 01:09 AM
    1 Attachment(s)
    • 1
    • 166
    FDibbins
    11-29-2021, 01:16 AM Go to last post

  37. Searching multiple fields using MATCH (with OFFSET) and INDEX functions

    Started by rburch1979‎, 11-28-2021 06:50 PM
    excel & formula 2 Attachment(s)
    • 4
    • 258
    DJunqueira
    11-28-2021, 11:04 PM Go to last post

  38. [SOLVED] Create a rolling 4 week/13 week avaerage, only taking into account full weeks

    Started by scottmc13‎, 11-17-2021 05:55 AM
    2 Attachment(s)
    • 3
    • 249
    WideBoyDixon
    11-28-2021, 09:09 PM Go to last post

  39. Probability Function

    Started by worldkarma‎, 11-20-2021 11:45 PM
    5 Attachment(s)
    • 8
    • 506
    curiouscat408
    11-28-2021, 08:21 PM Go to last post

  40. Reference Input Excel Multiple Regression

    Started by m1e‎, 11-28-2021 04:32 PM
    multiple regression, reference, regression 1 Attachment(s)
    • 4
    • 464
    RaulSerg
    11-28-2021, 07:02 PM Go to last post

  41. [SOLVED] Sumproduct search text criteria

    Started by sirdon‎, 11-28-2021 06:10 AM
    • 7
    • 302
    DJunqueira
    11-28-2021, 06:54 PM Go to last post

  42. [SOLVED] What does B3# mean in this formula?

    Started by curiouscat408‎, 11-28-2021 01:29 PM
    • 8
    • 1,008
    TMS
    11-28-2021, 06:35 PM Go to last post

  43. [SOLVED] Midnight time?

    Started by Frigide‎, 11-28-2021 05:05 PM
    • 2
    • 195
    Frigide
    11-28-2021, 05:57 PM Go to last post

  44. [SOLVED] Number of different dates based on multiple criteria

    Started by danielfr‎, 11-28-2021 04:40 AM
    4 Attachment(s)
    • 25
    • 335
    AliGW
    11-28-2021, 05:18 PM Go to last post

  45. Calculations - Vlookup

    Started by YRSTRULY‎, 11-28-2021 02:56 PM
    pivot, vlookup 1 Attachment(s)
    • 2
    • 363
    AliGW
    11-28-2021, 05:13 PM Go to last post

  46. [SOLVED] UDF code to find last populated cell in a range of columns without using a loop technique

    Started by KenGWilson‎, 11-25-2021 02:26 PM
    avoiding loops, colour coding, udf 1 Attachment(s)
    • 10
    • 396
    KenGWilson
    11-28-2021, 03:17 PM Go to last post

  47. Return Large or Small value when criteria is met

    Started by fdjaynes‎, 11-28-2021 01:20 PM
    2 Attachment(s)
    • 3
    • 248
    Fluff13
    11-28-2021, 02:03 PM Go to last post

  48. [SOLVED] Ratios and percentages to calculate average cost

    Started by CaptainMCH‎, 11-26-2021 10:49 PM
    1 Attachment(s)
    • 3
    • 335
    AliGW
    11-28-2021, 12:43 PM Go to last post

  49. [SOLVED] Dynamic array solution sought for totals

    Started by paulma1960‎, 11-27-2021 08:34 AM
    4 Attachment(s)
    • 14
    • 423
    Fluff13
    11-28-2021, 10:17 AM Go to last post

  50. LOOKUP Last entry in a column

    Started by dallen442‎, 11-27-2021 10:45 PM
    isblank, lookup column
    • 2
    • 312
    Phuocam
    11-28-2021, 08:58 AM Go to last post
+ Post New Thread
Page 391 of 5614 FirstFirst ... 391 ...

Forum Information and Options

Users Browsing this Forum

There are currently 70 users browsing this forum. (2 members & 68 guests)

  1. DeeWuu,
  2. ExcelNewbie92

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