+ Post New Thread
Page 902 of 5614 FirstFirst ... 902 ...
Threads 45051 to 45100 of 280690

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. [SOLVED] Summing numbers with n/a

    Started by Fredbugatti‎, 07-23-2019 01:09 PM
    2 Attachment(s)
    • 5
    • 259
    AliGW
    07-23-2019, 01:28 PM Go to last post

  2. [SOLVED] take the sum of cell D40, subtract it with cell D39, then spread evenly across cell range

    Started by JRP Excel Guy‎, 07-19-2019 11:42 AM
    7 Attachment(s)
    • 6
    • 524
    JeteMc
    07-23-2019, 01:28 PM Go to last post

  3. Calculating date formulas - 2 questions to create counters

    Started by bdav1216‎, 07-20-2019 09:32 AM
    1 Attachment(s)
    • 5
    • 284
    JeteMc
    07-23-2019, 12:03 PM Go to last post

  4. Table (object) rows count that references a cell

    Started by peterchclarke‎, 07-23-2019 10:40 AM
    rows, table, table row
    • 4
    • 508
    peterchclarke
    07-23-2019, 12:01 PM Go to last post

  5. Subtraction of a column from a cell

    Started by Hab3425‎, 07-23-2019 10:53 AM
    1 Attachment(s)
    • 5
    • 407
    AliGW
    07-23-2019, 11:53 AM Go to last post

  6. Unhappy [SOLVED] Conditional Formatting (Multiple Rows)

    Started by taramo66‎, 07-23-2019 10:28 AM
    conditional formatting
    • 3
    • 340
    63falcondude
    07-23-2019, 10:52 AM Go to last post

  7. Post [SOLVED] If Forumla along with AND / OR

    Started by nr6281‎, 07-22-2019 05:01 PM
    • 4
    • 269
    AliGW
    07-23-2019, 10:46 AM Go to last post

  8. Get the price from 2nd table if date falls within two dates

    Started by mpp1111‎, 07-19-2019 02:12 PM
    1 Attachment(s)
    • 3
    • 258
    mpp1111
    07-23-2019, 10:20 AM Go to last post

  9. [SOLVED] If And Or Statement Help

    Started by RoscoW88‎, 07-23-2019 09:23 AM
    • 4
    • 317
    Olly
    07-23-2019, 09:42 AM Go to last post

  10. [SOLVED] COUNTIFs: Multiple Cynamic Criteria

    Started by Beginner041699‎, 07-18-2019 08:02 AM
    4 Attachment(s)
    • 16
    • 385
    Beginner041699
    07-23-2019, 08:58 AM Go to last post

  11. IF Function 20 scenarios =(

    Started by szucchari‎, 07-22-2019 11:44 AM
    if function excel 2016, novice
    • 7
    • 405
    Kaper
    07-23-2019, 08:44 AM Go to last post

  12. Conditional format against column value of pivot table

    Started by Jacks18928‎, 07-23-2019 07:53 AM
    1 Attachment(s)
    • 1
    • 319
    63falcondude
    07-23-2019, 08:08 AM Go to last post

  13. [SOLVED] Have cell with formula show 0 till another cell shows a value.

    Started by racer3‎, 07-22-2019 06:33 PM
    1 Attachment(s)
    • 4
    • 321
    sktneer
    07-23-2019, 07:10 AM Go to last post

  14. Copy invoice numbers and info into a separate worksheet for audit trail

    Started by lydiajan‎, 07-23-2019 06:32 AM
    • 0
    • 317
    lydiajan
    07-23-2019, 06:32 AM Go to last post

  15. [SOLVED] Timesheet-Data Validation - Issues

    Started by HM1961‎, 07-20-2019 06:28 AM
    3 Attachment(s)
    • 12
    • 372
    HM1961
    07-23-2019, 06:21 AM Go to last post

  16. [SOLVED] Extracting data from a string in a cell

    Started by MartinEvans‎, 07-23-2019 04:31 AM
    • 6
    • 217
    AliGW
    07-23-2019, 05:00 AM Go to last post

  17. [SOLVED] Counting Values in a Matrix Based on Column Headers

    Started by Elainefish‎, 07-23-2019 03:47 AM
    2 Attachment(s)
    • 5
    • 302
    AliGW
    07-23-2019, 04:56 AM Go to last post

  18. Question Formula for start data and end dates to match year

    Started by ahmadhassan‎, 07-09-2019 03:23 PM
    6 Attachment(s)
    • 20
    • 825
    davsth
    07-23-2019, 04:35 AM Go to last post

  19. [SOLVED] Match Multiple column contents

    Started by blinkblink‎, 07-22-2019 03:42 AM
    excel, match and sort 3 Attachment(s)
    • 7
    • 577
    Olly
    07-23-2019, 04:03 AM Go to last post

  20. Formula to retrieve Lookup Values using multiple fields

    Started by bdav1216‎, 07-22-2019 09:55 PM
    2 Attachment(s)
    • 2
    • 585
    Glenn Kennedy
    07-23-2019, 03:02 AM Go to last post

  21. Sum Monthly Stats from Pivot Table

    Started by julesmctavish‎, 07-22-2019 06:36 PM
    1 Attachment(s)
    • 2
    • 283
    Pepe Le Mokko
    07-23-2019, 02:27 AM Go to last post

  22. Excel Formula not Dynamic

    Started by profess‎, 07-18-2019 06:42 PM
    1 Attachment(s)
    • 4
    • 305
    FDibbins
    07-22-2019, 11:51 PM Go to last post

  23. Colour to dispay based on the list of value selected in 2 column

    Started by chakkaravarthy.m‎, 07-10-2019 11:00 AM
    1 Attachment(s)
    • 4
    • 254
    FDibbins
    07-22-2019, 11:45 PM Go to last post

  24. Conditional Formatting Add 8 hours

    Started by devildogdad76‎, 07-09-2019 03:02 AM
    4 Attachment(s)
    • 20
    • 453
    devildogdad76
    07-22-2019, 11:33 PM Go to last post

  25. Dynamic IF Function HELP!

    Started by kipdaballer31‎, 07-22-2019 10:18 PM
    1 Attachment(s)
    • 1
    • 227
    protonLeah
    07-22-2019, 11:04 PM Go to last post

  26. [SOLVED] Conditional Format a cell to turn red based upon the color of another cell.

    Started by rjmall0‎, 07-22-2019 08:50 PM
    conditional formatting, formula, vba & excel 1 Attachment(s)
    • 3
    • 1,459
    Pete_UK
    07-22-2019, 09:18 PM Go to last post

  27. [SOLVED] Finding average price between to dates.

    Started by Prof Sick‎, 07-21-2019 05:24 PM
    1 Attachment(s)
    • 3
    • 271
    Pete_UK
    07-22-2019, 08:54 PM Go to last post

  28. Average of sale for products

    Started by Deepi84‎, 07-22-2019 12:23 PM
    1 Attachment(s)
    • 5
    • 278
    Logit
    07-22-2019, 06:51 PM Go to last post

  29. Data validation: copy the total figure from column B into the correct analysis column

    Started by CJW01‎, 07-19-2019 07:08 AM
    • 3
    • 360
    JeteMc
    07-22-2019, 06:38 PM Go to last post

  30. [SOLVED] Vlookup name in column 1 and text string in column 2 and bring that cell in column 2

    Started by luajambeiro‎, 07-19-2019 11:50 AM
    6 Attachment(s)
    • 9
    • 481
    luajambeiro
    07-22-2019, 06:12 PM Go to last post

  31. Retrieve Unique Values from Columns in Multiple Worksheets

    Started by philchi‎, 07-22-2019 02:34 PM
    2 Attachment(s)
    • 3
    • 267
    tim201110
    07-22-2019, 04:55 PM Go to last post

  32. [SOLVED] combining vlookup and hlookup to extract data on another sheet

    Started by DaveLearner‎, 07-22-2019 07:32 AM
    2 Attachment(s)
    • 4
    • 442
    Aardigspook
    07-22-2019, 04:54 PM Go to last post

  33. [SOLVED] Formatting to change row colour

    Started by candymycandy‎, 07-17-2019 11:49 AM
    • 3
    • 267
    Aardigspook
    07-22-2019, 04:53 PM Go to last post

  34. Comparing 2 separate columns in 2 separate Excel sheets

    Started by DuHast1996‎, 07-16-2019 12:02 AM
    3 Attachment(s)
    • 10
    • 498
    Olly
    07-22-2019, 04:42 PM Go to last post

  35. [SOLVED] WORKDAY function with IF statement so if there is no date the field is left blank

    Started by pairofjacks‎, 07-22-2019 02:44 PM
    • 3
    • 2,022
    protonLeah
    07-22-2019, 04:09 PM Go to last post

  36. [SOLVED] Need help with 2 parts on determining MTD results

    Started by mrteater‎, 07-22-2019 03:33 PM
    • 1
    • 212
    Keebellah
    07-22-2019, 03:46 PM Go to last post

  37. Find MAX value from a large range of similar entries

    Started by cengineer91‎, 07-22-2019 03:14 PM
    1 Attachment(s)
    • 1
    • 242
    CARACALLA
    07-22-2019, 03:32 PM Go to last post

  38. [SOLVED] Use of AND ...

    Started by jmueller0823‎, 07-22-2019 01:54 PM
    • 2
    • 213
    jmueller0823
    07-22-2019, 02:31 PM Go to last post

  39. How to populate name if within date range

    Started by kipdaballer31‎, 07-22-2019 01:53 PM
    • 1
    • 196
    protonLeah
    07-22-2019, 02:26 PM Go to last post

  40. Mutiple Vlookups in one formula

    Started by Fredbugatti‎, 07-22-2019 01:19 PM
    • 6
    • 247
    AliGW
    07-22-2019, 01:28 PM Go to last post

  41. [SOLVED] Formula to calculate the FTE Month on Month

    Started by arun.sj‎, 07-22-2019 07:37 AM
    dates comparison, dates difference, days between dates, formula and functions, if condition 3 Attachment(s)
    • 5
    • 1,722
    Naren_Kumar
    07-22-2019, 01:27 PM Go to last post

  42. Creating a Schedule/Forecast

    Started by Woody23‎, 07-22-2019 01:13 PM
    1 Attachment(s)
    • 1
    • 314
    AliGW
    07-22-2019, 01:23 PM Go to last post

  43. [SOLVED] Formula to calculate the number of days between dates (month wise)

    Started by arun.sj‎, 07-22-2019 10:01 AM
    days between dates, days calulation, formula and functions, formula and if statement, if condition in excel 3 Attachment(s)
    • 4
    • 514
    Kaper
    07-22-2019, 12:51 PM Go to last post

  44. How do I rank cells from high to low?

    Started by lanespoli‎, 07-17-2019 11:52 AM
    data, rank, sort 2 Attachment(s)
    • 8
    • 895
    JeteMc
    07-22-2019, 12:30 PM Go to last post

  45. [SOLVED] Min - max value based on the value of another cell

    Started by fatfish1969‎, 06-28-2019 10:09 AM
    4 Attachment(s)
    • 7
    • 624
    FlameRetired
    07-22-2019, 12:27 PM Go to last post

  46. Function for FileLen

    Started by Seth_‎, 07-19-2019 12:23 PM
    • 5
    • 463
    Seth_
    07-22-2019, 12:08 PM Go to last post

  47. [SOLVED] Moving string of numbers with commas to separate columns

    Started by junada0‎, 07-22-2019 11:03 AM
    columns, commas
    • 4
    • 357
    junada0
    07-22-2019, 11:34 AM Go to last post

  48. Formula to CAP another value

    Started by Kcroft9‎, 07-22-2019 06:11 AM
    1 Attachment(s)
    • 4
    • 339
    XLent
    07-22-2019, 10:20 AM Go to last post

  49. [SOLVED] Converting information to more presentable data

    Started by Pubhub‎, 07-22-2019 03:44 AM
    3 Attachment(s)
    • 9
    • 958
    Pubhub
    07-22-2019, 09:58 AM Go to last post

  50. Stock Data Function Excel 2016

    Started by djungst‎, 07-21-2019 07:35 PM
    previous close, stock, update
    • 2
    • 470
    djungst
    07-22-2019, 09:42 AM Go to last post
+ Post New Thread
Page 902 of 5614 FirstFirst ... 902 ...

Forum Information and Options

Users Browsing this Forum

There are currently 41 users browsing this forum. (1 members & 40 guests)

  1. CARACALLA

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