+ Post New Thread
Page 899 of 5614 FirstFirst ... 899 ...
Threads 44901 to 44950 of 280691

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. Conditional Formatting based on Cell color

    Started by kipdaballer31‎, 07-26-2019 08:37 PM
    • 1
    • 486
    6StringJazzer
    07-26-2019, 09:14 PM Go to last post

  2. [SOLVED] If statement falls between multiple date ranges

    Started by xrajncajnx‎, 07-23-2019 05:48 PM
    2 Attachment(s)
    • 6
    • 1,911
    6StringJazzer
    07-26-2019, 09:12 PM Go to last post

  3. Exclamation Booking on date and time in calendar

    Started by Mikkel_pet‎, 07-23-2019 03:28 AM
    conditional formatting, formulas, functions 3 Attachment(s)
    • 9
    • 875
    JeteMc
    07-26-2019, 06:44 PM Go to last post

  4. SUMPRODUCT(SUMIFS) Not working the way I want.

    Started by ProjectSupport‎, 07-26-2019 03:50 PM
    1 Attachment(s)
    • 4
    • 420
    TMS
    07-26-2019, 06:33 PM Go to last post

  5. How refer to a range by name in a cell

    Started by steve.in.nc‎, 07-23-2019 02:25 PM
    ranges
    • 3
    • 464
    JeteMc
    07-26-2019, 06:05 PM Go to last post

  6. Conditional Formatting to Update Column Headings

    Started by Laci07‎, 07-26-2019 04:50 PM
    • 1
    • 261
    jason.b75
    07-26-2019, 05:02 PM Go to last post

  7. Count How Often Values In One Column Have A Matching Value In Another Column

    Started by nevi‎, 07-26-2019 12:22 PM
    2 Attachment(s)
    • 3
    • 263
    MarvinP
    07-26-2019, 04:52 PM Go to last post

  8. Sequential Alphanumeric According to a Set Range

    Started by tiger6115‎, 07-26-2019 12:00 PM
    • 3
    • 352
    tiger6115
    07-26-2019, 04:04 PM Go to last post

  9. Question Formula(s) needed to calculate payroll charges based on week days in semi-monthly payroll

    Started by olemiss2‎, 07-12-2019 12:26 PM
    budget formula, factors, semi-monthly payroll, work days 6 Attachment(s)
    • 9
    • 2,276
    olemiss2
    07-26-2019, 03:55 PM Go to last post

  10. Calculate percentage of cells answered yes in a column

    Started by Alinkowski‎, 01-24-2013 04:50 PM
    1 Attachment(s)
    • 8
    • 10,410
    BrigitteWatts
    07-26-2019, 03:38 PM Go to last post

  11. Most Recent Values by Date with Index and Match

    Started by src144‎, 07-26-2019 02:50 PM
    1 Attachment(s)
    • 2
    • 447
    src144
    07-26-2019, 03:36 PM Go to last post

  12. Question [SOLVED] Averaging series of cell's based on name in separate cell

    Started by sean_bontoft‎, 07-26-2019 02:10 PM
    3 Attachment(s)
    • 10
    • 237
    Sam Capricci
    07-26-2019, 03:30 PM Go to last post

  13. Post Formula to add space before and after a digit within a string

    Started by sujitkar‎, 07-26-2019 08:13 AM
    • 9
    • 577
    maras_mak
    07-26-2019, 01:47 PM Go to last post

  14. Amounts Past Due

    Started by bj90‎, 07-26-2019 12:22 PM
    1 Attachment(s)
    • 9
    • 330
    bj90
    07-26-2019, 01:37 PM Go to last post

  15. Comparing columns where two criteria do not match & counting

    Started by chetwynd‎, 07-26-2019 12:31 PM
    2 Attachment(s)
    • 8
    • 387
    chetwynd
    07-26-2019, 01:12 PM Go to last post

  16. Customer Name If No Company Name

    Started by bj90‎, 07-26-2019 09:30 AM
    • 5
    • 226
    jason.b75
    07-26-2019, 12:58 PM Go to last post

  17. Returning next day (including weekends but excluding holidays)

    Started by cathyfirst‎, 07-25-2019 06:08 AM
    4 Attachment(s)
    • 23
    • 450
    BlindAlley
    07-26-2019, 12:32 PM Go to last post

  18. [SOLVED] Adding a decimal point in an already existing column of numbers

    Started by wheddingsjr‎, 07-25-2019 05:04 PM
    1 Attachment(s)
    • 15
    • 1,296
    AliGW
    07-26-2019, 11:51 AM Go to last post

  19. Offset function - Need to exclude SO from total calculation

    Started by sitaram86‎, 07-25-2019 10:19 AM
    3 Attachment(s)
    • 7
    • 307
    kvsrinivasamurthy
    07-26-2019, 11:44 AM Go to last post

  20. Help with auto-populating text

    Started by MrHernandez07‎, 06-20-2019 09:23 PM
    6 Attachment(s)
    • 14
    • 807
    JeteMc
    07-26-2019, 11:19 AM Go to last post

  21. [SOLVED] Nested MID formula in Index Match?

    Started by Miles6978‎, 07-26-2019 09:32 AM
    • 7
    • 1,153
    jason.b75
    07-26-2019, 11:09 AM Go to last post

  22. Question [SOLVED] Have to enter the same VLOOKUP multiple times to pull all info

    Started by Mephibosheth‎, 07-26-2019 08:43 AM
    • 7
    • 242
    AliGW
    07-26-2019, 10:38 AM Go to last post

  23. Rolling quarter based on current date

    Started by timtim91‎, 07-26-2019 09:21 AM
    • 2
    • 232
    jason.b75
    07-26-2019, 10:21 AM Go to last post

  24. Required Ageing Report

    Started by haridevadiga‎, 07-23-2019 09:15 AM
    1 Attachment(s)
    • 3
    • 327
    JeteMc
    07-26-2019, 09:57 AM Go to last post

  25. Split data with a equal total (approximately)

    Started by rajeshn_in‎, 07-26-2019 04:11 AM
    2 Attachment(s)
    • 6
    • 264
    avk
    07-26-2019, 09:20 AM Go to last post

  26. [SOLVED] Formula to validate cell values and highlight the cell if the value is not a listed

    Started by ROtis2013‎, 07-26-2019 08:22 AM
    2 Attachment(s)
    • 6
    • 267
    AliGW
    07-26-2019, 09:01 AM Go to last post

  27. Vlookup - Look for a value in a filtered list

    Started by Gemini74‎, 07-26-2019 02:11 AM
    vlookup
    • 3
    • 588
    AliGW
    07-26-2019, 08:56 AM Go to last post

  28. [SOLVED] Change name format including adjusting upper case to lower case

    Started by johnmitch38‎, 07-26-2019 06:45 AM
    2 Attachment(s)
    • 10
    • 386
    AliGW
    07-26-2019, 07:53 AM Go to last post

  29. Indirect Sheet Name Cell References

    Started by bj90‎, 07-26-2019 07:02 AM
    • 7
    • 212
    AliGW
    07-26-2019, 07:48 AM Go to last post

  30. [SOLVED] Taking away one month from another using index/match

    Started by Popcorndragon‎, 07-26-2019 07:06 AM
    1 Attachment(s)
    • 5
    • 187
    Popcorndragon
    07-26-2019, 07:35 AM Go to last post

  31. [SOLVED] Gantt chart Conditional Formatting Formula, Excel 2013.

    Started by david2020‎, 07-26-2019 07:31 AM
    1 Attachment(s)
    • 0
    • 238
    david2020
    07-26-2019, 07:31 AM Go to last post

  32. Customer Full Name or Company Name

    Started by bj90‎, 07-25-2019 09:52 AM
    • 18
    • 441
    AliGW
    07-26-2019, 06:52 AM Go to last post

  33. Index Match with pictures in Excel 365

    Started by Brontosaurus‎, 07-26-2019 05:27 AM
    1 Attachment(s)
    • 11
    • 257
    Brontosaurus
    07-26-2019, 06:27 AM Go to last post

  34. Repeating rows to calculate my roster

    Started by footballcrazyafcb‎, 07-26-2019 05:50 AM
    1 Attachment(s)
    • 3
    • 246
    footballcrazyafcb
    07-26-2019, 06:08 AM Go to last post

  35. [SOLVED] Help with IF statement

    Started by Redlittle‎, 07-26-2019 05:16 AM
    • 2
    • 284
    AliGW
    07-26-2019, 05:34 AM Go to last post

  36. Random Formula - Larger than predecessor

    Started by Xcelrion‎, 07-26-2019 12:09 AM
    2 Attachment(s)
    • 2
    • 259
    kvsrinivasamurthy
    07-26-2019, 05:03 AM Go to last post

  37. Sum multiple criteria from multiple columns and get percentage

    Started by rincyroyal‎, 07-26-2019 01:11 AM
    2 Attachment(s)
    • 3
    • 369
    rincyroyal
    07-26-2019, 04:57 AM Go to last post

  38. [SOLVED] Drag a vlookup to another sheet across columns and update the col_index_num

    Started by Fizban‎, 07-25-2019 11:26 AM
    1 Attachment(s)
    • 3
    • 576
    AliGW
    07-26-2019, 04:51 AM Go to last post

  39. Exclamation INDEX & MATCH duplicate entry

    Started by Alx19‎, 07-01-2019 01:08 AM
    3 Attachment(s)
    • 2
    • 294
    Alx19
    07-26-2019, 01:06 AM Go to last post

  40. Time series for weekly forecast

    Started by mahadeva_raobc‎, 07-26-2019 12:17 AM
    • 1
    • 153
    FDibbins
    07-26-2019, 12:37 AM Go to last post

  41. [SOLVED] Conditional formatting for multiple date scenarios relating to another cell

    Started by Alipink‎, 07-24-2019 11:32 PM
    1 Attachment(s)
    • 4
    • 273
    Alipink
    07-25-2019, 08:15 PM Go to last post

  42. Populate drop down from vlookup

    Started by ste2223‎, 07-25-2019 06:32 PM
    1 Attachment(s)
    • 1
    • 468
    AliGW
    07-25-2019, 06:35 PM Go to last post

  43. [SOLVED] Help with averaging

    Started by ReineM‎, 07-25-2019 04:57 PM
    • 3
    • 185
    ReineM
    07-25-2019, 05:44 PM Go to last post

  44. Invoice Information Based On Invoice Number

    Started by bj90‎, 07-25-2019 04:47 PM
    1 Attachment(s)
    • 1
    • 300
    AliGW
    07-25-2019, 05:35 PM Go to last post

  45. [SOLVED] Look up Name in Column A Sheet1 then Sum Colum C Sheet1 then report to column 2 on sheet 2

    Started by tacnola‎, 07-25-2019 03:10 PM
    • 3
    • 194
    Pete_UK
    07-25-2019, 05:02 PM Go to last post

  46. Switchboard Sheet List

    Started by bj90‎, 07-25-2019 03:33 PM
    1 Attachment(s)
    • 6
    • 318
    Sam Capricci
    07-25-2019, 04:44 PM Go to last post

  47. I want any values in column B that are not also in Column A to be highlighted.

    Started by PerrasB‎, 07-25-2019 03:32 PM
    • 1
    • 349
    63falcondude
    07-25-2019, 04:08 PM Go to last post

  48. Formula required to reference date range

    Started by ettyenn‎, 07-25-2019 01:42 PM
    2 Attachment(s)
    • 3
    • 304
    Olly
    07-25-2019, 03:09 PM Go to last post

  49. Exclamation Formulas in Filtered Spreadhseet

    Started by Robin_Burton‎, 07-25-2019 11:26 AM
    3 Attachment(s)
    • 20
    • 403
    63falcondude
    07-25-2019, 02:40 PM Go to last post

  50. Combine two columns in a third collumn, maintaining order

    Started by connor2290‎, 07-18-2019 09:07 AM
    1 Attachment(s)
    • 13
    • 405
    JeteMc
    07-25-2019, 02:33 PM Go to last post
+ Post New Thread
Page 899 of 5614 FirstFirst ... 899 ...

Forum Information and Options

Users Browsing this Forum

There are currently 48 users browsing this forum. (1 members & 47 guests)

  1. 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